IBM Support

PI91620: NEW FUNCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • New function
    PI91620 is DB2 V12 for z/OS APAR that contains the forward-fit
    of the following DB2 V11 APARs supporting IBM DB2 Analytics
    Accelerator :
    PI54149
    PI70476
    PI75212
    PI63736
    PI84255
    PI83466
    PI89071
    PI72726
    ***************************************************************
    Additional Symptom:
    Loop in module DSNFWTO issuing message DSNX881I repetitively
    when starting the Accelerator(s) the initial time after
    migrating from Db2 V11 to V12. This can occur at IDAA V5.1
    PTF6 level and above, including IDAA V7.
    ***************************************************************
    DB2MIGV12/K
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS users of acceleration                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This APAR provides forward fits for the following Db2 11     *
    * Apars: PI54149, PI63736, PI64476, PI66166, PI66573, PI69947, *
    * PI70476, PI70920, PI72150, PI72168, PI72726, PI73447,        *
    * PI73502, PI73563, PI74054, PI75073, PI75212, PI76922,        *
    * PI76975, PI77826, PI77849, PI78171, PI78656, PI79133,        *
    * PI79570, PI80086, PI81348, PI81647, PI82900, PI83286,        *
    * PI83288, PI83466, PI85160, PI87661, PI87731, PI89071,        *
    * PI90239, PI93108                                             *
    *                                                              *
    * Among the new functions and fixes included are:              *
    * PI69947:                                                     *
    * Db2 support for accelerating queries to IBM DB2 Analytics    *
    * Accelerator for z/OS V7                                      *
    *                                                              *
    * PI74054:                                                     *
    * This APAR enhances DB2z support for                          *
    * accelerating queries to IBM DB2                              *
    * Analytics Accelerator for z/OS V7.1                          *
    * in the following areas:                                      *
    * (1) CHAR(vargraphic, number)                                 *
    * (2) TRANSLATE(graphic)                                       *
    * (3) TIMESTAMP_FORMAT(                                        *
    *     '04-01-1950 24:00:00',                                   *
    *     'DD-MM-YYYY HH24:MI:SS')                                 *
    * (4) CHAR9(decimal)                                           *
    * (5) Query with graphic literal                               *
    * (6) When QUERY_ACCEL_OPTIONS=5                               *
    *     and QUERY_ACCEL_OPTIONS=6 are                            *
    *     not set, and there is                                    *
    *     timestamp>6 data type in the                             *
    *     query.                                                   *
    *                                                              *
    * PI76922:                                                     *
    * This APAR enhances DB2z support for                          *
    * accelerating queries to IBM DB2                              *
    * Analytics Accelerator for z/OS V7.1                          *
    * in the following areas:                                      *
    * (1) INSERT with SELECT when                                  *
    *      GRAPHIC/VARGRAPHIC is returned                          *
    *      from the Accelerator.                                   *
    * (2) INSERT with SELECT when                                  *
    *      CODEUNITS is involved and                               *
    *      CCSID conversion is needed.                             *
    * (3) LOCALE offloading support for                            *
    *      LCASE/LOWER/UCASE/UPPER.                                *
    * (4) CHAR/VARCHAR/GRAPHIC/VARGRAPHIC                          *
    *      function with CODEUNITS.                                *
    *                                                              *
    * PI80086:                                                     *
    * This APAR enhances DB2z support for                          *
    * accelerating queries to IBM DB2                              *
    * Analytics Accelerator for z/OS V7.1                          *
    * in the following areas:                                      *
    * (1) Further improvements for the                             *
    *     offloading of these functions:                           *
    *     CHAR/VARCHAR/GRAPHIC/VARGRAPHIC                          *
    *     CAST(expr AS CHAR/VARCHAR/                               *
    *     GRAPHIC/VARGRAPHIC)                                      *
    *     with CODEUNITS specified                                 *
    * (2) Improved rewrites for                                    *
    *     LCASE/LOWER/UCASE/UPPER with                             *
    *     two arguments and the second                             *
    *     argument is the length.                                  *
    * (3) DDL support for IDT.                                     *
    * (4) Fix for DSNXGRDS.DSNXEAB :M103                           *
    *     when Enable with Failback                                *
    *     acceleration is specified.                               *
    * (5) Improvement for offloading                               *
    *     COUNT and AVG functions.                                 *
    *                                                              *
    * PI82900:                                                     *
    * This APAR enhances Db2 for z/OS support                      *
    * for accelerating queries to IBM Db2                          *
    * Analytics Accelerator for z/OS V7.1                          *
    * in the following areas:                                      *
    * (1) AOT support.                                             *
    * (2) Explain support.                                         *
    * (3) SQLCODE -4742 with reason 11 for                         *
    *     Hex().                                                   *
    * (4) SQLCODE -104 for SELECT INTO                             *
    *     statement.                                               *
    * (5) Improve Sum() offloading.                                *
    *                                                              *
    * PI66573                                                      *
    * This APAR contains code changes that                         *
    * will enable multi-row INSERT operations                      *
    * against Accelerator-Only Tables.                             *
    *                                                              *
    * PI72150                                                      *
    * Currently, a user cannot specify a                           *
    * target accelerator for an                                    *
    * accelerated query to be executed. If a                       *
    * user has multiple accelerators where                         *
    * the same set of DB2 tables are                               *
    * accelerated, the accelerator workload                        *
    * balance algorithm will distribute the                        *
    * queries depending on queue length on                         *
    * each accelerator.                                            *
    *                                                              *
    * This APAR addresses that requirement                         *
    * by providing the new function support                        *
    * that allows a user to specify a target                       *
    * accelerator for accelerated queries.                         *
    *                                                              *
    * PI77826:                                                     *
    * Currently, customer data could be                            *
    * stored in different DB2 subsystems,                          *
    * separated by line of business or                             *
    * location. The customer cannot use a                          *
    * single query to reference tables from                        *
    * from different DB2 subsystems in a non-                      *
    * datasharing environment even if all                          *
    * tables are already offloaded into the                        *
    * same accelerator.                                            *
    * This APAR addresses that requirement                         *
    * by providing the new function support                        *
    * to allow a single query to reference                         *
    * tables from different DB2 subsystems.                        *
    * This APAR requires APAR PI82739 to be                        *
    * applied together with this APAR.                             *
    * This functionality also requires future APAR                 *
    * PI94666 to enable the supporting stored                      *
    * procedures.                                                  *
    *                                                              *
    * PI83286:                                                     *
    * APAR PI83286 is one of two APARs that                        *
    * together provide the new Accelerator                         *
    * function "Hybrid Transactional /                             *
    * Analytical Processing" (HTAP) for the                        *
    * existing Db2 feature QUERY ACCELERATION                      *
    * The companion APAR is PI83288 and these                      *
    * two APARs are packaged as one PTF.                           *
    *                                                              *
    * APAR PI83286 provides the following                          *
    * HTAP support:                                                *
    *  - New DB2 for z/OS subsystem parameter                      *
    *    QUERY_ACCEL_WAITFORDATA which                             *
    *    provides an initial default value                         *
    *    for new CURRENT QUERY ACCELERATION                        *
    *    WAITFORDATA special register                              *
    *  - New system-level statistics fields                        *
    *    in IFCID 2 Accelerator statistics                         *
    *    section Q8ST                                              *
    * This support is described in the                             *
    * following APAR text.                                         *
    *                                                              *
    * PI83288:                                                     *
    * APAR PI83288 is the main of two APARs                        *
    * that provide the new accelerator                             *
    * function "Hybrid Transactional /                             *
    * Analytical Processing" (HTAP) for                            *
    * existing feature Db2 QUERY ACCELERATION                      *
    * The companion APAR is PI83286 .                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available.                         *
    ****************************************************************
    Please refer to the closing text for the following APARs for
    more information and descriptions of the features and fixes
    included in PI91620:
    PI54149
    PI63736
    PI64476
    PI66166
    PI66573
    PI69947
    PI70476
    PI70920
    PI72150
    PI72168
    PI72726
    PI73447
    PI73502
    PI73563
    PI74054
    PI75073
    PI75212
    PI76922
    PI76975
    PI77826
    PI77849
    PI78171
    PI78656
    PI79133
    PI79570
    PI80086
    PI81348
    PI81647
    PI82900
    PI83286
    PI83288
    PI83466
    PI85160
    PI87661
    PI87731
    PI89071
    PI90239
    PI93108
    

Problem conclusion

  • The functionalities and fixes described above are now supported
    in Db2 12.
    IDAAV4R1/K IDAAV5R1/K IDAAV7R1/K
    

Temporary fix

Comments

  • n/a
    

APAR Information

  • APAR number

    PI91620

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-12-15

  • Closed date

    2018-03-06

  • Last modified date

    2018-08-23

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

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

    UI54293

Modules/Macros

  • DSNXOBAS DSNXRSPG DSNXOBAQ DSNXOMRG DSNTIVIE DSNXOST  DSNDQWPZ
    DSNTIVIA DSNWVSR1 DSNLIRCA DSNTIWMD DSNDSPRM DSNLXRWA DSNLXSR
    DSNXODML DSNX8CDA DSNXOBAC DSNLXENV DSNXRACC DSNECP19 DSNXESX
    DSNHSMP2 DSNX8CMD DSNX8EKG DSNXOSL  DSNXOYDB DSNXOD5  DSNWVZPS
    DSNFTDIR DSNTIJUZ DSNXOOS1 DSNLXROP DSNLCMT1 DSNXEAAL DSNHAPLY
    DSNTIP82 DSNXERT  DSNXEPP  DSNTIVAF DSNXECLF DSNTINMF DSNLXRFT
    DSNXOOS2 DSNXEPM  DSNXIEPL DSNLZOSR DSNLCITR DSNDQWHS DSNDQW05
    DSNECP29 DSNXEBPG DSNTXSTB DSNTIWMN DSNTIVIN DSNXISB6 DSNTIWMS
    DSNXOEXC DSNXRIWS DSNX8API DSNXOV1  DSNWZDG2 DSNXRFFL DSNXOV0
    DSNXOLTD DSNTBAS2 DSNXOEX1 DSNLXREL DSNX8SMF DSNFCDIR DSNECP70
    DSNLCDP1 DSNLXMRF DSNUGSIT DSNLXNEW DSNWVCOL DSNTBFR2 DSNLXHCS
    DSNXODTX DSNTIA1  DSNLZR00 DSNXOYP1 DSNECP08 DSNXENR  DSNXESSR
    DSN6SPRM DSNLXCQH DSNX8CXA DSNECP00 DSNXODTR DSNXERT2 DSNXOTF
    DSNTBBP2 DSNTBAB2 DSNXEDSC DSNHSYMH DSNXEET  DSNECP54 DSNECP55
    DSNXONZS DSNLCDG1 DSNXOP0  DSNTIAM  DSNTIVMD DSNLXRCM DSNTIWIA
    DSNLXRCL DSNLXRCN DSNXERBP DSNLIAAC DSNXONZO DSNTIWIE DSNTBRB2
    DSNLXRCS DSNXONZQ DSNTIWAF DSNXOPRU DSNXONZB DSNXONZC DSNX8CSA
    DSNLZF00 DSNWVINT DSNLZMON DSNLZRCD DSNTBCM5 DSNTIWIN DSNLXRSQ
    DSNXOSPR DSNLXRSS DSNTBCM  DSNXONZA DSNXEDP  DSNHSM2V DSNLBABR
    DSNTBCM2 DSNXECWU DSNXESXT DSNLXRBF DSNWAAPI DSNTBMSG DSNX8STA
    DSNXECWA DSNTIVMN DSNLISDA DSNX8WAC DSNXGRTM DSNXOFF  DSNXECW
    DSNHPTAB DSNXESQL DSNTIJAS DSNXEUFP DSNTIVMS DSNTXAZP DSNXOXM
    DSNLZREX DSNWZIFC DSNXRBIH DSNHSM7  DSNDQ8ST DSNFXDIR DSNLIRTR
    DSNXOIN  DSNTBSPL DSNLXCMT DSNLXRAX DSNTINST DSNECP41 DSNTIDXA
    DSNTBAP2 DSNTBAP1 DSNECP44 DSNTIDXB DSNECP45 DSNXEBR  DSNXRRSP
    DSNECP47 DSNHTBLS DSNLZSMT DSNLZRDT DSNTBAP  DSNXORFN DSNTBAR
    DSNLDICT DSNX8CTG DSNXEDS1 DSN@XAZP DSNLCSRR DSNXGRM1 DSNXOCAS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI54293

       UP18/03/21 P F803

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":"BU050","label":"BU NOT IDENTIFIED"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":""},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":""}]

Document Information

Modified date:
23 August 2018