|
Problem IC80762
|
Status: Closed |
DB2ISETUP FAILS TO CREATE AN INSTANCE WHEN THE SQLLIB DIRECTORY IS MISSING |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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. *
****************************************************************
* RECOMMENDATION: *
* Update to IBM DB2 V9.7 Fix Pack 6. *
**************************************************************** |
| 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 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Update to IBM DB2 V9.7 Fix Pack 6. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC84275
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 10.01.2012
04.06.2012
04.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
