A fix is available
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
23 August 2018