IC97347: UNABLE TO ADD SPOKE SERVER DUE TO MULTIPLE STORAGE PATHS DEFINED

IBM Tivoli Storage Manager V6.3 Fix Pack 5 (6.3.5.000) Server Downloads
IBM Tivoli Storage Manager V7.1 Fix Pack 1 (7.1.1.000) Server Downloads

APAR status

• Closed as program error.

Error description

• The Tivoli Storage Manager Operations Center is unable to
  add a spoke server to be monitored. The spoke cannot be
    added due to the Tivoli Storage Manager server's DB has
    the same filesystem defined twice as a storage path. In
    this scenario the Operations Center is unable to retrieve
    database information from the server and the operation to
    add the spoke server fails.
  
    Database storage paths with the same name defined more than
    once is tolerated by DB2 so the Tivoli Storage Manager
    server needs to be updated to query the database space
    appropriately so it can return the information to the
    Operations Center successfully.
  
  Tivoli Storage Manager Versions Affected:
    6.3.4
  Customer/L2 Diagnostics (If Applicable)
    When adding the spoke server, the hub server reports the
    following error:
  
      ANR0102E admsql.c(5462): Error 1202 inserting row in table
               "DBSPACE.SQL".
    Output from the DB2 command DB2 GET SNAPSHOT FOR ALL DATABASES
    shows the following:
  
    Automatic storage path                     = /dbtest/db1
        Node number                          = 0
        State                                = In Use
        File system ID                       = 9223372187178631181
        Storage path free space (bytes)      = 9089748992
        File system used space (bytes)       = 22367531008
        File system total space (bytes)      = 31457280000
    Automatic storage path                     = /dbtest/db1
        Node number                          = 0
        State                                = In Use
        File system ID                       = 9223372187178631181
        Storage path free space (bytes)      = 9089748992
        File system used space (bytes)       = 22367531008
        File system total space (bytes)      = 31457280000
  Initial Impact:
    Low
  Additional Keywords:
    TSM OC zz63 hub spoke
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Tivoli Storage Manager server   *
  *                 SELECT command.                              *
  ****************************************************************
  * 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

• The problem was fixed.
  Affected Platforms: AIX, HP-UX, Solaris, Linux, and Windows.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• ADMSQL   ADMVIEW
  

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

• R71L PSY

     UP

• R71S PSY

     UP

• R71W PSY

     UP