Error backing up DB2 database on Linux to NFS system

[db2user24]

Hello,

I keep getting this error after trying to do an online backup of the DB2 database to an NFS filesystem:

SQL2025N An I/O error "6" occurred on media ...

Has anyone ever seen this error? Any idea on how to fix it?

I read somewhere on one of the posts here that it may be a locking issue. Here is a response to someone who had the same exact problem that I have:

That's an ENOLCK (errno = 37, or 25 hex). It means that DB2 is trying
to lock a file but can't. I suspect your nfs mounting options are not
allowing locking over nfs.

Here is the thread that has the above answer... I looked at the db2diag.log file and am getting the same errors too.

http://www.thescripts.com/forum/thread180582.html

If this is the solution, does anyone know how to enable locking over nfs? I have options in fstab set to default.

Thanks for the help!

[docdiesel]

Hi,

I once had a similar problem, doing a load from an NFS filesystem. Never found out why, but the load was working fine after mounting the remote NFS share with UDP instead of TCP.Perhaps this may help.

Regards,

Bernd

[db2user24]

Hi,

I once had a similar problem, doing a load from an NFS filesystem. Never found out why, but the load was working fine after mounting the remote NFS share with UDP instead of TCP.Perhaps this may help.

Regards,

Bernd

Thanks for the help!