IBM Support

IC78353: DB2 FAILS TO RESPECT THE CURRENT MDC ROLLOUT MODE SPECIAL REGISTER

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 fails to respect the CURRENT MDC ROLLOUT MODE special
    register when a delete statement is compiled with the special
    register set to NONE and then the same delete statement is
    re-executed except this time with the special register set to
    IMMEDIATE or DEFERRED.  The first time the statement is
    executed, the plan is compiled with a regular delete operator
    and it is stored in the package cache.  The second execution of
    the statement executes the plan stored in the package cache,
    which contains a regular delete operator.  The regular delete
    operator does not check if the special register has changed.
    The problem does not occur if the special register is set to
    DEFERRED or IMMEDIATE when the statement is first compiled
    because then the cell delete operator will be used and this
    operator will check if the special register has changed.
    

Local fix

  • Recompile/rebind the package experiencing the problem.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7.0.6.                              *
    ****************************************************************
    

Problem conclusion

  • The problem is first fixed in DB2 version 9.7.0.6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC78353

  • 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-08-26

  • Closed date

    2012-06-12

  • Last modified date

    2012-06-12

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

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78353

Modified date: 12 June 2012