IBM Support

PI37302: DB2 11 FOR Z/OS NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • DB2 11 for z/OS new function
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use            *
    *                 query acceleration.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: Additional functions are added for a    *
    *                      query optimization serviceability       *
    *                      feature for restricted use with query   *
    *                      acceleration.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Additional functions are added for a query optimization
    serviceability feature for restricted use with query
    acceleration.
    
    This new function is intended for users of query acceleration
    who will be using the serviceability feature CTEHINT.
    
    For static SQL queries that have been bound for acceleration
    and will use the new function above, REBIND the package
    after applying this PTF.
    
    Additional keywords:
    IDAAV4R1/K CTEHINT
    

Problem conclusion

Temporary fix

Comments

  • ž**** PE15/10/08 FIX IN ERROR. SEE APAR PI49832  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI37302

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2015-03-18

  • Closed date

    2015-07-21

  • Last modified date

    2015-10-20

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

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

    UI29585

Modules/Macros

  •    DSNLXRSQ DSNLZOSR DSNXEDP  DSNXEDSC DSNXEDS1
    DSNXEPM  DSNXEPP  DSNXERT2 DSNXOD3  DSNXONZO DSNXOOP  DSNXOVD
    DSNXOV0
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI29585

       UP15/08/05 P F508

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 #: PI37302

Modified date: 20 October 2015


Translate this page: