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

IBM Tivoli Storage Manager (TSM) server V7.1.1.x interim fix downloads

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 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