A fix is available
APAR status
Closed as program error.
Error description
The Tivoli Storage Manager 6.2 upgrade process may fail because DB2 reports a wrong "local database directory" when doing "db2 list db directory". It shows "%s" instead of the correct db location => C:\Program Files\Tivoli\TSM\db2\BIN>db2 list db directory System Database Directory Number of entries in the directory = 1 Database 1 entry: Database alias = TSMDB1 Database name = TSMDB1 Local database directory = %s Database release level = c.00 Comment = Directory entry type = Indirect Catalog database partition number = 0 Alternate server hostname = Alternate server port number = This is due to DB2 APAR IC65713 . Tivoli Storage Manager Versions Affected: All Windows TSM servers previously upgraded from 6.1.0 or 6.1.1 or 6.1.2 to 6.1.3 Customer/L2 Diagnostics : Error seen during the upgrade process : "Cataloging the database: TSMDB1 SQL1002N "%s" is not a valid drive. The database is already cataloged. Upgrading the database: TSMDB1 SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 An error occurred while upgrading the database." TSM server start shows: Tivoli Storage Manager for Windows Version 6, Release 2, Level 0.0 Licensed Materials - Property of IBM (C) Copyright IBM Corporation 1990, 2010. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0152I Database manager successfully started. ANR0172I rdbdb.c(1604): Error encountered performing action ActivateDatabase. ANR0162W Supplemental database diagnostic information: -1031:**No State Information Available (77)**:-1031 (**No Other Information Available (122)**). Initial Impact: High Additional Keywords: zz62 directory catalog migration
Local fix
Use the following method to terminate the upgrade. 1) From a command prompt, open a DB2 command line environment window: db2cmd 2) set DB2INSTANCE=<your-instance-name> 3) db2start 4) From the DB2 command line window, catalog the database: db2 catalog db TSMDB1 5) Try a connection db2 connect to tsmdb1 ( it should state that db is not upgraded) 6) Upgrade the db to be compatible with the new DB2 level. db2 upgrade db tsmdb1
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users * * performing a 6.1.X reinstall or 6.2.X * * upgrade. * **************************************************************** * PROBLEM DESCRIPTION: See error description. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in level 6.1.4 and 6.2.1. Note that this * * is subject to change at the discretion * * of IBM. * **************************************************************** *
Problem conclusion
The problem has been fixed.
Temporary fix
Comments
APAR Information
APAR number
IC67693
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
62W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-09
Closed date
2010-05-10
Last modified date
2010-11-04
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
R61W PSY
UP
R62W 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":"62W"}]
Document Information
Modified date:
16 September 2021