PM33767: VARIOUS FIXES AND ENHANCEMENTS FOR OPTIMIZATION HINTS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Various fixes and enhancements for optimization hints.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the DB2 optimization hints      *
    *                 (OPTHINT), the EXPLAIN PACKAGE statement,    *
    *                 or the APRETAINDUP option on the             *
    *                 REBIND PACKAGE command.                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR corrects several problems     *
    *                      related to the use of DB2               *
    *                      optimization hints (OPTHINT), the       *
    *                      EXPLAIN PACKAGE statement or the        *
    *                      APRETAINDUP option on the REBIND        *
    *                      PACKAGE command.  This APAR also adds   *
    *                      support for upcoming APAR PM25679.      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    1. EXPLAIN PACKAGE statement may skip populating PLAN_TABLE for
       certain packages.
    
    2. Using the EXPLAIN PACKAGE statement, or the APRETAINDUP
       option on REBIND PACKAGE can cause DB2 to abend at
       04E-00E2000C,LOC=DSNGEPLC.DSNSVSVB+0AAA
    
    3. Various scenarios wherein DB2 does not correctly apply
       optimization hints. This can show up in the form of
       unnecessary sorts for ORDER BY, GROUP BY or join,
       differences in MATCHCOLS or MERGE_JOIN_COLS, etc.
    
    4. Support is added for upcoming APAR PM25679.
    
    Additional Keywords:
    SQLEXPLAIN OPTHINT HINT OPTHINTS HINTS ABEND04E
    RC00E2000C SQLORDERBY SQLGROUPBY
    

Problem conclusion

Temporary fix

Comments

  • This APAR provides support for APAR PM25679.
    

APAR Information

  • APAR number

    PM33767

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-02-28

  • Closed date

    2011-06-30

  • Last modified date

    2011-08-01

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

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

    UK69377

Modules/Macros

  •    DSNDBPL  DSNDCT   DSNDDDRB DSNDRCIB DSNDSIB
    DSNECP44 DSNECP45 DSNECP47 DSNFMDIR DSNFTDIR DSNFTDTA DSNGEPLC
    DSNLXRCM DSNLXRCS DSNTBAP  DSNTBAR  DSNTBAS2 DSNTBBP2 DSNTBCM
    DSNTBCM2 DSNTBCM5 DSNTBMSG DSNTBRB2 DSNTBSTB DSNTCT   DSNTSTBL
    DSNXEBPG DSNXEDP  DSNXEDS1 DSNXEPP  DSNXERBP DSNXEXP  DSNXNPG
    DSNXNTRY DSNXOAF  DSNXOD0P DSNXOD1  DSNXOD15 DSNXOD3  DSNXOGBM
    DSNXOGP  DSNXOGP2 DSNXOIWS DSNXOOP  DSNXOPB  DSNXOPCO DSNXOPL
    DSNXOPLM DSNXOPT  DSNXOPTH DSNXOPTI DSNXOSST DSNXOSUD DSNXPPO
    DSNXQAR  DSNXSLT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK69377

       UP11/07/16 P F107

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM33767

Modified date:

2011-08-01

Translate my page

Machine Translation

Content navigation