IBM Support

Tivoli Storage Manager server upgrade from V6 to V7 fails on db2ckupgrade

Troubleshooting


Problem

A Tivoli Storage Manager AIX server upgrade to V7.1 fails to upgrade the database. The following error is logged : []DBT5529N The db2ckupgrade utility did not complete successfully[]

Diagnosing The Problem

Examine the /var/ibm/InstallationManager/logs/<timestamp>.xml file. For example :

932
INFO
06:15.40Custom operation com.tivoli.dsm.server.db2.DB2PreInstall in unit com.tivoli.dsm.server.aix.64 completed: output in 20140115_1645.log
933
INFO
06:15.40Error occurred in phase: pre-install configure SU: com.tivoli.dsm.server.files 7.1.0.20131126_1817 IU: com.tivoli.dsm.server.aix.64 null->7.1.0.20131126_1817 Message: Error
934
INFO
06:15.40Elapsed time 01:49.41 for: Performing "pre-install configure" phase
935
ERROR
06:15.41Error ANRI1061E: The db2ckupgrade failed for database TSMDB1 in instance tsminst1. Explanation: STDOUT ==================== DBT5529N The db2ckupgrade utility did not complete successfully. The database cannot be upgraded. The output log file is named "/var/ibm/InstallationManager/logs/native/tsm_logs/db2ckupgrade_tsminst1.log". STDERR ====================

Examine the corresponding log. In this case, the name of the log is 20140115_1645.log. This log shows :

Command: /usr/sbin/lsuser -a home tsminst1
stdout:
tsminst1 home=/home/tsminst1
stderr:
RC: 0
Command: . /home/tsminst1/sqllib/db2profile;db2fm -i tsminst1 -D
stdout:
stderr:
db2fm return non-zero rc, please see log file '/home/tsminst1/sqllib/db2dump/db2diag.log'
RC: 0
Command: . /home/tsminst1/sqllib/db2profile;db2iauto -off tsminst1
stdout:
stderr:
RC: 0

In this example, the log shows a non-zero return code for the second command, and suggests that you examine the db2diag.log file. Examine the db2diag.log file for errors. For example :

2014-01-15-16.45.57.374415-360 I74762136A440 LEVEL: Warning
PID : 8061078 TID : 2058 PROC : db2sysc 0
INSTANCE: tsminst1 NODE : 000 DB : TSMDB1
APPHDL : 0-14
EDUID : 2058 EDUNAME: db2agent (TSMDB1) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 67 bytes
Password validation for user tsminst1 failed with rc = -2146499506

The password validation error indicates that the DB2 authentication binaries are not owned by root.

Resolving The Problem

Follow the steps below to resolve this error.

  1. Stop the Tivoli Storage Manager server instance.
  2. Make sure that the DB2 instance is also stopped. Logon with the Tivoli Storage Manager server instance ID and run the db2stop command. If the DB2 instance does not stop, run the command, db2stop force.
  3. Logon as root and run the following two commands :

    cd /opt/tivoli/tsm/db2/instance
    ./db2iupdt tsminst1

    Specify the appropriate instance name on the db2iupdt command. In this case, the instance name is tsminst1.

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21662435