DB2 - Problembeschreibung
Problem IC78327 | Status: Geschlossen |
DB2 TOOLS AND STORED PROCEDURES FAIL WITH ERROR SQL1042C | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
If you mount the instance's home directory on a NFS v4 filesystem on SUSE SLES 10 SP2 many DB2 tools and stored procedures fail with the SQL1042C error. The reason is executables residing on NFS v4 on SUSE SLES 10 SP2 are required to have the read bit set in addition to the execute bit. The DB2 tools under <INSTANCE_HOME>/sqllib/adm do not have the read bit set for "other" therefore these tools cannot be executed. SQL1042C An unexpected system error occurred. Explanation: A system error occurred. Some possible reasons for this error are: * The database manager is not installed correctly or the environment is not set up correctly. * On UNIX-based systems, db2iupdt may need to be run in order to update the DB2 instance to enable acquisition of a new system configuration or access to function associated with the installation or removal of certain product options, FixPaks, or modification levels. | |
Problem-Zusammenfassung: | |
On NFS V4 it was identified fencid running any SPs or starting a Control center will fail with sql1042 because of permission problems. | |
Local-Fix: | |
Add read permission for "other" for all files in <INSTANCE_HOME>/sqllib/adm that have only execute permission for "other". | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.08.2011 12.03.2012 12.03.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.5.0.9 |