IBM Support

PI59996: TABLE DSN_PREDICATE_SELECTIVITY IS NOT INSERTED AT BIND TIME.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DSN_PREDICATE_SELECTIVITY is one of the plan tables.  EXPLAIN
    or BIND EXPLAIN YES inserts the explain output into all the
    plan tables. But when the SQL statement contains CTE, no rows
    are inserted into DSN_PREDICATE_SELECTIVITY at BIND time.
    

Local fix

  • no
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users of the EXPLAIN     *
    *                 table DSN_PREDICAT_TABLE and the EXPLAIN     *
    *                 table DSN_PREDICATE_SELECTIVITY may be       *
    *                 affected.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 may not generate the compound       *
    *                      predicate row for the EXPLAIN table     *
    *                      DSN_PREDICAT_TABLE or the predicate     *
    *                      selectivity row for the EXPLAIN table   *
    *                      DSN_PREDICATE_SELECTIVITY under the     *
    *                      following conditions:                   *
    *                       1. IBM DB2 Analytics Accelerator is    *
    *                          enabled, or                         *
    *                       2. Query rewrite when using a          *
    *                          materialized query table (MQT)      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DB2 may not generate the compound predicate row for the EXPLAIN
    table DSN_PREDICAT_TABLE or the predicate selectivity row for
    the EXPLAIN table DSN_PREDICATE_SELECTIVITY under the
    following conditions:
     1. IBM DB2 Analytics Accelerator is enabled, or
     2. Query rewrite when using a materialized query table (MQT)
    
    Additional keywords:
    SQLEXPLAIN IDAAV4R1/K IDAAV5R1/K SQLMQT
    

Problem conclusion

  • DB2 has been updated to resolve the problem described above.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI59996

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-03-31

  • Closed date

    2016-06-21

  • Last modified date

    2016-08-02

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

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

    UI38828

Modules/Macros

  •    DSNXOACR DSNXOAF  DSNXOCCF DSNXOCHK DSNXOD2
    DSNXOGP  DSNXOIWS DSNXOXRS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI38828

       UP16/07/06 P F607

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.



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI59996

Modified date: 02 August 2016


Translate this page: