IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IT12736

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-12-17

  • Closed date

    2016-01-25

  • Last modified date

    2016-01-25

  • 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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 71W

Reference #: IT12736

Modified date: 25 January 2016