Direct links to fixes
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
7.1.8.000-TIV-TSMSRV-AIX
7.1.8.000-TIV-TSMSRV-HP-UX
7.1.8.000-TIV-TSMSRV-Linuxppc64
7.1.8.000-TIV-TSMSRV-Linuxs390x
7.1.8.000-TIV-TSMSRV-Linuxx86_64
7.1.8.000-TIV-TSMSRV-SolarisSPARC
7.1.8.000-TIV-TSMSRV-WIN
7.1.8.000-TIV-TSMOC-AIX
7.1.8.000-TIV-TSMOC-Linuxx64
7.1.8.000-TIV-TSMOC-Windows
7.1.8.000-TIV-TSMOC-LinuxPPC64
7.1.8.000-TIV-TSMOC-LinuxPPC64le
7.1.8.000-TIV-TSMOC-LinuxS390
IBM Spectrum Protect Server V8.1 Fix Pack 2 (V8.1.2) Downloads
APAR status
Closed as program error.
Error description
IBM Spectrum Protect AUDIT CONTAINER command might log ANR0106E with error 1114 for table "SD.Chunk.Locations": 04/13/2017 08:31:24 ANR0984I Process 201 for AUDIT CONTAINER (SCAN) started in the BACKGROUND at 08:31:24 AM. (SESSION: 739494, PROCESS: 201) 04/13/2017 08:31:24 ANR4886I Audit Container (Scan) process started for container <CONTAINERNAME> (process ID 201). (SESSION: 739494, PROCESS: 201) 04/13/2017 08:31:53 ANR0106E sdrtrv.c(2560): Unexpected error 1114 fetching row in table "SD.Chunk.Locations". (SESSION: 739494, PROCESS: 201) .. 04/13/2017 08:33:40 ANR0106E sdrtrv.c(2560): Unexpected error 1114 fetching row in table "SD.Chunk.Locations". (SESSION: 739494, PROCESS: 201) 04/13/2017 08:35:19 ANR4891I AUDIT CONTAINER process 201 ended for the <CONTAINERNAME> container: 136881 data extents inspected, 0 data extents marked as damaged, 0 data extents previously marked as damaged reset to undamaged, and 0 data extents marked as orphaned. (SESSION: 739494, PROCESS: 201) 04/13/2017 08:35:19 ANR0986I Process 201 for AUDIT CONTAINER (SCAN) running in the BACKGROUND processed 136,881 items for a total of 12,681,356,194 bytes with a completion state of SUCCESS at 08:35:19 AM. (SESSION: 739494, PROCESS: 201) The symptom is seen if the background deletion engine running in parallel deletes a damaged chunk before that chunk got audited. IBM Spectrum Protect Versions Affected: 7.1.3 and newer, 8.1.0 and newer Customer/L2 Diagnostics (If Applicable) To verify that you are looking at this APAR get the poolid from the SHOW SSPOOL command: tsm: SERVER>sh sspool -> Pool CONTAINER(5): Strategy=40, ClassId=2147483647, ClassName=$DEDUP$, ... The poolid is the numeric value in brackets after the poolname, in the example above 5. Then do the following from a DB2 command window: db2 connect to tsmdb1 db2 set schema tsmdb1 db2 "select * from sd_dedup_audit sdda left join sd_chunk_locations sdcl on ( sdda.id=sdcl.chunkid and sdda.poolid=sdcl.poolid ) left join sd_non_dedup_locations sdndl on ( sdda.id=sdndl.chunkid and sdda.poolid=sdndl.poolid ) where sdcl.chunkid is NULL and sdndl.chunkid is NULL and sdda.poolid=<POOLID>" Replace <POOLID> with the poolid from the SHOW SSPOOL command. If the select command returns an empty result this APAR is confirmed. Initial Impact: Low Additional Keywords: TSM
Local fix
ignore the message
Problem summary
**************************************************************** * USERS AFFECTED: * * All IBM Spectrum Protect server users. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed in level 8.1.2. Note that this is * * subject to change at the discretion of IBM. * ****************************************************************
Problem conclusion
This problem was fixed. Affected platforms: AIX, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT20289
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-04-20
Closed date
2017-05-26
Last modified date
2017-05-26
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
Document Information
Modified date:
11 September 2024