DB2 - Problem description
Problem IC77445 | Status: Closed |
INSTANCE REGISTRY VARIABLES ARE DELETED WHEN DB2IMIGR FAILS. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
When db2imigr fails for some reason(for example, the instance is still active), the instance registry variables are deleted during the undo process. For example, if you have these variables set before the upgrade: $ db2set -all [i] DB2_NUM_CKPW_DAEMONS=0 [i] DB2COMM=TCPIP [g] DB2SYSTEM=myhostname after upgrade the instance variables are no longer defined: $ db2set -all [g] DB2SYSTEM=myhostname | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error description field for more information. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.5 FixPack 9. * **************************************************************** | |
Local Fix: | |
- take a backup of the registry before upgrade $ db2set -all [i] DB2_NUM_CKPW_DAEMONS=0 [i] DB2COMM=TCPIP [g] DB2SYSTEM=myhostname - restore the registry after upgrade: db2set DB2_NUM_CKPW_DAEMONS=0 db2set DB2COMM=TCPIP | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in DB2 UDB Version 9.5 FixPack 9. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC79005 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.07.2011 26.03.2012 26.03.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP9 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.9 |