IT36801: NODE REPLICATION MAY FAIL FOR FILESPACES CONTAINING A LARGE NUMBER OF REPLICATED OBJECTS

8.1.12.200-IBM-SPSRV-WindowsX64
8.1.12.200-IBM-SPSRV-Linuxx86_64
8.1.12.200-IBM-SPSRV-Linuxs390x
8.1.12.200-IBM-SPSRV-Linuxppc64le
8.1.12.200-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 13 (V8.1.13) Downloads
IBM Spectrum Protect Server V8.1.12.X interim fix downloads

APAR status

• Closed as program error.

Error description

• Node replication may fail if the count of replicated objects
  associated with a single filespace exceeds ~2.1 billion. The
  activity log excerpt from the source server will show errors
  similar to the following:
  
  ANR0162W Supplemental database diagnostic information:
  -1:22003:-802 ([IBM][Cli Driver][DB2/LINUXPPC64LE] SQL0802N
  Arithmetic overflow or other arithmetic exception occurred.
  SQLSTATE=22003).
  ANR0106E nrmain.c(29794): Unexpected error 2343 fetching row in
  table "Replicated.Objects".
  ANR1936E Replication of BACKUP data for file space /test (fsid
  1) on node TESTNODE failed with reason: Reason code 2343.
  
  The replication operation will continue to run for all other
  nodes and filespaces; replication will only fail for the
  filespace with the large number of replicated objects.
  
  
  Support/Customer Diagnostics:
  SQL queries can be issued against the replicated_objects
  database table to confirm whether you are affected by this
  problem. The ANR1936E error seen above indicates the affected
  node and filespace name/id. Issue the following query to
  determine the nodeid associated with the affected node (eg.
  TESTNODE):
  
  $ db2 connect to tsmdb1
  $ db2 set schema tsmdb1
  $ db2 "select nodeid from nodes where nodename='TESTNODE'"
  
  Then, issue the following queries to obtain counts of the
  replicated objects associated with this node and filespace
  (where <nodeid> represents the node id returned from the
  previous query and <fsid> represents the filespace id referenced
  in the ANR1936E error):
  
  $ db2 "select count(*) from replicated_objects where
  nodeid=<nodeid> and fsid=<fsid> for read only with ur""
  $ db2 "select count_big(*) from replicated_objects where
  nodeid=<nodeid> and fsid=<fsid> for read only with ur""
  
  If affected by this problem, the expectation is that the select
  statement issued with the count(*) function will fail due to the
  SQL0802N error, whereas the select statement issued with the
  count_big(*) function will complete successfully and return a
  count of objects exceeding 2.1 billion.
  
  
  Spectrum Protect Versions Affected:
  All supported IBM Spectrum Protect server versions
  
  
  Initial Impact:
  Medium
  

Local fix

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 levels 8.1.12.200 and 8.1.13. 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, 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