IBM Support

IC72923: DB2IUPGRADE FAILS WITH DBI1281E BECAUSE AWK FAILS TO PARSE A ROW IN THE GLOBAL REGISTRY

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

Local fix

  • Modify db2idbm as below:
    NUMINST=`${DB2DIR?}/bin/db2greg -dump | /usr/bin/grep -v ^V \
    

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 DB2 UDB version 9.7 fix pack 4.                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 Fix Pack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC72923

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-11-30

  • Closed date

    2011-05-05

  • Last modified date

    2011-05-05

  • APAR is sysrouted FROM one or more of the following:

    IC72874

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC72923

Modified date: 05 May 2011