IBM Support

IC76561: ON DPF SQL1042C ERROR IS RETURNED FOR ANY TRANSACTION RUNNING AFTER DIAGPATH HAS BEEN RENAMED AND BEFORE IT GETS RE-CREATED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • All transactions running against a multipartitioned database get
    SQL1042C
    error after DIAGPATH is renamed and before it gets re-created.
    
    EX:
    
    1. Update DIAGPATH dbm cfg parameter:
    
    
    db2 -v update dbm cfg using diagpath '"/home/db2inst1/current
    $h$n"'
    
    
    2. Restart the instance for the changes to be in effect:
    
    db2stop force
    
    db2start
    
    
    
    3. List the paths that were created under
    /home/db2inst1/current to make sure they were updated:
    
    ls /home/anik/current/HOST_p6db2serv
    
    NODE0000  NODE0001  NODE0002
    
    
    4. Ran a simple select to make sure no sql1042c error is
    returned:
    
    db2 "select count(*) from employee"
    
    1
    -----------
             42
    
      1 record(s) selected.
    
    
    5. Then renamed the "current" directory:
    
    mv current current_old
    
    6.Right after this, i ran the same select above and got -1042
    error:
    
    SQL1042C  An unexpected system error occurred.
    
    With this APAR fix, SQL1042C will not be returned even if the
    diagpath is not available, thus it will not cause the running
    transactions to fail.
    

Local fix

  • No Local Fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users on DB2 v97 fp4                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ON DPF SQL1042C ERROR IS RETURNED FOR ANY TRANSACTION        *
    * RUNNING AFTER DIAGPATH HAS BEEN RENAMED AND BEFORE IT GETS   *
    * RE-CREATED.                                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply DB2 v97 FP5                                            *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 v97 fp5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76561

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-24

  • Closed date

    2011-12-19

  • Last modified date

    2011-12-19

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

    IC76083

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSY

       UP

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76561

Modified date: 19 December 2011