IT20289: 'AUDIT CONTAINER' COMMAND MIGHT REPORT 'ANR0106E UNEXPECTED ERROR 1114 FETCHING ROW 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
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 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