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.40 | Custom 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.40 | Error 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.40 | Elapsed time 01:49.41 for: Performing "pre-install configure" phase | |
935 | ERROR | 06:15.41 | Error 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.
- Stop the Tivoli Storage Manager server instance.
- 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.
- 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"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21662435