IBM Support

IC78328: DB2 TOOLS AND STORED PROCEDURES FAIL WITH ERROR SQL1042C

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error 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.
    

Local fix

  • Add read permission for "other" for all files in
    <INSTANCE_HOME>/sqllib/adm that have only execute permission for
    "other".
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 v9.1 and DB2 v9.7                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2_v91fp11 or db2_v97fp6                         *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC78328

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-25

  • Closed date

    2012-06-16

  • Last modified date

    2012-06-16

  • APAR is sysrouted FROM one or more of the following:

    IC78325

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R910 PSY

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78328

Modified date: 16 June 2012