IT33110: REMOVE STGPROTECTION CAN FAIL WITH SQL0802N ARITHMETIC OVERFLOW ERROR

8.1.11.000-IBM-SPSRV-WindowsX64
8.1.11.000-IBM-SPSRV-Linuxx86_64
8.1.11.000-IBM-SPSRV-Linuxs390x
8.1.11.000-IBM-SPSRV-Linuxppc64le
8.1.11.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 11 (V8.1.11) Downloads

APAR status

• Closed as program error.

Error description

• Error Description:
  
  Performing the command REMOVE STGPROTECTION can fail with the
  following error logged in the activity log :
  
  ANR0162W Supplemental database diagnostic information:
  -1:22003:-802 ([IBM][CLI Driver][DB2/LINUXPPC64LE] SQL0802N
  Arithmetic overflow or other arithmetic exception occurred.
  SQLSTATE=22003).
  ANR0106E sdrepl.c(18726): Unexpected error 2343 fetching row in
  table "SD.Replicated.Chunks".
  ANR0985I Process nn for REMOVE STGPROTECTION running in the
  BACKGROUND completed with completion state FAILURE
  
  This is caused when the number of rows returned back for removal
  exceeds 2 billion.
  
  Customer/Support Diagnostics (If Applicable)
  
  If the above message is seen, follow the steps below to
  determine the number of rows being removed :
  
  1) On the original server where the storage pool is located,
  obtain the poolid of the storage pool, replacing POOL with the
  appropriate name :
  
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  db2 "select poolid from ss_pools where poolname='POOL'"
  
  2) On the server where your performing the REMOVE STGPROTECTION
  command, issue :
  
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  db2 "select * from replicating_servers"
  
  Using this output, obtain the server name associated with the
  pool being removed and the server id associated with that
  server.
  
  At this point, the poolid and server id is known. Keeping a note
  of the poolid , issue the following replacing X with the server
  id :
  
  db2 "select count_big as count, srvid, poolid, replpoolid,
  chunktype, flags from sd_replicated_chunks where srvid=X  group
  by srvid, poolid, replpoolid, chunktype, flags for read only
  with ur"
  
  This will list the quantity (count) being removed for that
  server id and the pool id noted, will be seen within the
  replpoolid column. If this exceeds 2 billion, this issue is
  being seen.
  
  
  
  IBM Spectrum Protect Versions Affected:
  All server versions 8.1.7 and higher
  
  Initial Impact:
  Medium
  
  
  Additional Keywords:
  TSM, TS003535584, "storage pool", extents, chunks, delete
  

Local fix

• An alternate way to remove protection, is to use the
  cleanupOldSrvId perl script obtainable from IBM support.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server users of REMOVE            *
  * STGPROTECTION                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in levels 8.1.10.100, and 8.1.11.      *
  * 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

• R81A PSY

     UP

• R81L PSY

     UP

• R81W PSY

     UP