IT12736: ANR0102E MONSTATS.C ERROR 1202 SEEN WHEN INSERTING INTO GUIL2.REPLSRV.GRID

7.1.5.000-TIV-TSMSRV-AIX
7.1.5.000-TIV-TSMSRV-HP-UX
7.1.5.000-TIV-TSMSRV-Linuxppc64
7.1.5.000-TIV-TSMSRV-Linuxs390x
7.1.5.000-TIV-TSMSRV-Linuxx86_64
7.1.5.000-TIV-TSMSRV-SolarisSPARC
7.1.5.000-TIV-TSMSRV-WIN
IBM Spectrum Protect Server V7.1 Fix Pack 5 (7.1.5.000) Downloads

APAR status

• Closed as program error.

Error description

• It is possible for the activity log to show the following error.
  
  ANR0102E monstats.c(4662): Error 1202 inserting row in table
  "GUIL2.Replsrv.Grid"
  
  This occurs due to a duplicate entries in the table for the same
  source server.
  
  Tivoli Storage Manager Versions Affected: 7.1.3.000 and later on
  all supported platforms
  
  Customer/L2 Diagnostics: Verify that the following exists in the
  activity log. Specifically that the table that is failing is
  "GUIL2.Replsrv.Grid"
  
  ANR0102E monstats.c(4662): Error 1202 inserting row in table
  "GUIL2.Replsrv.Grid"
  
  Then issue the following commands from a DB2 command line to
  verify that there is a duplicate entry in the GUID_FORMAT
  column.
  
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  
  db2 "select GUID_FORMAT, TARGET_GUID_FORMAT, SERVER, TARGET from
  tsmdb1.GUIL2_REPLSRV_GRID"
  
  Initial Impact: Low
  
  Additional Keywords: repl replication source target oc operation
  operations center
  

Local fix

• The following steps can be used to delete the duplicate entries.
   The correct entry will be generated on the next data
  collection, so removal of both the correct and incorrect entries
   will not effect operation.
  
  1) Connect to DB2 by issuing the following on the DB2 command
  line:
  
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  
  2) Identify the server name from the following select command.
  
  db2 "select GUID_FORMAT, TARGET_GUID_FORMAT, SERVER, TARGET from
  tsmdb1.GUIL2_REPLSRV_GRID"
  
  3) With the server name from the above command, you can run the
  following to delete the duplicate entry:
  
  db2 "delete from tsmdb1.GUIL2_REPLSRV_GRID where  SERVER =
  '<SERVER_NAME>'
  
  4) Allow the next data collection will repopulate the correct
  entry in the table.
  
  NOTE: Step 3 may need to be done multiple times if there are
  multiple entries that need to be deleted or if you are not sure
  which entry is the right one to keep. Deleting the correct entry
  will not cause a problem since it will be regenerated on the
  next data collection.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server users of client-side       *
  * deduplication.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in levels 7.1.5. Note that this is     *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed. Affected platforms: AIX, HP-UX, Solaris,
  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