PH48480: NEW FUNCTION FOR ACCELERATION SUPPORT FOR RAND AND LISTAGG

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• New function for Acceleration support for RAND and LISTAGG
  
  Additional keywords and symptoms:
  **********************************
  IDAAV7R5/K
  
  case: TS007474558
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 for z/OS users of Db2 QUERY                          *
  * ACCELERATION for IBM Db2 Analytics                           *
  * Accelerator V7 and the following existing                    *
  * Db2 for z/OS built-in functions:                             *
  *  o LIST_AGG aggregate function                               *
  *  o RANDOM(seed) or RAND(seed) scalar                         *
  *    function                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR is an enhancement to Db2                           *
  * for z/OS that now enables queries that                       *
  * specify the existing Db2z built-in                           *
  * aggregate function LIST_AGG and                              *
  * scalar function RANDOM(seed) or                              *
  * RAND(seed) to be accelerated to IBM                          *
  * Db2 Analytics Accelerator for                                *
  * z/OS Version 7                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Prior to this APAR/PTF, queries that specified the following
  built-in functions were not supported for Db2 QUERY
  ACCELERATION:
   o LIST_AGG aggregate function
   o RANDOM(seed) or RAND(seed) scalar function (The RANDOM
     scalar function without the optional seed value
     specified, was eligible for acceleration prior to this
     APAR/PTF).
  This Db2 for z/OS APAR PH48480 PTF introduces the following
  changes:
   o Queries which specify the LIST_AGG aggregate function or
     the RANDOM(seed)/RAND(seed) scalar function are now
     eligible for acceleration to IBM Db2 Analytics
     Accelerator for z/OS Version 7. Acceleration support for
     the RANDOM(seed) / RAND(seed) function requires usage of
     the Db2z QUERY_ACCEL_OPTIONS subsystem parm new option
     value 'ENABLE ACCELERATOR SPECIFIC RESULTS' that is
     described below.
   o New option value 13, ENABLE ACCELERATOR SPECIFIC RESULTS,
     has been added to the existing QUERY_ACCEL_OPTIONS
     subsystem parameter on the Db2 installation CLIST panel
     DSNTIP8A (Acceleration Options Panel).
                                                                .
     When the ENABLE ACCELERATOR SPECIFIC RESULTS option value
     is on specified, queries which reference applicable
     expressions that may result in different results when run
     on the IBM Db2 Analytics Accelerator V7 server versus when
     run on Db2 for z/OS, will be eligible for acceleration to
     Accelerator V7 server. IBM Db2 Analytics Accelerator V7
     server is based on the IBM Db2 Warehouse database, so
     the Accelerator V7 specific results refers to behavior
     and results from the IBM Db2 Warehouse.
                                                                .
     When this new option value 13 is not specified, then
     that applicable feature will not be accelerated (which
     is the existing behavior), even if it is supported for
     acceleration to Accelerator V7.
     Currently this new option value 13 only applies to
     the RANDOM(seed) / RAND(seed) scalar function, but may
     be extended to other Db2 for z/OS expressions
     or features that become eligible for acceleration in
     the future but produce different results or behavior on
     the Accelerator V7 than that of Db2 for z/OS.
  

Problem conclusion

• Db2 for z/OS was changed such that those queries that
  specify the Db2z LIST_AGG aggregate function or RANDOM(seed)
  / RAND(seed) scalar function, are now eligible for
  acceleration to the IBM DB2 Analytics Accelerator for
  z/OS V7, as previously described in the Problem Summary
  section of this APAR/PTF.
  Additional search keywords:
  SQLFUNCTION  IDAAV7R1/K  IDAAV7R5/K  IDAAV7R6/K
  

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:

  UI83065 UI83066

Modules/Macros

• DSN6SPRM DSNXONZO DSNXOEX1 DSNDQWPZ DSNWZIFC DSNXORFN DSNDSPRM
  DSNTINST DSNXONZB DSNXOBZO DSNXOBAQ DSNXONZA DSNTIP8A DSNXOBZB
  DSNXOD5  DSNXOOS1 DSNXODTX DSNXOBZA DSNWZIFD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI83065

     UP22/11/09 P F211

• RD10 PSY UI83066

     UP22/11/09 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.