IC93516: DATABASE DEADLOCK OCCURS AT SERVER STARTUP AFTER UPGRADE

IBM Tivoli Storage Manager V6.3 Fix Pack 5 (6.3.5.000) Server Downloads

APAR status

• Closed as program error.

Error description

• When the Tivoli Storage Manager server starts, it will
  create an index for every table and will update
    PREFETCHSIZE to AUTO if the value is not already set.
    However, an ALTER TABLESPACE command is issued as well
    to update the PREFETCHSIZE to AUTOMATIC thus causing a
    deadlock to occur and the CREATE INDEX has to rollback.
  
    The deadlock occurs because the CREATE INDEX process
    starts off with an UPDATE lock on a system table but then
    wants to convert the UPDATE to an EXCLUSIVE lock. Since
    the ALTER TABLESPACE has a SHARE lock on the same table
    the deadlock occurs and the CREATE INDEX has to rollback.
  
    The above scenario can be switched as well meaning the
    ALTER TABLESPACE could request the EXCLUSIVE lock and
    cause the deadlock to occur. This would then cause the
    ALTER TABLESPACE to rollback.
  
  Tivoli Storage Manager Versions Affected:
    6.2.4 and 6.3.0 and above
  
  Customer/L2 Diagnostics (If Applicable)
    The following messages can be seen when starting the
    Tivoli Storage Manager server in the foreground:
  
      ANR0159E dbicmd.c(240): Database deadlock detected on
        5:1.
      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).
  
    The db2diag.log shows the following:
  
      2013-04-30-14.28.41.016154+000 I324441A548 LEVEL: Error
      PID     : 18481152    TID  : 62046     PROC : db2sysc 0
      INSTANCE: tsmsv1      NODE : 000       DB   : TSMDB1
      APPHDL  : 0-791       APPID: *LOCAL.tsmsv1.130430142827
      AUTHID  : TSMSV1
      EDUID   : 62046         EDUNAME: db2agent (TSMDB1) 0
      FUNCTION: DB2 UDB, catalog services, sqlrlCatalogScan::
                update, probe:70
      RETCODE : ZRC=0x80100002=-2146435070=SQLP_LDED "Dead
                lock detected" DIA8002C A deadlock has
                occurred, rolling back transaction.
  Initial Impact:
    Low
  Additional Keywords:
    UPGRADE TSM ADSM ITSM DEADLOCK
  

Local fix

• Log into your system as the Tivoli Storage Manager
    instance owner and issue the commands below from the
    operating system command prompt:
  
      db2 connect to TSMDB1
      db2 "select * FROM TSMDB1.GLOBAL_ATTRIBUTES where
        owner='ADM' and name='TBSP_PREFETCH_AUTO'"
  
    If there no rows selected, this indicates the tablespaces
    prefetch has not been set yet. Proceed with the commands
    below.
  
      db2 "ALTER TABLESPACE IDXSPACE1 PREFETCHSIZE AUTOMATIC"
      db2 "ALTER TABLESPACE LARGESPACE1 PREFETCHSIZE
        AUTOMATIC"
      db2 "ALTER TABLESPACE LARGEIDXSPACE1 PREFETCHSIZE
        AUTOMATIC"
  
    Use the commands below to verify settings:
      db2 "select tbspace,tbspaceid,prefetchsize from syscat.
        tablespaces"
  
    Confirm that tablespace IDXSPACE1, LARGESPACE1,
    LARGEIDXSPACE1 has prefetchsize "-1", which means they
    are now set to "AUTO".
    If all steps finish successfully, run the commands below
    to set the Tivoli Storage Manager database:
  
      db2 "insert into TSMDB1.GLOBAL_ATTRIBUTES (OWNER, NAME,
      TYPE,INT32) VALUES ('ADM', 'TBSP_PREFETCH_AUTO', 3, 1)"
  

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 level 6.3.5. Note that this is subject    *
  *                 to change at the discretion of IBM.          *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Solaris, Linux and Windows.
  

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

• R63A PSY

     UP

• R63H PSY

     UP

• R63L PSY

     UP

• R63S PSY

     UP

• R63W PSY

     UP

• R63Z PSY

     UP