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

Subscribe

You can track all active APARs for this component.

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



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager

Software version:

62W

Reference #:

IC67693

Modified date:

2010-11-04

Translate my page

Machine Translation

Content navigation