A fix is available
APAR status
Closed as new function.
Error description
Db2 12 for z/OS new function to support IBM Db2 Analytics Accelerator Accelerator-Only Tables (AOTs). Additional Keywords: IDAAV7R1/K IDAAV7R5/K
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of the following: * * - IBM Db2 Analytics Accelerator V7 and * * Accelerator Only tables ( AOT ) * * - IBM Service SQL, which uses the * * Db2-supplied stored procedure * * SYSPROC.ADMIN_INFO_SQL or the batch * * program DSNADMSB to collect Service SQL * * documentation for support either * * directly or via any of the following * * tools: * * o Query Environment Capture feature of * * Data Studio * * o Query Environment Capture feature of * * Optim Query Workload Tuner * * o Capture Query Environment feature of * * Data Server Manager * **************************************************************** * PROBLEM DESCRIPTION: * * This APAR contains Db2 for z/OS code * * to support future new function for * * Accelerator-only tables (AOTs) used * * with IBM Db2 Analytics Accelerator V7. * * This Db2 support will be enabled and * * described in a later APAR/PTF. * * . * * Additionally, this APAR also addresses * * the following issues related to * * the existing Db2 support for AOTs: * * - CREATE TABLE table-name ... * * IN ACCELERATOR accelerator-name * * where accelerator-name > 8 chars, * * receives SQLCODE -4747 but * * SQLCODE -107 is more applicable * * and should be returned instead. * * . * * - INSERT INTO AOT is attempted in UOW * * that results in multi-site updates. * * SQLCODE -919 is received and COMMIT * * processing is abnormally terminated * * with reason 00D3010D / X'00D3010D' . * * If an SQL ROLLBACK is then executed, * * Db2 also returns SQLCODE -919 for * * the ROLLBACK, which is not expected. * * . * * SQLCODE -571 is more applicable for * * the "INSERT INTO AOT" multi-site * * update attempt, and also prevents * * the 2nd SQLCODE -919 on the later * * SQL ROLLBACK. * * . * * - SQL stmt references both an AOT * * and a Db2 accelerated table * * where both tables exist on an IBM * * Db2 Analytics Accelerator V7 and * * that accelerator-name is < 8 chars. * * The SQL stmt fails with Db2 SQLCODE * * -4742 with reason code 22 if the * * user previously issues SET CURRENT * * ACCELERATOR specifying that * * accelerator-name as the preferred * * accelerator for Db2 to use. * * . * * Db2 should use this SET CURRENT * * ACCELERATOR value specifying the * * accelerator name < 8 chars for this * * SQL stmt case and not fail the stmt. * * . * * - SQLCODE -904 with reason 00E30305 * * from Db2 csect DSNXEAAL is returned * * for static SQL stmt that references * * an AOT and the same application, * * bound with QUERYACCELERATION(ALL), * * also contains a static SQL DROP * * TABLE for that AOT followed by * * a static SQL CREATE TABLE for the * * same AOT. * * . * * Db2 should not fail this static SQL * * stmt AOT scenario with SQLCODE -904. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR contains Db2 for z/OS code to support future new function for Accelerator-only tables (AOTs) used with IBM Db2 Analytics Accelerator V7. This Db2 support will be enabled and described in a later APAR/PTF that will reference this PH30574 APAR. As part of this future new function support, this APAR also updates the batch program DSNADMSB and the stored procedure SYSPROC.ADMIN_INFO_SQL. . Additionally, this APAR also fixes the four issues previously described under the Problem Description section related to the "existing" Db2 support for Accelerator-only tables. The later follow-up new function enabling APAR/PTF is not needed to take advantage of these fixes for the existing Db2 AOT support.
Problem conclusion
Temporary fix
Comments
Apply the PTF when available. To use the new function for Accelerator-only tables, also apply the follow-up enabling APAR/PTF when it is available. . This PTF modifies the batch program DSNADMSB and the stored procedure SYSPROC.ADMIN_INFO_SQL to print and to generate INSERT statements for the latest version of the SYSACCEL.SYSACCELERATEDTABLES and SYSACCEL.SYSACCELERATEDPACKAGES tables in the EXPL and SQL output files respectively. If you have already installed or migrated to Db2 12 then after applying this PTF you need to run your copy of job DSNTIJRT with MODE(INSTALL) to bind the ADMIN_INFO_SQL DBRM DSNADMSS. If you have previously run DSNTIJRT, rerunning with MODE(INSTALL) will also cause it to detect and correct only missing and downlevel SQL objects and packages for Db2-supplied routines. Note: Use MODE(INSTALL-PREVIEW) to obtain a report of any changes without processing them. The PREVIEW option will also generate and output a JCL job to the JCLOUT DD that contains any SQL and bind statements to be processed. After reviewing the changes, either rerun DSNTIJRT without the PREVIEW option or customize and run the generated job. If you have not followed these instructions to bind the ADMIN_INFO_SQL DBRM DSNADMSS after applying PTF UI73236 for PH30574, then you will see the following error symptom or similar when you execute ADMIN_INFO_SQL or DSNADMSB : DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME ABCDE1.DSNADM.DSNADMSS.1B2020720FA8DC20 NOT FOUND IN PLAN DSNADMSB. REASON 02 Additional Keywords: SQLCODE4747 SQLCODE107 SQLCODE919 RSN00D3010D SQLCODE571 SQLCODE904 RSN00E30305 SQLCODE4742 RSN22 IDAAV7R1/K IDAAV7R5/K SQLCODE805 REASON02 DISTSERV
APAR Information
APAR number
PH30574
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-10-14
Closed date
2020-12-18
Last modified date
2021-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI73236
Modules/Macros
DSNXODML DSNX8EKG DSNHSM5 DSNXOIN DSNXECWA DSNXI14 DSNXEDSC DSNXECWU DSNXONZA DSNLXRCN DSNX8CTG DSNXOBZB DSNX8API DSNX8WAC DSN@DMSS DSNXOBZA DSNXERT2 DSNXICTB DSNADMSS DSNXEBPG DSNXIDTB DSNXONZB DSNXIIEP DSNLMTOK DSNXISB9 DSNXISTK DSNXIDPM DSNXOD5 DSNXECW DSNXISB6
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI73236
UP20/12/31 P F012
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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"12.0"}]
Document Information
Modified date:
02 February 2021