IT20671: ANR0102E MONSTATS.C(5715): ERROR 1202 INSERTING ROW IN TABLE GUIL2.REPLSRV.GRID

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
IBM Spectrum Protect Server V7.1 Fix Pack 8 (7.1.8.000) Downloads

APAR status

• Closed as program error.

Error description

• A hub server can report in the activity log:
  
  05/09/2017 05:07:37      ANR0102E monstats.c(5715): Error 1202
  inserting row in table "GUIL2.Replsrv.Grid".
  
  A trace with flags "dbconn dbitxn monitor monitor_detail sql"
  shows:
  
  13:38:23.885 [295][dbieval.c][690][DbiEvalSQLOutcomeX]:SQLSTATE
  23505,
  SQLCODE -803, SQLMsg=[IBM][CLI Driver][DB2/AIX64] SQL0803N  One
  or more
  values in the INSERT statement, UPDATE statement, or foreign key
  update
  caused by a DELETE statement are not valid because the primary
  key,
  unique constraint or unique index identified by "1" constrains
  table
  "TSMDB1.GUIL2_REPLSRV_GRID" from having duplicate values for the
  index
  key.  SQLSTATE=23505
  .
  
  
  The message will be reported in the activity log however it does
   not impact any operation.
  
  IBM Spectrum Protect Versions Affected:
  Server 7.1.7.x and higher and 8.1.x and higher on all supported
  platforms
  
  Initial Impact:
  Medium
  
  Additional Keywords:
  TSM; IBM Spectrum Protect; OC; hub; monitor; monstats.c;
  GUIL2.Replsrv.Grid
  
  | MDVREGR 7.1.7.0-TIV_5698MSV |
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager server and 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 7.1.8 and 8.1.2.  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