IBM Support

PI30859: SUPPORT FOR ACCELERATOR HINTS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Support for Accelerator Hints
    

Local fix

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 for query    *
    *                      acceleration.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Additional functions are added for a query optimization
    serviceability feature for restricted use for query
    acceleration.
    Contact IBM Support to determine if this serviceability
    feature should be used.
    
    
    For static SQL queries that have been bound for acceleration
    and will use the new function above, after applying
    this PTF, REBIND the package.
    
    Additional keywords:
    IDAAV4R1/K CTEHINT
    

Problem conclusion

Temporary fix

Comments

  • ž**** PE15/04/30 FIX IN ERROR. SEE APAR PI39542  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI30859

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Serviceability

  • Submitted date

    2014-12-03

  • Closed date

    2015-03-30

  • Last modified date

    2015-05-06

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

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

    UI26382

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

  • RA10 PSY UI26382

       UP15/04/14 P F504

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: A10

Reference #: PI30859

Modified date: 06 May 2015


Translate this page: