IC67693: SERVER UPGRADE FROM V6.1.3 TO V6.2 MAY FAIL DUE TO DB2 APAR IC65713

IBM Tivoli Storage Manager V6.1 Fix Pack 4 (6.1.4) Server Downloads

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 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