IT17589: ANR0104E ERROR 2345 DELETING ROW FROM TABLE "BF.AGGREGATED.BITFILES" REPORTED DURING EXPIRATION

APAR status

• Closed as unreproducible in next release.

Error description

• Tivoli Storage Manager expiration process might report the
  following:
  ANR0104E bfaggrut.c(3898): Error 2345 deleting row from table
  "BF.Aggregated.Bitfiles".
  
  To verify if you are exposed  by the APAR symptom collect the
  following docs and provide them to IBM support for review and
  compilation of the next steps to confirm the APAR:
  The following SQL commands can be used to identify the affected
  objects:
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  db2 "select bfbe.superbfid, bfbe.bfid, bfbe.poolid from
  bf_bitfile_extents bfbe left join af_bitfiles afbf on
  (bfbe.superbfid=afbf.bfid and bfbe.poolid=afbf.poolid) where
  afbf.bfid is null" > bfbe_afbf-error2345.txt
  db2 "select bfbe.superbfid, bfbe.bfid, bfbe.poolid from
  bf_bitfile_extents bfbe left join af_segments afsg on
  (bfbe.superbfid=afsg.bfid and bfbe.poolid=afsg.poolid) where
  afsg.bfid is null" > bfbe_afsg-error2345.txt
  
    Tivoli Storage Manager Versions Affected: 6.3 7.1
    Initial Impact: Low
    Additional Keywords: technote #1963118 TSM IBM Spectrum
  Protect
  

Local fix

• apply fixing level once available. The fix will prevent from new
  objects being created that match the APAR.
  To clean up from existing objects, contact IBM support and ask
  for assistance to go through the dedup repair process
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server users                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix level when available. This problem is currently    *
  * fixed in levels 6.3.6 and 7.1.4.                             *
  ****************************************************************
  

Problem conclusion

• This problem was fixed
  Affect platforms: AIX 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