Direct links to fixes
8.1.10.000-IBM-SPOC-WindowsX64
8.1.10.000-IBM-SPOC-Linuxx86_64
8.1.10.000-IBM-SPOC-Linuxs390x
8.1.10.000-IBM-SPOC-LinuxPPC64le
8.1.10.000-IBM-SPOC-AIX
8.1.10.000-IBM-SPCMS-WindowsX64
8.1.10.000-IBM-SPCMS-WindowsI32
8.1.10.000-IBM-SPCMS-Linuxx86_64
8.1.10.000-IBM-SPSRV-WindowsX64
8.1.10.000-IBM-SPSRV-Linuxx86_64
8.1.10.000-IBM-SPSRV-Linuxs390x
8.1.10.000-IBM-SPSRV-Linuxppc64le
8.1.10.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack (V8.1.10) Downloads
APAR status
Closed as program error.
Error description
he activity log reports many ANR0162W and ANR0103E messages with error 2343 for table SD.Chunk.Locations. The messages are due to reaching a negative value 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". Customer/L2 Diagnostics: If the following db2 select statement returns 1, you are affected by this APAR: As instance owner run: db2 connect to TSMDB1 db2 set schema tsmdb1 db2 "select count from sd_chunk_locations where refcount<0 for read only with ur" Note: This issue is different from APAR IT19597 where the problem is that the refcounts go too high, while in this APAR it get a negative value. IBM Spectrum Protect Server version Affected: IBM Spectrum Protect Server v7.1.x and 8.1.x on all platforms Initial Impact: Medium Additional Keywords: ANR0162W ANR0103E SQL0802N 2343 SD.Chunk.Locations IT19597 TS002618144
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All IBM Spectrum Protect server users of container type * * storage pools. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be * * fixed in level 8.1.10.000. 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, and Windows. Platforms fixed: AIX, Linux, Windows.
Temporary fix
Comments
APAR Information
APAR number
IT30600
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
81L
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-10-15
Closed date
2019-11-18
Last modified date
2020-11-19
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
R81A PSY
UP
R81L PSY
UP
R81W PSY
UP
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"81L"}]
Document Information
Modified date:
26 August 2021