IBM Support

IT06445: "ANR0102E ERROR 1202 INSERTING ROW IN TABLE "DF.BITFILES"" DURING "MOVE DATA/NODEDATA" TO DISK POOL USING CACHE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A "move data" or "move nodedata" to a disk storage pool may show
    the following type of error:
    ANR0102E dfcreate.c(1950): Error 1202 inserting row in table
    "DF.Bitfiles"
    
    This happens because of a conflict between the moved data and
    the cached data in the disk pool.
    The following conditions must be true for this APAR to match:
     - The disk storage pool has caching activated.
     - The moved data was first stored in this disk storage pool and
    then migrated to the next storage pool.
     - The migrated data will be moved from the next storage pool
    back to the original disk pool which still has the cached data
    (for example for better restore performance from disk instead of
    slow sequential media)
    
    Tivoli Storage Manager Versions Affected:  7.1  on all platforms
    
    Initial Impact: Medium
    
    Additional Keywords:   TSM tsm71 cache caching
    

Local fix

  • Two solutions:
      1. Disable caching on the disk storage pool by doing: "update
    stg <stgname> cache=no"   , and clear cached data by doing a
    move data for all the disk storage pool volumes using same
    source and target storage pool: "move data <volume-name>" .
      2. Use another disk pool as target for the data movement.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing levels when available.                          *
    * This problem is currently projected to be fixed in levels    *
    * 7.1.1.200 and 7.1.3.                                         *
    * 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 number

    IT06445

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-01-13

  • Closed date

    2015-01-19

  • Last modified date

    2015-01-19

  • 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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT06445

Modified date: 19 January 2015