IBM Support

IT20584: ANR0102E MONSTATS.C(3102): ERROR 1202 INSERTING ROW IN TABLE "TSMMON.STATUS"

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A hub or spoke server can report in the activity log:
    
    ANR1960I Status monitor finished collecting data at  xx:xx:xx
    and will sleep for 5 minutes.
    ANR0102E monstats.c(3102): Error 1202 inserting row in table
    "TSMMon.Status"
    
    each time the status monitor runs.
    
    Server trace (dbconn dbitxn monitor monitor_detail sql ) will
    show  a message like:
    
    xx:xx:xx.xxx [x][dbieval.c][690][DbiEvalSQLOutcomeX]:SQLSTATE
    23505, SQLCODE -803, SQLMsg=[IBM][CLI Driver][DB2/NT64] SQL0803N
    At least one value caused by a DELETE statement in the INSERT
    statement, the UPDATE statement, or the foreign key update is
    invalid
    because the primary key, unique constraint, or the unique index
    specified by "1" prevents the table "TSMDB1.TSMMON_STATUS" from
    duplicating values In the index key.
    
    
    Tivoli Storage Manager and IBM Spectrum Protect versions
    affected:
    Server 7.1.7.x and higher, and 8.1.x and higher on all supported
    platform
    
    
    
    Initial Impact: Low
    
    Additional Keywords:  TSM IBM Spectrum Protect OC hub spoke
    
    | MDVREGR 7.1.7.0-TIV_5698MSV |
    

Local fix

  • Error message can be ignored, as it has no impact on operations.
    

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 number

    IT20584

  • 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

    2017-05-14

  • Closed date

    2017-06-19

  • Last modified date

    2017-06-19

  • 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: 7.1.3

Reference #: IT20584

Modified date: 19 June 2017