DB2 - Problem description
Problem IC70458 | Status: Closed |
INSTALLFIXPACK WRITES TO FILES IN THE INSTANCE'S SQLLIB FOLDER REGARDLESS IF THE DIRECTORY EXISTS OR NOT. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
In certain cases, the home directory of a user does not have write access. This could be because it is a mount point that was created by the root user. Thus, installfixpack will fail because it calls an internal script, db2prechk, which attempts to create files within the sqllib directory. You can verify if you have this issue by running the following command as the instance owner: <Install Path>/instance/db2prechk -i ==== Example: $ /opt/IBM/db2/V9.7/instance/db2prechk -i Cannot create /home/db2inst1/sqllib. /home/db2inst1/sqllib: Permission denied touch: /home/db2inst1/sqllib/ctrl/.dbmchk/.host_not_stopped cannot create touch: /home/db2inst1/sqllib/ctrl/.dbmchk/.host_not_accessible cannot create /opt/IBM/db2/V9.7/instance/db2prechk: /home/db2inst1/sqllib/ctrl/.dbmchk/.hostlist: cannot create cat: cannot open /home/db2inst1/sqllib/ctrl/.dbmchk/.hostlist /opt/IBM/db2/V9.7/instance/db2prechk: /home/db2inst1/sqllib/ctrl/.dbmchk/.host_not_accessible: cannot open /opt/IBM/db2/V9.7/instance/db2prechk: test: argument expected | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * If the home directory of a user does not have write access * * the db2prechk will fail. This could be be caused by a mount * * point that was created by the root user. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 7. * **************************************************************** | |
Local Fix: | |
N/A | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 9.5 Fix Pack 7. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.08.2010 25.10.2010 25.10.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP7 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.7 | |
9.5.0.7 |