Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    11

    Unanswered: Backup failing with deadlock error

    Hi,

    I am getting a deadlock error while trying to do an online full backup. The database version is 8.2 and hosted in Windows. The following are extracted from db2diag.log file.

    db2diag.log extract
    -------------------
    2006-10-30-00.16.38.281000+060 I197804H383 LEVEL: Warning
    PID : 1532 TID : 1540 PROC : db2syscs.exe
    INSTANCE: LDAPDB2 NODE : 000 DB : LDAPDB2
    APPHDL : 0-149 APPID: *LOCAL.LDAPDB2.061029231625
    FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:2025
    MESSAGE : Starting an online db backup.

    2006-10-30-00.21.58.671000+060 I198189H448 LEVEL: Error
    PID : 1532 TID : 2984 PROC : db2syscs.exe
    INSTANCE: LDAPDB2 NODE : 000
    APPHDL : 0-149
    FUNCTION: DB2 UDB, database utilities, SqlubTableLock::request, probe:153
    DATA #1 : String, 60 bytes
    Error upgrading lock.
    PoolId: 0, ObjectId: 99, Intent: 3.
    DATA #2 : Hexdump, 4 bytes
    0x05DABF04 : 4400 1080 D...

    2006-10-30-00.21.58.703000+060 I198639H373 LEVEL: Severe
    PID : 1532 TID : 2984 PROC : db2syscs.exe
    INSTANCE: LDAPDB2 NODE : 000
    APPHDL : 0-149
    FUNCTION: DB2 UDB, database utilities, sqlubreadsms, probe:16
    MESSAGE : DiagData
    DATA #1 : Hexdump, 8 bytes
    0x09E8A5E0 : 4400 1080 4400 0000 D...D...

    2006-10-30-00.21.58.734000+060 I199014H354 LEVEL: Error
    PID : 1532 TID : 2984 PROC : db2syscs.exe
    INSTANCE: LDAPDB2 NODE : 000
    APPHDL : 0-149
    FUNCTION: DB2 UDB, database utilities, sqlubreadsms, probe:2216
    DATA #1 : Hexdump, 8 bytes
    0x09E8A5E0 : 4400 1080 4400 0000 D...D...

    2006-10-30-00.21.59.984000+060 I199370H359 LEVEL: Severe
    PID : 1532 TID : 1540 PROC : db2syscs.exe
    INSTANCE: LDAPDB2 NODE : 000 DB : LDAPDB2
    APPHDL : 0-149 APPID: *LOCAL.LDAPDB2.061029231625
    FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:140
    MESSAGE : Backup Terminated.

    2006-10-30-00.22.40.703000+060 I199731H410 LEVEL: Error
    PID : 1532 TID : 4360 PROC : db2syscs.exe
    INSTANCE: LDAPDB2 NODE : 000 DB : LDAPDB2
    APPHDL : 0-158 APPID: *LOCAL.LDAPDB2.061029232240
    FUNCTION: DB2 UDB, buffer pool services, sqlbQryPoolCont, probe:1311
    RETCODE : ZRC=0x87020076=-2029911946=SQLB_INV_POOLID "Invalid pool ID"
    ------------------------------------------------------------------------

    On analysis of the same, it seems the lock is in Object id : 99. I find that the object is "sysibm.systables". I did a reorg of the same and it temporarily removed the problem. The backups succeded for next 2 days. But again its failing with the same error.

    Can anyone provided me a solution to it. Let me know if any more informations are needed.

    Thanks in advance.

  2. #2
    Join Date
    Oct 2006
    Posts
    11
    FYI..... its a LDAP database

Posting Permissions

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