IC68132: DEADLOCK MAY OCCUR WHEN EXPIRE INVENTORY PROCESS IS RUNNING.

IBM Tivoli Storage Manager V6.1 Fix Pack 4 (6.1.4) Server Downloads

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 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