IT19675: SEQUENTIAL TO SEQUENTIAL BACKUP STGPOOL FAILS WITH ANR0102E ERROR 1202 WHEN DAMAGED FRAGMENTS EXIST

8.1.8.000-IBM-SPOC-Linuxs390x
8.1.8.000-IBM-SPSRV-Linuxppc64le
8.1.8.000-IBM-SPCMS-WindowsX64
8.1.8.000-IBM-SPCMS-WindowsI32
8.1.8.000-IBM-SPCMS-Linuxx86_64
8.1.8.000-IBM-SPOC-WindowsX64
8.1.8.000-IBM-SPOC-Linuxx86_64
8.1.8.000-IBM-SPOC-LinuxPPC64le
8.1.8.000-IBM-SPOC-AIX
8.1.8.000-IBM-SPSRV-WindowsX64
8.1.8.000-IBM-SPSRV-Linuxx86_64
8.1.8.000-IBM-SPSRV-Linuxs390x
8.1.8.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 8 (V8.1.8) Downloads

APAR status

• Closed as program error.

Error description

• When damaged fragments exist in a copy stgpool BACKUP STGPOOL
  can fail during a copy attempt.  If the fragment in the
  primary stgpool has been deduplicated the problem will not
  occur.
  .
  Customer/L2 Diagnostics:
  The server activity log will report the following during the
  BACKUP STGPOOL process:
  .
  ANR0102E bfsaggr.c(2042): Error 1202 inserting row in table
  "BF.Super.Aggregates".
  ANR1181E aftxn.c(367): Data storage transaction 0:336702039
  was aborted.
  .
  A dbcli dbstmt dbcmd af bf df as ss trace will show the
  following:
  .
  05:33:15.589 [84986][afcputil.c][5889][CopyBatch]:Copying
  bitfile batch SrvId=0, PoolId=<n>, Ck1=<n>, Ck2=<n>,
  Count=1, for volume <volname>(28423)
  .
  05:33:15.589 [84986][bfcopy.c][233][BfCopy]:Copying bitfile
  <bfid> from pool <n> to pool <n>
  .
  05:36:11.998 [84986][tbcli.c][6872][BuildStmt]:Entry with
  inRowArg1186c3868, stmtBuildNeeded False and thisOp 0.
  05:36:11.998 [84986][tbcli.c][7156][BuildStmt]:EXITING rc=0
  with stmt'INSERT INTO "TSMDB1"."BF_SUPER_AGGREGATES" (OBJID,
  SEQUENCE,POOLID,FRAGID,BFID,HDR,USERBYTES,PENDINGID,CK1,CK2)
  VALUES(?,?,?,?,?,?,?,?,?,?)--84986'.
  05:36:11.998 [84986][bfsaggr.c][2203]
  [RdbPrepareAndExecuteStmt]:
  Preparing statement based on isPrepared False (prepLen 0 vs
  stmtLen 146), (STMT='INSERT INTO
  "TSMDB1"."BF_SUPER_AGGREGATES"(OBJID,SEQUENCE,POOLID,FRAGID,
  BFID,HDR,USERBYTES,PENDINGID,
  CK1,CK2) VALUES(?,?,?,?,?,?,?,?,?,?) --84986').
  05:36:11.999 [84986][tbcli.c][4702][RdbPrepareAndExecuteStmt]:
  Executing statement 'INSERT INTO
  "TSMDB1"."BF_SUPER_AGGREGATES" (OBJID,SEQUENCE,
  POOLID,FRAGID,BFID,HDR,USERBYTES,PENDINGID,CK1,CK2) VAL
  UES(?,?,?,?,?,?,?,?,?,?) --84986' submitted from bfsaggr.c
  (2203).
  05:36:12.000 [84986][tbcli.c][4785][RdbPrepareAndExecuteStmt]:
  EXITING with rc 1202 (sqlRc -1) for statement 'INSERT INTO
  "TSMDB1"."BF_SUPER_AGGREGATES" (OBJID,SEQUENCE,POOLID,FRAGID,
  BFID,HDR,USERBYTES,PENDINGID,CK1,CK2) VALUES
  (?,?,?,?,?,?,?,?,?,?) --84986'submitted from bfsaggr.c(2203).
  05:36:12.000 [84986][tbcli.c][4015][RdbCliInsert]:Exiting with
  rc=1202.
  05:36:12.000 [84986][tbcli.c][1217][tbCliSRInsDel]:EXITING,
  rc=1202.
  05:36:12.000 [84986][bfsaggr.c][2206][PutConsoleMsg]:ANR0102E
  bfsaggr.c(2206): Error 1202 inserting row in table
  "BF.Super.Aggregates".~
  05:36:12.000 [84986][bfsaggr.c][2210][BfCatalogFragment]:
  Exit, rc 1202
  .
  Initial Impact: Low
  .
  IBM Spectrum Protect Versions Affected:
  IBM Spectrum Protect server levels 7.1.0 and higher
  .
  Additional Keywords:
  Fragment damage tape file
  

Local fix

• Confirm the copy pool objects are indeed damaged using audit
  volume fix=no.  If they are damaged, move the good data to
  another volume and delete the damaged data using delete volume
  discarddata=yes. During the next backup stgpool the object
  will be rewritten to the copy pool.
  

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.8. Note that this is      *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, HP-UX, Solaris,
  Linux, and Windows.
  Platforms fixed:  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