IC77773: MANY "ANR0158W DATABASE OPERATION XXXX FOR TABLE YYYY FAILED WITH OPERATION CODE 224" ISSUED DURING INDEX REORGANIZATION

APAR status

• Closed as program error.

Error description

• Problem Description:
  
  When performing Tivoli Storage Manager index reorganization,
  the DB2 reorganization process and the Tivoli Storage Manager
  server processes become deadlocked attempting to obtain locks.
  This problem does not occur with table reorganization.
  
  You will see several of the following messages in the server
  activity log:
  
  ANR0158W Database operation <operation> for table
  <server table> failed with operation code 224 and tracking
  id <tracking id>. The data for column <col Id> is:
  (<specific data to the error>. (SESSION: <session num>)
  
  You might also see these and other similar messages:
  ANR0103E admnode.c(14203): Error 224 updating row in
  table "Nodes". (SESSION: <session num>)
  ANR0104E afutil.c(2134): Error 224 deleting row from
  table "AF.Damaged". (PROCESS: <process id>)
  ANR1133E Migration is ended for volume <volume Id>.
  An internal server error is detected. (PROCESS: <process id>)
  
  This APAR is fixed by the new server option
  DB_DB2_KEEPTABLELOCK.  When this APAR is closed, the
  closing text will include full information concerning
  that new server option.
  
  
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Server versions 6.1 and 6.2
  
  Initial Impact:
  medium
  
  Additional Keywords:
  zz61 zz62 TSM index reorganization lock contention deadlock
  DB2_KEEPTABLELOCK
  

Local fix

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.5.1, and 6.2.3.                *
  *                 Note that this is subject to change at the   *
  *                 discretion of IBM.                           *
  *                                                              *
  *                 After applying the fixing level, if you      *
  *                 are running index reorganization, do the     *
  *                 following:                                   *
  *                 1) Halt the server                           *
  *                 2) Place the following line into your        *
  *                 server options file                          *
  *                 DB_DB2_KEEPTABLELOCK NO                      *
  *                 3) Restart the server                        *
  *                                                              *
  *                 Additional details about this option is      *
  *                 available in Technote #1452146:              *
  *                 http://www.ibm.com/support/                  *
  *                 docview.wss?uid=swg21452146                  *
  ****************************************************************
  *
  

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

• 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