PI22413: ENABLE ADDITIONAL SCALAR FUNCTIONS FOR ACCELERATION

Obtain the fix for this APAR.

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 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.