IBM Support

PI22413: ENABLE ADDITIONAL SCALAR FUNCTIONS FOR ACCELERATION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Enable additional scalar functions for acceleration.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use            *
    *                 query acceleration.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR enables additional scalar     *
    *                      functions to be executed on an          *
    *                      accelerator.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR enables the following scalar functions to be
    executed on an accelerator:
    (1) DECODE
    (2) LTRIM and RTRIM with two arguments
    (3) TRIM
    (4) NVL
    
    For static SQL queries that will use any of the new functions
    above for execution on an accelerator, REBIND the
    package(s) with acceleration enabled after applying this PTF.
    
    Keywords:
    IDAAV3R1/K IDAAV4R1/K SQLDECODE SQLLTRIM SQLRTRIM SQLTRIM
    SQLNVL
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI22413

  • 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

  • Submitted date

    2014-07-21

  • Closed date

    2015-03-30

  • Last modified date

    2015-05-04

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

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

    UI26378 UI26379

Modules/Macros

  •    DSNXOEX1 DSNXONZC DSNXONZS DSNXOOS1 DSNXORFN
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI26378

       UP15/04/14 P F504

  • RB10 PSY UI26379

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

Modified date: 04 May 2015


Translate this page: