PM72264: CODE TO SUPPORT NEW FUNCTION ON DB2 V9

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Code to support new function on DB2 V9.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 9 for z/OS who use          *
  *                 IBM DB2 Analytics Accelerator                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Two new settings, ALL and ELIGIBLE, are *
  *                      added for special register CURRENT      *
  *                      QUERY ACCELERATION.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Two new settings, ALL and ELIGIBLE, are added for the
  DSN6SPRM.QUERY_ACCELERATION parameter and special register
  CURRENT QUERY ACCELERATION.  The new settings are:
  
    * ALL     : Indicates that any given query
                will be accelerated if it is eligible
                for acceleration without heuristics
                and costing, and queries that are not
                eligible will not be executed in DB2,
                but will raise SQL error -4742 instead.
                There is no failback with this option.
    * ELIGIBLE: Indicates that any given query
                will be accelerated if it is eligible
                for acceleration without heuristics
                and costing.  Queries that are not
                eligible will be executed in DB2.
                There is no failback with this option.
  
  The ALL and ELIGIBLE settings are added to the existing settings
  of ENABLE, ENABLE_WITH_FAILBACK, and NONE (which is the default
  setting).  See the DB2 Installation Guide for more information
  about these existing settings.
  
  New SQL code -4742 is added.  See HOLD data for more information
  on this SQL code.
  
  Additional Keywords:
  IDAAV2R1/K  SQLCODE4742
  

Problem conclusion

Temporary fix

Comments

• Two new settings, ALL and ELIGIBLE, are added for the
  DSN6SPRM.QUERY_ACCELERATION parameter and special register
  CURRENT QUERY ACCELERATION.  The DB2 V10 support for
  ALL/ELIGIBLE is provided via APAR PM72265.
  

APAR Information

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

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

  UK83461

Modules/Macros

• DSNDQWPZ DSNDSPRM DSNHAPLY DSNHPTAB DSNHSM2V
  DSNHSYMH DSNLXSR  DSNLZOSR DSNTIAM  DSNTIA1  DSNTIJAS DSNWZIF9
  DSNXEDP  DSNXEDSC DSNXESQL DSNXESSR DSNXGRTM DSNXODML DSNXOEX1
  DSNXONZA DSNXONZO DSNXOOS1 DSNXRBND DSNXRSPG DSN6SPRM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK83461

     UP12/11/28 P F211

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.