IBM Support

IT19597: ACTIVITY LOG REPORTS ANR0162W AND ANR0103E SDREFCOUNT.C ERROR 2343 IN TABLE SD.CHUNK.LOCATIONS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The actlog reports many ANR0162W and ANR0103E messages with
    error 2343 for table SD.Chunk.Locations.  The messages are due
    to reaching the internal maximum value allowed for the REFCOUNT
    column.
    
    Example messages:
    ANR0162W Supplemental database diagnostic information:
     -1:22003:-802 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0802N
    Arithmetic overflow or other arithmetic exception
     occurred.  SQLSTATE=22003).
    ANR0103E sdrefcount.c(576): Error 2343 updating row in
    table "SD.Chunk.Locations".
    
    IBM Spectrum Protect Versions Affected: 7.1.3, 7.1.4, 7.1.5,
    7.1.6, 7.1.7 and 8.1
    
    Customer/L2 Diagnostics
    Find the extents that have reached the threshold:
    db2 "select * from sd_chunk_locations where refcount >
    2000000000"
    
    Initial Impact: Low
    
    Additional Keywords: flood repeated messages
    

Local fix

  • Request assistance from level two support or wait for fixing
    level
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All IBM Tivoli Storage Manager and Spectrum Protect server   *
    * users.                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be                                              *
    * fixed in levels 7.1.8 and 8.1.2. Note that this is subject   *
    * to change at the discretion of IBM.                          *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    
    Affected platforms for reported release:  AIX, Linux, Solaris
    and
    Windows.
    Platforms fixed:   AIX, Linux, Solaris and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT19597

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-08

  • Closed date

    2017-06-15

  • Last modified date

    2017-06-15

  • 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

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT19597

Modified date: 15 June 2017