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

8.1.2.000-IBM-SPSRV-AIX
8.1.2.000-IBM-SPSRV-Linuxppc64le
8.1.2.000-IBM-SPCMS-Linuxx86_64
8.1.2.000-IBM-SPCMS-WindowsI32
8.1.2.000-IBM-SPSRV-Linuxs390x
8.1.2.000-IBM-SPCMS-WindowsX64
8.1.2.000-IBM-SPSRV-Linuxx86_64
8.1.2.000-IBM-SPSRV-WindowsX64
8.1.2.000-IBM-SPOC-AIX
8.1.2.000-IBM-SPOC-LinuxPPC64le
8.1.2.000-IBM-SPOC-Linuxs390x
8.1.2.000-IBM-SPOC-Linuxx86_64
8.1.2.000-IBM-SPOC-WindowsX64
IBM Spectrum Protect Server V8.1 Fix Pack 2 (V8.1.2) Downloads
IBM Spectrum Protect Server V7.1 Fix Pack 8 (7.1.8.000) Downloads

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