|
Problem IC84275
|
Status: Closed |
DB2ISETUP FAILS TO CREATE AN INSTANCE WHEN THE SQLLIB DIRECTORY IS MISSING |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| 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. |
| 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. *
* *
* Problem Description: (describe the problem including *
* external symptoms as seen by the customer) *
* Update to IBM DB2 V9.7 Fix Pack 6. *
****************************************************************
* RECOMMENDATION: *
* Update to IBM DB2 V10fp1 *
**************************************************************** |
| 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". |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Update to IBM DB2 V10 fp1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
23.11.2012
23.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
