Hi,

Does anyone know of any website where I can find an explanation of SQL2025 error numbers? In particular, I'm getting the error code '6' [[ SQL2025N An I/O error "6" occurred on media]] so a description of the error number would be very helpful.

Thanks in advance!

For SQL erors, you want the Message Reference, Vol. 2
http://www-1.ibm.com/support/docview...id=swg27009554

Also look in the db2diag.log for additional information. The error code '6' in this case "may" refer to a tablespace id, but that is just a guess on my part.

Thank you! I will check it out..no, I don't think it's a tablespace id..basically, I'm trying to backup the database to an NFS system and it keeps complaining and won't create a backup image successfully. I looked in the db2diag.log file but it didn't seem to be very helpful.

What is in the db2diag output (after you set the DIAGLEVEL to 4)?

Hello,

Here is the output from the db2diag.log file... any idea what is going on? Thx!



2007-11-19-18.45.02.437486+000 I953521489G393 LEVEL: Warning
PID : 7924 TID : 16384 PROC : db2agent (MAR_DB)
INSTANCE: dbins NODE : 000 DB : MAR_DB
APPHDL : 0-62 APPID: *LOCAL.dbins.071119190503
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:2025
MESSAGE : Starting an online incremental db backup.

2007-11-19-18.45.02.493050+000 I953521883G346 LEVEL: Warning
PID : 29983 TID : 16384 PROC : db2med.7924.0
INSTANCE: dbins NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloflock, probe:100
MESSAGE : errno:
DATA #1 : Hexdump, 4 bytes
0xBFFFCD8C : 2500 0000 %...

2007-11-19-18.45.02.493593+000 I953522230G352 LEVEL: Severe
PID : 29983 TID : 16384 PROC : db2med.7924.0
INSTANCE: dbins NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluInitFileDevice, probe:49
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFFD3F8 : 0600 0F85 ....

2007-11-19-18.45.02.493840+000 I953522583G325 LEVEL: Warning
PID : 29983 TID : 16384 PROC : db2med.7924.0
INSTANCE: dbins NODE : 000
FUNCTION: DB2 UDB, database utilities, sqluMCInitBackupMC, probe:80
MESSAGE : Media controller -- device initialization warning (zrc = 0x850f0006)


2007-11-19-18.45.02.494069+000 I953522909G738 LEVEL: Severe
PID : 7924 TID : 16384 PROC : db2agent (MAR_DB)
INSTANCE: dbins NODE : 000 DB : MAR_DB
APPHDL : 0-62 APPID: *LOCAL.dbins.071119190503
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 74 bytes
0x62044E84 : 17F8 FFFF 36FF 2F6D 6E74 2F45 3144 4154 ....6./mnt/MAR_
0x62044E94 : 415F 7370 6172 726F 772F 6261 636B 7570 sparrow/bkup
0x62044EA4 : 2F45 4E45 5247 5931 2E30 2E6E 7267 312E /MAR_DB.0.dbins.
0x62044EB4 : 4E4F 4445 3030 3030 2E43 4154 4E30 3030 NODE0000.CATN000
0x62044EC4 : 302E 3230 3037 3131 3100 0.2007111.



2007-11-19-18.45.02.494434+000 I953523648G440 LEVEL: Severe
PID : 7924 TID : 16384 PROC : db2agent (MAR_DB)
INSTANCE: dbins NODE : 000 DB : MAR_DB
APPHDL : 0-62 APPID: *LOCAL.dbins.071119190503
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:10
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFEDB14 : 17F8 FFFF ....

2007-11-19-18.45.02.521914+000 I953524089G437 LEVEL: Warning
PID : 7924 TID : 16384 PROC : db2agent (MAR_DB)
INSTANCE: dbins NODE : 000 DB : MAR_DB
APPHDL : 0-62 APPID: *LOCAL.dbins.071119190503
FUNCTION: DB2 UDB, oper system services, sqloflock, probe:100
MESSAGE : errno:
DATA #1 : Hexdump, 4 bytes
0xBFFE8B44 : 2500 0000 %...

2007-11-19-18.45.02.540752+000 I953524527G356 LEVEL: Severe
PID : 7924 TID : 16384 PROC : db2agent (MAR_DB)
INSTANCE: dbins NODE : 000 DB : MAR_DB
APPHDL : 0-62 APPID: *LOCAL.dbins.071119190503
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:140
MESSAGE : Backup Terminated.

Hi Marcus,

I went and checked the Message Reference for the sql code. This is all I could find:

SQL2025N An I/O error code occurred on media dir/devices. Explanation: An I/O error occurred while accessing a file on the specified media. The utility stops processing. User Response: Record the error return code. Determine whether the I/O error can be corrected.

I couldn't find a list of error codes anywhere. Is there any other place I can find it? Thx!

Based on the information, I had short look at the DB2 code and what I can tell you is that DB2 tries to lock the file /mnt/MAR_sparrow/... to which the backup shall be written. However, since this file is on an NFS volume, and NFS does not support such locks, the respective "fcntl" call fails and sets errno 37 (=0x25). At least on Linux, errno=37 stands for ENOLCK (see /usr/include/asm-generic/errno.h). Now, the locking fails, in which case DB2 won't attempt to write the backup image.

In short: you can't backup to an NFS volume.

You could try another shared file system like Samba or AFS or whatever you may have available. Alternatively, backup to a local file system and then copy the backup image to your NFS.

Thanks for the info stolze! Do you think I can enable locking on the NFS system? How would I do that? I was reading somewhere about a 'no locks' option... can I edit fstab with this option or do you think DB2 needs to lock a file no matter what?

DB2 will try to acquire a lock on the file. Your only option is - if possible - to add (or activate) locking for NFS. How have you mounted this file system (options)?