IBM Support

IT02135: DSMICFGX PROVIDES SUGGESTION THAT DOES NOT HELP RESOLVE FAILURE WHEN USER ID ALREADY OWNS A SERVER DATABASE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Tivoli Storage Manager server instance configuration wizard
    (dsmicfgx) can fail with the following error when defining the
    credentials for the instance user ID:
    
      The user ID already owns a server database.
    
      Issue DSMSERV REMOVEDB to remove the existing database, or
      specify a different user ID.
    
    This error occurs when the user ID already has a defined server
    database, which means that server configuration has previously
    taken place.
    
    If an administrator intends to overwrite the previously defined
    database, they can issue the DSMSERV REMOVEDB command to do so
    as explained in the error message.
    
    This command alone, however, does not resolve the error in
    dsmicfgx.
    
    Customer/L2 Diagnostics:
    None.
    
    Initial Impact:
    Medium
    
    Tivoli Storage Manager Versions Affected:
    All Tivoli Storage Manager servers users of dsmicfgx.
    
    Additional Keywords:
    TSM DSMICFGX CONFIG CONFIGURATION REMOVE DB REMOVEDB
    CATALOG UNCATALOG USER ID INSTANCE ID USERID INSTANCEID
    

Local fix

  • After issuing the DSMSERV REMOVEDB command with success,
    ensure that you uncatalog any remaining database aliases
    from within DB2.  To do this, issue the "db2 list database
    directory" command to determine if there are any remaining
    database aliases.  For example, as the instance user (or
    via the DB2 Command Line Processor on Windows):
    
    $ db2 list database directory
    
     System Database Directory
    
     Number of entries in the directory = 1
    
    Database 1 entry:
    
     Database alias                       = TSMAL001
     Database name                        = TSMDB1
     Node name                            = TSMNODE1
     Database release level               = 10.00
     Comment                              = TSM SERVER DATABASE
                                            VIA TCPIP
     Directory entry type                 = Remote
     Catalog database partition number    = -1
     Alternate server hostname            =
     Alternate server port number         =
    
    There should be only one entry reported and the database alias
    name should be "TSMAL001," otherwise do not continue with
    these steps.
    
    After confirming that there is a single "TSMAL001" database
    alias remaining, issue the "db2 uncatalog database TSMAL001"
    command to remove the remaining DB alias.  For example:
    
    $ db2 uncatalog database tsmal001
    DB20000I  The UNCATALOG DATABASE command completed successfully.
    DB21056W  Directory changes may not be effective until the
              directory cache is refreshed.
    
    Once the alias has been uncataloged, restart the dsmicfgx
    utility and the error will no longer occur.
    

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 6.3.5 and 7.1.1. 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

    IT02135

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-30

  • Closed date

    2014-06-13

  • Last modified date

    2015-09-16

  • 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

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

  • R71L PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 71L

Reference #: IT02135

Modified date: 16 September 2015