IC64505: RECLAMATION MAY FAIL WITH ANR0103E MESSAGE DUE TO INVALID ATTEMPT TO UPDATE A DATABASE ROW

IBM Tivoli Storage Manager V6.1 Fix Pack 3 (6.1.3) Server Downloads

APAR status

• Closed as program error.

Error description

• A reclamation process may fail with the following sequence of
  messages if a deduplicated storage pool has been defined and
  utilized on the TSM Server:
  .
  11/10/2009 14:12:16 ANR0162W Supplemental database diagnostic
  information: -1:23513:-545 ([IBM][CLI Driver][DB2/NT64] SQL0545N
  The requested operation is not allowed because a row does not
  satisfy the check constraint "TSMDB1.AF_CLUSTERS.AFCL_XX".
  SQLSTATE=23513). (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR0157W Database operation UPDATE for table
  AF.Clusters failed with result code 8 and tracking ID:
  000000001374F208. (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR0158W Database operation UPDATE for table
  AF.Clusters failed with operation code 8 and tracking id
  000000001374F208. The data for column 0 is: (int32)XX.
  (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR0158W Database operation UPDATE for table
  AF.Clusters failed with operation code 8 and tracking id
  000000001374F208. The data for column 1 is: (int32)0.
  (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR0158W Database operation UPDATE for table
  AF.Clusters failed with operation code 8 and tracking id
  000000001374F208. The data for column 2 is: (int32)XX.
  (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR0158W Database operation UPDATE for table
  AF.Clusters failed with operation code 8 and tracking id
  000000001374F208. The data for column 3 is: (int32)X.
  (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR0103E aftxn.c(1330): Error 8 updating row
  in table "AF.Clusters". (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR0103E aftxn.c(1434): Error 87 updating
  row in table "AF.Vol.Clusters". (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR1181E aftxn.c(309): Data storage
  transaction 0:XXXXXX was aborted. (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR2183W afmove.c(6605): Transaction
  0:XXXXXX was aborted. (SESSION: XXXX, PROCESS: XX)
  11/10/2009 14:12:16 ANR1093E Space reclamation is ended for
  volume XXXXXX. The transaction is ended. (SESSION: XXXX,
  PROCESS: XX)
  .
  The failure occurs because of an invalid attempt to reuse an
  aggregate id from a deduplicated storage pool. Aggregate
  information for a deduplicated storage pool is exclusive to that
  particular storage pool and cannot be shared with any other
  storage pool.
  If no deduplicated storage pools have ever been defined to the
  TSM Server than this APAR would most likely not apply.
  .
  NOTE: The MOVE DATA and NODEDATA commands may also encounter the
  same problem if the RECONSTRUCT parameter  is set to YES
  (default).
  .
  Additionally, delete volume can show an error:
  
  ANR2017I Administrator ADMIN issued command: DELETE VOLUME
  
  H:\TSM\STGPOOL\000012AB.BFS discard=y
  ANR0984I Process 257 for DELETE VOLUME (DISCARD DATA) started in
  the
  BACKGROUND at 23:05:43.
  ANR2222I Discard Data process started for volume
  H:\TSM\STGPOOL\000012AB.BFS (process ID 257).
  ANR0405I Session 1638 ended for administrator ADMIN (WinNT).
  ANR9999D_3373732133 bfDestroy(bfcreate.c:1063) Thread<48>:
  Invalid
  length for bitfile 594707266
  ANR9999D_0524624341 ImDeleteBitfile(imutil.c:9160) Thread<48>:
  Unexpected rc=87 from bfDestroy for objId 594707266
  ANR2229W Discard data process terminated for volume
  H:\TSM\STGPOOL\000012AB.BFS - internal server error detected.
  .
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager Versions 6.1 on all platforms
  .
  .
  Initial Impact:
  Medium
  .
  .
  Additional Keywords:
  zz61 move data nodedata invalid reconstruction reconstruct
  

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 level 6.1.3.                              *
  *                 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