Fixes are available
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 number
IC97347
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-10-31
Closed date
2013-11-12
Last modified date
2013-11-12
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
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63A"}]
Document Information
Modified date:
22 September 2021