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

Subscribe

You can track all active APARs for this component.

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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager

Software version:

61A

Reference #:

IC68132

Modified date:

2010-05-18

Translate my page

Machine Translation

Content navigation