DB2 for Linux - Backup to NFS filesystem?

[Ember]

I'm trying to take an offline backup on Linux to an NFS mounted
filesystem. I have no trouble creating files or directories manually
in this filesystem. Here's the df -h for it:
Filesystem Size Used Avail Use% Mounted on
<IPaddressHere - ommitted>:/db2backup
84G 677M 82G 1% /mnt1
Each time I try the backup, no matter what buffer size I use, I get:
SQL2025N An I/O error "" occurred on media "6".
No return code, and a media of "6" - strange. And this is written to
the db2diag.log:
2003-10-30-09.58.04.927844 Instance:crawl Node:000
PID:7190(db2med.16302.0) Appid:none
oper_system_services sqloflock Probe:36

errno: 2500 0000 %...
2003-10-30-09.58.04.932820 Instance:crawl Node:000
PID:7190(db2med.16302.0) Appid:none
database_utilities sqluifdev Probe:49

DiagData
06d6 ffff ....
2003-10-30-09.58.04.935664 Instance:crawl Node:000
PID:7190(db2med.16302.0) Appid:none
database_utilities sqluMCInitBackupMC Probe:80

Media controller -- device initialization warning

2003-10-30-09.58.04.938661 Instance:crawl Node:000
PID:16302(db2agent (FOUNTAIN)) Appid:*LOCAL.crawl.03103014420
database_utilities sqlubMWResponse Probe:5 Database:FOUNTAIN

DiagData
17f8 ffff ff36 ff2f 6d6e 7431 2f46 4f55 .....6./mnt1/FOU
4e54 4149 4e2e 302e 6372 6177 6c2e 4e4f NTAIN.0.crawl.NO
4445 3030 3030 2e43 4154 4e30 3030 302e DE0000.CATN0000.
3230 3033 3130 3330 3039 3538 3034 2e30 20031030095804.0
3031 00 01.
2003-10-30-09.58.04.944622 Instance:crawl Node:000
PID:16302(db2agent (FOUNTAIN)) Appid:*LOCAL.crawl.03103014420
database_utilities sqlubMWResponse Probe:10 Database:FOUNTAIN

DiagData
17f8 ffff ....
2003-10-30-09.58.04.954810 Instance:crawl Node:000
PID:16302(db2agent (FOUNTAIN)) Appid:*LOCAL.crawl.03103014420
database_utilities sqlubcka Probe:0 Database:FOUNTAIN

Backup terminated.

Any suggestions on what I migth try? We've done this on AIX before,
but never on Linux, so I'm worried that backups to NFS on Linux simply
aren't supported.

Thanks,
Ember

[susanwlm]

In article <7c*************************@posting.google.com> ,
Ember <da****@hotmail.com> wrote:

I'm trying to take an offline backup on Linux to an NFS mounted
filesystem. I have no trouble creating files or directories manually
in this filesystem. Here's the df -h for it:
Filesystem Size Used Avail Use% Mounted on
<IPaddressHere - ommitted>:/db2backup
84G 677M 82G 1% /mnt1
Each time I try the backup, no matter what buffer size I use, I get:
SQL2025N An I/O error "" occurred on media "6".
No return code, and a media of "6" - strange. And this is written to
the db2diag.log:
2003-10-30-09.58.04.927844 Instance:crawl Node:000
PID:7190(db2med.16302.0) Appid:none
oper_system_services sqloflock Probe:36

errno: 2500 0000 %...

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.

WW
--
Susan Williams
Technical Lead, DB2 on Linux
su******@vnet.ibm.com