IBM Support

IT04864: REPAIR OCCUPANCY MIGHT FAIL WITH ANR0162W/ANR0106E

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • he Tivoli Storage Manager server currently has a limitation in
    the number of objects to be trackable via the occupancy table
    for a given node and filespace pair.
    If a REPAIR OCCUPANCY is run against such a node/filespace
    combination, the process will end with
    
    ANR0162W Supplemental database diagnostic information:
     -1:22003:-802 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0802N
      Arithmetic overflow or other arithmetic exception
     occurred.  SQLSTATE=22003). (SESSION: 1810, PROCESS: 29)
    ANR0106E bfutil.c(9203): Unexpected error 2343 fetching
     row in table "AF.Bitfiles". (SESSION: 1810, PROCESS: 29)
    ANR0106E bfutil.c(9204): Unexpected error 2343 fetching
     row in table "BF.Aggregate.Attributes". (SESSION: 1810,
     PROCESS: 29)
    
    As dedup splits large objects into much smaller chunks that must
    be individually tracked, node/filespaces backed up to a dedup
    pool are more likely exposed to this APAR.
    
    The problem is only related to occupancy and does not affect the
    integrity or restorability of the data.
    
      Tivoli Storage Manager Versions Affected: all supported
      L2 Diagnostics (If Applicable)
    
    Check if any of the bfaa columns exceeds 2,147,483,647:
      db2 connect to tsmdb1
      db2 set schema tsmdb1
     db2 "select afbf.poolid, afbf.ck1, afbf.ck2, sum(
    cast(bfaa.numfiles as bigint) ), sum( cast(bfaa.numchunks as
    bigint) ) FROM TSMDB1.bf_aggregate_attributes AS bfaa LEFT JOIN
    TSMDB1.af_bitfiles AS afbf ON (afbf.srvid=bfaa.srvid AND
    afbf.bfid=bfaa.superbfid) group by afbf.poolid, afbf.ck1,
    afbf.ck2 order by afbf.poolid, afbf.ck1, afbf.ck2 FOR READ ONLY
    WITH CS"
    
      Initial Impact: Low
      Additional Keywords: TSM
    

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 7.1.3.  Note that   *
    * this is subject to change at the discretion of IBM.          *
    ****************************************************************
    

Problem conclusion

  • The problem was fixed.
    Affected Platforms: AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT04864

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-10

  • Closed date

    2015-02-12

  • Last modified date

    2015-02-12

  • 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

  • R62A PSY

       UP

  • R62H PSY

       UP

  • R62L PSY

       UP

  • R62S PSY

       UP

  • R62W PSY

       UP

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • 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 #: IT04864

Modified date: 12 February 2015