IBM Support

IT12228: DSMSERV INSERTDB FAILURE IF ADDITIONAL DSMSERV PROCESS IS STARTED FOR THE SAME INSTANCE WHILE DSMSERV INSERTDB IS RUNNING

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • In most cases Tivoli Storage Manager prevents attempts to start
    multiple dsmserv processes for the same instance simultaneously.
    When dsmserv insertdb is running, additional dsmserv processes
    are not prevented and attempting to start a second dsmserv
    process can cause dsmserv insertdb to fail.  The dsmserv
    insertdb failure may resemble the following:
      ANR0171I tbrsql.c(1446): Error detected on 2:4, database in
      evaluation mode
    When the error occurs during the "update phase" of INSERTDB,
    errors like the following may also be seen:
      ANR1524I INSERTDB: Beginning database update phase.
    
      ANR0171I tbrsql.c(1446): Error detected on 2:4, database in
      evaluation mode.  ANR9999D_4127647571 UpdateInventory
      (tbinsert.c:8485) Thread<1>:  Error 4522 from inventory update
      SQL for table Table.Name.
    After the upgrade process fails at the database insertion step,
    restarting the process will likely result in errors.  The
    following documentation has the recommended steps to resolve
    the problem:
    Database insertion phase: problems with restarting the upgrade
    process
      http://www-01.ibm.com/support/knowledgecenter/SSGSG7_7.1.1/
      com.ibm.itsm.srv.upgrd.doc/ts_srv_upgrd_restartupgrd.html
    Tivoli Storage Manager Versions Affected:
      Tivoli Storage Manager servers 7.1 and higher
    Initial Impact:
      Medium
    Additional keywords:
      TSM dsmserv insertdb dsmserv.v6lock IC83606
    

Local fix

  • Do not start a second dsmserv process while dsmserv insertdb
    is running.
    

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 level 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, and Linux
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT12228

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71H

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-11-11

  • Closed date

    2015-11-16

  • Last modified date

    2015-12-14

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 71H

Reference #: IT12228

Modified date: 14 December 2015