IBM Support

IT05189: THERE IS ANR0102E MONSTATS.C ERROR 1202 INSERTING ROW IN TABLE "TSMMON.STATUS" IN ACTIVITY LOG

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • On TSM Operation Center HUB server, the activity log reports
    ANR0102E message periodically. The message is as following;
    
    ANR0102E monstats.c Error 1202 inserting row in table
    "TSMMon.Status"
    
    Enable the trace with dbconn dbitxn monitor monitor_detail sql
    addmsg and from the trace, there is timing issue;
    
    Thread 59 start activty 108
    10:04:33.820
    [59][monstats.c][6128][MonRemoteGridUpdateSend]:Starting to send
    grid 7 update notification.
    10:04:33.821 [59][monstats.c][2523][monLogStatusExt]:Entry for
    id=108
    10:04:33.821
    [59][monstats.c][12131][DeactivateActivity]:Entering,
    server=XXXX, activityId=108,name=STATUS DATA REFRESH, subName=
    
    Thread 56 start activty 108
    10:04:33.822
    [56][monstats.c][6128][MonRemoteGridUpdateSend]:Starting to send
    grid 3 update notification.
    10:04:33.822 [56][monstats.c][2523][monLogStatusExt]:Entry for
    id=108
    10:04:33.823
    [56][monstats.c][12131][DeactivateActivity]:Entering,
    server=XXXX, activityId=108,name=STATUS DATA REFRESH, subName=
    
    Thread 59 insert active record for 108
    10:04:33.827
    [59][tbrsql.c][2754][PrepareStatement]:psSQLPreparing "UPDATE
    TSMDB1.tsmmon_status SET active=0 where active=1 AND server=?
    AND activity_id=? AND name=? and subname=?"
    
    Thread 56 insert active record for 108
    10:04:33.829
    [56][tbrsql.c][2711][PrepareStatement]:psSQLPreparing "UPDATE
    TSMDB1.tsmmon_status SET active=0 where active=1 AND server=?
    AND activity_id=? AND name=? and subname=?"
    
    Thread 59 deactivate activty 108
    10:04:33.831 [59][tbrsql.c][1509][tbRegExecEx]:exit, rc=TBRC_OK,
    wasExecd=True
    10:04:33.831 [59][monstats.c][12226][DeactivateActivity]:Exit
    rc=0, failingLine=0.
    10:04:33.832 [59][monstats.c][2772][monLogStatusExt]:Insert of
    108 status record successful
    
    Thread 56 deactivate activty 108
    10:04:33.832 [56][tbrsql.c][1509][tbRegExecEx]:exit,
    rc=TBRC_KEY_NOT_FOUND, wasExecd=False
    10:04:33.833 [56][monstats.c][12226][DeactivateActivity]:Exit
    rc=0, failingLine=0.
    10:04:33.834 [56][dbieval.c][677][DbiEvalSQLOutcomeX]:SQLSTATE
    23505, SQLCODE -803,SQLMsg=[IBM][CLI Driver][DB2/NT64] 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.TSMMON_STATUS" from
    having duplicate values for the index key. SQLSTATE=23505
    10:04:33.836 [56][output.c][7474][PutConsoleMsg]:ANR0102E
    monstats.c(2765): Error 1202 inserting row in table
    "TSMMon.Status".~
    
    The thread fails with duplicate values for activity 108.
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager 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.1.200 and 7.1.3. 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

    IT05189

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-10-30

  • Closed date

    2014-11-20

  • Last modified date

    2015-01-28

  • 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 #: IT05189

Modified date: 28 January 2015