IBM Support

PI42161: 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 11 for z/OS who use         *
    *                 query acceleration.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: A restriction is being removed that     *
    *                      prevented some SQL from being eligible  *
    *                      for SQL acceleration offload.           *
    *                      A reference in the SQL to most of the   *
    *                      DB2 special registers was a condition   *
    *                      that would disqualify the SQL for       *
    *                      acceleration.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Logic is added in both DB2 and in the accelerator code to handle
    references in the SQL statement to nearly all of the DB2 special
    registers.  This functionality requires that the support level
    is present in both DB2 and the accelerator code.  For DB2,
    it is this APAR, PI42161.  For IBM DB2 Analytics Accelerator,
    Version 4, PTF 6 or later, is required.  Special register
    references that are still not supported after these changes
    include CURRENT SERVER, CURRENT PACKAGESET, and
    CURRENT APPLICATION ENCODING.  Also, any special registers that
    were introduced in DB2 11 are not yet supported.  Support for
    those DB2 11 registers might be added in the future.
    
    Any static SQL statements that were previously bound and were
    disqualified from acceleration offloading because of the
    presence of unsupported Special Registers will need to be
    rebound after the application of this APAR and the corresponding
    accelerator support level.
    
    Additional Keywords:
    IDAAV4R1/K
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI42161

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-06-01

  • Closed date

    2015-09-10

  • Last modified date

    2015-11-03

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

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

    UI31025

Modules/Macros

  •    DSNLXRAX DSNLXROP DSNLXSR  DSNXEDP  DSNXEPM
    DSNXERT  DSNXERT2 DSNXOD5  DSNXOEX1 DSNXONZA DSNXONZB DSNXONZC
    DSNXOOS1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI31025

       UP15/10/08 P F510

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

Modified date: 03 November 2015


Translate this page: