IBM Support

IT08244: "ANR0102E ERROR 1202 INSERTING ROW IN TABLE REPLICATED.OBJECTS" REPORTED ON REPLICATION SOURCE SERVER

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • During Tivoli Storage Manager node replication, the source
    server might log the following message:
    ANR0102E tbcli.c(2175): Error 1202 inserting row in table
    "Replicated.Objects".
    
    The symptom typically is seen if a node replication process was
    canceled and is not related to IT02221 where a similar symptom
    is reported an a replication target server.
    
      Customer/L2 Diagnostics (If Applicable)
    To verify that you are affected by this APAR collect the
    following SQL command output:
    db2 connect to tsmdb1
    db2 set schema tsmdb1
    db2 "select * from replicated_objects repl left join
    replicating_objects repling on (repl.objid=repling.objid and
    repl.serverid=repling.serverid) where repling.objid is not null"
    
    You hit this APAR if the result sets SOURCE_RC column reports
    1052 (GRC_CANCELED).
    
      Tivoli Storage Manager Versions Affected: V7.1
    
      Initial Impact: Medium
      Additional Keywords: NRRO NRRG TSM
    

Local fix

  • until a fix is available you can use the following commands to
    clean up the replicating_objects table:
     db2 connect to tsmdb1
     db2 set schema tsmdb1
     db2 "delete from replicating_objects where source_rc=1052 and
    objid in (select objid from replicated_objects)"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server node replication users.    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in level 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

    IT08244

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-04-13

  • Closed date

    2015-04-30

  • Last modified date

    2015-04-30

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

Modified date: 30 April 2015