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.

FYI..... its a LDAP database