IBM Support

IC80762: DB2ISETUP FAILS TO CREATE AN INSTANCE WHEN THE SQLLIB DIRECTORY IS MISSING

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When the sqllib directory of the instance user is missing,
    db2isetup will display a success message but fail to create the
    instance.
    
    If you have the following symptoms, db2isetup will fail to
    create the instance.
    #/opt/IBM/db2/97fp6/instance> ./db2ilist
    db2inst2
    #/opt/IBM/db2/97fp6/instance> ls /home/db2inst2/sqllib
    /home/db2inst2/sqllib not found
    #/opt/IBM/db2/97fp6/instance> ./db2isetup
    
    In db2isetup:
    1) When prompted for a new user or existing user, select
    existing user and type the instance name (in this case
    db2inst2).
    2) After setup is complete, check logs and you will see some
    errors, despite the setup's misleading "Setup has completed
    successfully" message at the top of the window.
    3) "ls /home/db2inst2/sqllib" and you will notice sqllib was not
    created.
    
    After applying the fix, you will be able to create the sqllib
    under the same conditions mentioned above.
    

Local fix

  • There are two workarounds:
    1) Remove the global registry by using
    "/opt/IBM/db297fp6/instance/db2iset -d db2inst2" and
    re-run "/opt/IBM/db297fp6/instance/db2isetup".
    2) Recreate the instance using
    "/opt/IBM/db297fp6/instance/db2icrt -u db2inst2 db2inst2".
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When the sqllib directory of the instance user is missing,   *
    * db2isetup will display a success message but fail to create  *
    * the                                                          *
    * instance.                                                    *
    *                                                              *
    * If you have the following symptoms, db2isetup will fail to   *
    * create the instance.                                         *
    * #/opt/IBM/db2/97fp6/instance> ./db2ilist                     *
    * db2inst2                                                     *
    * #/opt/IBM/db2/97fp6/instance> ls /home/db2inst2/sqllib       *
    * /home/db2inst2/sqllib not found                              *
    * #/opt/IBM/db2/97fp6/instance> ./db2isetup                    *
    *                                                              *
    * In db2isetup:                                                *
    * 1) When prompted for a new user or existing user, select     *
    * existing user and type the instance name (in this case       *
    * db2inst2).                                                   *
    * 2) After setup is complete, check logs and you will see some *
    * errors, despite the setup's misleading "Setup has completed  *
    * successfully" message at the top of the window.              *
    * 3) "ls /home/db2inst2/sqllib" and you will notice sqllib was *
    * not                                                          *
    * created.                                                     *
    *                                                              *
    * After applying the fix, you will be able to create the       *
    * sqllib                                                       *
    * under the same conditions mentioned above.                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IBM DB2 V9.7 Fix Pack 6.                           *
    ****************************************************************
    

Problem conclusion

  • Update to IBM DB2 V9.7 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80762

  • 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

    2012-01-10

  • Closed date

    2012-06-04

  • Last modified date

    2012-06-04

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

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

    IC84275

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 #: IC80762

Modified date: 04 June 2012