IBM Support

PH48480: NEW FUNCTION FOR ACCELERATION SUPPORT FOR RAND AND LISTAGG

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 number

    PH48480

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-08-05

  • Closed date

    2022-10-31

  • Last modified date

    2022-12-01

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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 December 2022