Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009
    Posts
    6

    Unanswered: Db2 Database disk error.

    Hi,

    I am facing database corruption issue in Db2 express C 9.5, Windows Vista.
    The issues does not have fixed reproducible steps,
    however, following are some scenario.

    1. New database get corrupted just after it creation.
    2. Newly created database is fine but other existing database gets
    corrupted.
    3. While using database for some time, one of the existing database gets corrupted.

    The error that get logged in db2diag is similar for above conditions.

    "A disk error occurred. Subsequent SQL statements cannot be processed. The SQL state is 58005". The sql code is sqlcode: -980. db2diag.log attached.

    It suggest that there was some access problem with temporary space. Even if I try to restore them, they dont get restored properly and complaints abouts insufficient size of system temporary space.

    The log is attached and following are some error from it.

    2010-11-09-16.49.50.970000+540 I27553H559 LEVEL: Error
    PID : 5688 TID : 4924 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000 DB : DEVDB1
    APPHDL : 0-7 APPID: *LOCAL.DB2INST1.101109074943
    AUTHID : SYSTEM
    EDUID : 4924 EDUNAME: db2agent (DEVDB1)
    FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:871
    MESSAGE : ZRC=0x870F0155=-2029059755=SQLO_DIR_NOT_EMPTY
    "The I/O operation fails because the target directory is not empty."

    2010-11-09-16.49.50.970000+540 I28114H559 LEVEL: Error
    PID : 5688 TID : 4924 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000 DB : DEVDB1
    APPHDL : 0-7 APPID: *LOCAL.DB2INST1.101109074943
    AUTHID : SYSTEM
    EDUID : 4924 EDUNAME: db2agent (DEVDB1)
    FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:871
    DATA #1 : String, 106 bytes
    Error releasing container 0 (D:\DB2INST1\NODE0000\DEVDB1\T0000001\C0000000.TMP ) for tbsp 1. Rc = 870F0155

    2010-11-09-16.55.40.061000+540 I53626H561 LEVEL: Error
    PID : 5688 TID : 4924 PROC : db2syscs.exe
    INSTANCE: DB2INST1 NODE : 000 DB : DEVDB1
    APPHDL : 0-16 APPID: ::1.53453.101109075539
    AUTHID : DEVDB1USER
    EDUID : 4924 EDUNAME: db2agent (DEVDB1)
    FUNCTION: DB2 UDB, buffer pool services, sqlbReadPoolOneFile, probe:955
    MESSAGE : ZRC=0x86020019=-2046689255=SQLB_CSUM "Bad Page, Checksum Error"
    DIA8426C A invalid page checksum was found for page "".

    What can be the cause of this problem? Any help about this will be appreciable.

    Regards,
    Lalit
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Not sure, but I recall that this version was only certified for XP proffesional. The new 9.7.2. does support Vista.

  3. #3
    Join Date
    Apr 2009
    Posts
    6
    One observation, SQLTAG.NAM file is not present
    in C:\DB2\NODE0000\DEVDB1\T0000001\C0000000.TMP folder of corrupted Database, which is present in working Database. The default temporary table space is system automatic managed.

  4. #4
    Join Date
    Apr 2009
    Posts
    6
    Quote Originally Posted by dr_te_z View Post
    Not sure, but I recall that this version was only certified for XP proffesional. The new 9.7.2. does support Vista.
    It does support windows vista. Could not locate any fix related to the problem in 9.7.2.

    Thanks.

Posting Permissions

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