Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC78325 Status: Closed

DB2 TOOLS AND STORED PROCEDURES FAIL WITH ERROR SQL1042C

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
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 Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* 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.                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v91 FixPack 11                                * 
****************************************************************
Local Fix:
Add read permission for "other" for all files in 
<INSTANCE_HOME>/sqllib/adm that have only execute permission for 
"other".
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Fixed in DB2 v91 FixPack 11
Workaround
Add read permission for "other" for all files in 
<INSTANCE_HOME>/sqllib/adm that have only execute permission for 
other".
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC78327 IC78328 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
25.08.2011
18.06.2012
18.06.2012
Problem solved at the following versions (IBM BugInfos)
9.1.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.