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

Subscribe

You can track all active APARs for this component.

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 number

    IC64505

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-13

  • Closed date

    2009-12-02

  • Last modified date

    2010-05-08

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager

Software version:

61W

Reference #:

IC64505

Modified date:

2010-05-08

Translate my page

Machine Translation

Content navigation