DB2 - Problem description
Problem IC66988 | Status: Closed |
DB2IUPGRADE FAILS SOMETIMES WITH "DBT5025N THE DB2CHECKSD UTILITY FAILED WITH AN UNHANDLED ERROR" | |
product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problem description: | |
When you attempt to upgrade a DB2 V9.7 instance to DB2 V9.8 db2iupgrade might fail with the following error: #/opt/IBM/db2/V9.8/instance/db2iupgrade -d -k db2inst1 DB2 installation is being initialized. A major error occurred during the execution that caused this program to terminate prematurely. If the problem persists, contact your technical service representative. For more information see the DB2 installation log at "/tmp/db2iupgrade.log.1769620". DBI1446I The db2iupgrade command is running, please wait. DBI1264E Errors were encountered in running db2iupgrade. Please refer to the installation log file /tmp/db2iupgrade.log.1769620 for more information. Explanation: All processed and failed operations have been saved into this log file. User response: Do not modify this file in any way. This file is for IBM Technical Support reference. The log file shows the following entries : DB2 Setup log file started at: Sat Feb 13 13:11:32 2010 IST ============================================================ Operating system information: AIX 6.1 ERROR: DBT5025N The db2checkSD utility failed with an unhandled error. The output log file is named "/home/db2inst1/sqllib/db2dump/db2checkSD.log". ERROR: The "db2iupgrade" command failed. Ensure the command parameters are valid, that errors reported in the log file are fixed, then rerun the command. DB2 Setup log file finished at: Sat Feb 13 13:11:59 2010 IST ============================================================ | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * When you attempt to upgrade a DB2 V9.7 instance to DB2 V9.8 * * * * db2iupgrade might fail with the following error: * * * * * * * * #/opt/IBM/db2/V9.8/instance/db2iupgrade -d -k db2inst1 * * * * DB2 installation is being initialized. * * * * * * * * A major error occurred during the execution that caused this * * * * program to * * * * terminate prematurely. If the problem persists, contact your * * * * technical service * * * * representative. * * * * * * * * For more information see the DB2 installation log at * * * * "/tmp/db2iupgrade.log.1769620". * * * * DBI1446I The db2iupgrade command is running, please wait. * * * * * * * * DBI1264E Errors were encountered in running db2iupgrade. * * Please * * refer to the installation log file * * * * /tmp/db2iupgrade.log.1769620 for more * * * * information. * * * * * * * * Explanation: * * * * * * * * All processed and failed operations have been saved into * * this * * log file. * * * * * * * * User response: * * * * * * * * Do not modify this file in any way. This file is for IBM * * * * Technical * * * * * * * * Support reference. * * * * * * * * The log file shows the following entries : * * * * * * * * DB2 Setup log file started at: Sat Feb 13 13:11:32 2010 IST * * * * ============================================================ * * * * * * * * Operating system information: AIX 6.1 * * * * ERROR: DBT5025N The db2checkSD utility failed with an * * unhandled * * error. The output log file is named * * * * "/home/db2inst1/sqllib/db2dump/db2checkSD.log". * * * * ERROR: The "db2iupgrade" command failed. Ensure the command * * * * parameters are * * * * valid, that errors reported in the log file are fixed, then * * * * rerun the command. * * * * * * * * * * * * DB2 Setup log file finished at: Sat Feb 13 13:11:59 2010 * * IST * * ============================================================ * **************************************************************** * RECOMMENDATION: * * You must manually create the ~/sqllib/tmp directory for all * * * * instances before you attempt to run db2iupgrade. * * * * Make sure the owner of the ~/sqllib/tmp directory is the * * * * instance owner. * **************************************************************** | |
Local Fix: | |
You must manually create the ~/sqllib/tmp directory for all instances before you attempt to run db2iupgrade. Make sure the owner of the ~/sqllib/tmp directory is the instance owner. | |
available fix packs: | |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Fixed in DB2 9.8 Fixpack 3. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.03.2010 17.01.2011 17.01.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.8.FP3 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.8.0.3 |