Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2002
    Posts
    123

    Unanswered: Description of error codes for SQL2025N

    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!
    Last edited by db2user; 11-21-07 at 03:05.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Dec 2002
    Posts
    123
    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.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    What is in the db2diag output (after you set the DIAGLEVEL to 4)?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Dec 2002
    Posts
    123
    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.

  6. #6
    Join Date
    Dec 2002
    Posts
    123
    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!

  7. #7
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  8. #8
    Join Date
    Dec 2002
    Posts
    123
    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?

  9. #9
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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)?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •