DB2 - Problem description
Problem IC72924 | Status: Closed |
DB2IUPGRADE FAILS WITH DBI1281E BECAUSE AWK FAILS TO PARSE A ROW IN THE GLOBAL REGISTRY | |
product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
Problem description: | |
If the global registry contains unprintable characters, db2iupgrade may fail with DBI1281E. e.g. After running db2iupgrade DBI1281E The database manager configuration file could not be initialized. Viewing the debug output will show the following: + /opt/IBM/db2/V9.7/instance/db2iexec db2inst1 /opt/IBM/db2/V9.7/instance/db2idbm db2inst1 /home/db2inst1 db2iadm1 1 SERVER /tmp/db2icrt.tmp1.970980 awk: 0602-562 Field $(V,XXX,YYYYY,<unprintable characters>,ZZZZZZ,) is not correct. The input line is XX. The source line is 1. /opt/IBM/db2/V9.7/instance/db2idbm: test: 0402-017 Specify a parameter with this command. After applying the fix, db2iupgrade will complete without any errors from db2idbm. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * UNIX * **************************************************************** * PROBLEM DESCRIPTION: * * If the global registry contains unprintable characters, * * * * db2iupgrade may fail with DBI1281E. * * * * * * * * e.g. After running db2iupgrade * * * * * * * * DBI1281E The database manager configuration file could not * * be * * initialized. * * * * * * * * Viewing the debug output will show the following: * * * * * * * * + /opt/IBM/db2/V9.7/instance/db2iexec db2inst1 * * * * /opt/IBM/db2/V9.7/instance/db2idbm db2inst1 /home/db2inst1 * * * * db2iadm1 1 SERVER /tmp/db2icrt.tmp1.970980 * * * * awk: 0602-562 Field $(V,XXX,YYYYY,<unprintable * * * * characters>,ZZZZZZ,) is not correct. * * * * The input line is XX. * * * * The source line is 1. * * * * /opt/IBM/db2/V9.7/instance/db2idbm: test: 0402-017 Specify a * * * * parameter with this command. * * * * * * * * After applying the fix, db2iupgrade will complete without * * any * * errors from db2idbm. * **************************************************************** * RECOMMENDATION: * * Upgrade to next release. * **************************************************************** | |
Local Fix: | |
Modify db2idbm as below: NUMINST=`${DB2DIR?}/bin/db2greg -dump | /usr/bin/grep -v ^V \ | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.11.2010 25.05.2011 25.05.2011 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |