IBM Support

Tivoli Storage Manager server upgrade from V6 to V7 fails with ANRI1043E

Troubleshooting


Problem

A Tivoli Storage Manager server is upgraded from V6 to V7. The upgrade fails with the following error : []ANRI1043E: An error occurred while dropping the DB2 instances.[]

Symptom

The following errors are logged :

=====> IBM Installation Manager> Error

ERROR: Error during "install" phase:

Details:
ANRI1043E: An error occurred while dropping the DB2 instances. To review errors and correct any issues, review the log files in /var/ibm/InstallationManager/logs/native.

Cause

Orphaned DB2 instance causing the db2idrop command to fail during upgrade

Environment

Tivoli Storage Manager Server on Unix/Linux

Diagnosing The Problem


1. Run the db2ilist command to verify the DB2 instances that are configured on the system. For example :

# /opt/tivoli/tsm/db2/instance/db2ilist

tsmi
tsmiold

In this case, it shows two instances, tsmi and tsmiold. The tsmiold instance is an instance that is no longer in use.

2. Run the db2greg command to verify the DB2 registry. For example :

/opt/tivoli/tsm/db2/bin/db2greg -dump show
V,DB2GPRF,DB2SYSTEM,xvotsmsrv01,/opt/tivoli/tsm/db2,
I,DB2,9.7.0.6,tsmi,/home/tsmi/sqllib,,1,0,/opt/tivoli/tsm/db2,,
V,DB2GPRF,DB2INSTDEF,tsmi,/opt/tivoli/tsm/db2,
I,DB2,9.7.0.4,tsmiold,/home/tsmiv/sqllib,,1,0,/opt/tivoli/tsm/db2,,
V,DB2GPRF,DB2FCMCOMM,TCPIP4,/opt/tivoli/tsm/db2,
S,DB2,9.7.0.6,/opt/tivoli/tsm/db2,,,6,0,,1359560348,0

Again, in this case, the registry shows references to the tsmi and tsmiold instances

3. Run the db2idrop command to remove the old instance (tsmiold). The command fails with the following error :

DBI1081E The file or directory /home/tsmiold/sqllib/bin is missing.

Resolving The Problem

Remove the orphaned DB2 registry reference to the old instance (tsmiold) with the following command :

/opt/tivoli/tsm/db2/bin/db2greg -delinstrec instancename=tsmiold

Retry the upgrade once the orphaned instance is removed.

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

Document Information

Modified date:
17 June 2018

UID

swg21669187

Page Feedback