IBM Support

IC95021: ANR0102E ERROR 1202 INSERTING ROW IN TABLE DRMTRPF UPON SELECT AGAINST DRMTRPF VIEW

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When submitting a dsmadmc select command against the DRMTRPF,
    e.g. "select * from DRMTRPF" to query Tivoli Storage Manager
    recovery plan files, the following error might be reported:
    ANR0102E admsql.c(5462): Error 1202 inserting row in table
    "DRMTRPF".
    
    The symptom is seen if two or more servers
    - define their device class for recovery plan file to the same
    target server
    and
    - the servers run a PREPARE command at the same time up to the
    second.
    
    This will generate two plan files with the same name:
    
    The naming convention for the archive object that contains the
    recovery plan file on the target server is:
       Filespace name:  ADSM.SERVER
       High-level qualifier:
    devclassprefixルservername.yyyymmdd.hhmmss
       Low-level qualifier: RPF.OBJ.1
    The recovery plan file virtual volume name as recorded in the
    volume history table on the source server is in the format
    servername.yyyymmdd.hhmmss.
    
      Tivoli Storage Manager Versions Affected: all V6
      Initial Impact: Low
      Additional Keywords: TSM TSMDB1 DRM SQL DB2 Archive_Nameview
    

Local fix

  • use the QUERY RPF instead
    To prevent from the symptom, do not run PREPARE commands for
    multiple server nodes to the same target server at the same time
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager server users.     *
    ****************************************************************
    * PROBLEM DESCRIPTION: See error description.                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This problem is projected to be fixed in a future version of
    the Tivoli Storage Manager server.  Note that this is subject
    to change at the discretion of IBM.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC95021

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63L

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-20

  • Closed date

    2013-08-23

  • Last modified date

    2013-08-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 63L

Reference #: IC95021

Modified date: 23 August 2013