A fix is available
APAR status
Closed as program error.
Error description
Deadlock may occur when expire inventory process is running. The root cause is that dedup cleanup threads that run in the background ran into a conflict with the expiration thread. Actlog says: ANR0159E dbieval.c(863): Database deadlock detected on 17:2. ANR0162W Supplemental database diagnostic information: -1:40001:-911 ([IBM][CLI Driver][DB2/AIX64] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001). ANR0103E bfdedup.c(9296): Error 19 updating row in table "BF.Queued.Chunks". ANR0136I Table updating statistics performed successfully for 9 of 9. ANR4532W The total DB used in DB space is 135939 megabytes, and the total space available in the DB space is 143360 megabytes. The ratio is 0.95. db2diag.log says: 2010-XX-YY-ZZ.40.04.398755+540 E281284A539 LEVEL: Warning PID : 458850 TID : 6942 PROC : db2sysc 0 INSTANCE: db2tsm NODE : 000 DB : TSMDB1 APPHDL : 0-536 APPID: *LOCAL.db2tsm.100415074538 AUTHID : DB2TSM EDUID : 6942 EDUNAME: db2agent (TSMDB1) 0 FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3 MESSAGE : ADM5502W The escalation of "697857" locks on table "TSMDB1 .BF_QUEUED_CHUNKS" to lock intent "X" was successful. 2010-XX-YY-ZZ.40.20.592390+540 E281824A545 LEVEL: Warning PID : 458850 TID : 6942 PROC : db2sysc 0 INSTANCE: db2tsm NODE : 000 DB : TSMDB1 APPHDL : 0-536 APPID: *LOCAL.db2tsm.100415074538 AUTHID : DB2TSM EDUID : 6942 EDUNAME: db2agent (TSMDB1) 0 FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:3 MESSAGE : ADM5502W The escalation of "697856" locks on table "TSMDB1 .BF_DEREFERENCED_CHUNKS" to lock intent "X" was successful. TSM Versions Affected: TSM 6.1.0.0 and above Initial Impact: Middle Additional Keywords: expiration zz61 Initial Impact: Low
Local fix
Expiration will retry the file one time and if unsuccessful will skip the node and pick it up next time.
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users. * **************************************************************** * PROBLEM DESCRIPTION: See ERROR DESCRIPTION. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in levels 6.1.4 and 6.2.1. * * Note that this is subject to change at the * * discretion of IBM. * **************************************************************** See ERROR DESCRIPTION.
Problem conclusion
The described problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
IC68132
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-23
Closed date
2010-05-18
Last modified date
2010-05-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
TSM SERVER
Fixed component ID
5698ISMSV
Applicable component levels
R61A PSY
UP
R61H PSY
UP
R61L PSY
UP
R61S PSY
UP
R61W PSY
UP
R62A PSY
UP
R62H PSY
UP
R62L PSY
UP
R62S PSY
UP
R62W PSY
UP
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61A"}]
Document Information
Modified date:
17 September 2021