By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,610 Members | 2,310 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,610 IT Pros & Developers. It's quick & easy.

Error backing up DB2 database on Linux to NFS system

P: 6
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!
Nov 20 '07 #1
Share this Question
Share on Google+
2 Replies


docdiesel
Expert 100+
P: 297
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
Dec 1 '07 #2

P: 6
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!
Dec 8 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.