A fix is available
APAR status
Closed as program error.
Error description
Possible extra row can appear in DSN_QUERYINFO_TABLE after EXPLAIN of a query using the DECFLOAT data type for IBM Db2 Analytics Accelerator V7, and modeling of query workloads is ON. Additional Keywords: IDAAV7R1/K IDAAV7R5/K
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 v12 for z/OS users who use IBM * * Db2 Analytics Accelerator V7. * **************************************************************** * PROBLEM DESCRIPTION: * * An extra row might be populated into * * DSN_QUERYINFO_TABLE when the following * * conditions are met: * * (1) there is IBM Db2 Analytics * * Accelerator V7 installed in the * * Db2z system, * * (2) Db2 V12 subsystem parameter * * ACCELMODEL = YES for Db2 * * Accelerator Modeling, * * (3) QUERY ACCELERATION is NONE or not * * specified, * * (4) there are multiple reasons that * * the query is not qualified to be * * offloaded to IBM Db2 Analytics * * Accelerator V5. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** An extra row which explained why the query is not qualified to be offloaded to IBM Db2 Analytics Accelerator V5 might be populated into DSN_QUERYINFO_TABLE when the following conditions are met: (1) there is IBM Db2 Analytics Accelerator V7 installed in the Db2z system, (2) Db2 V12 subsystem parameter ACCELMODEL = YES for Db2 Accelerator Modeling, (3) QUERY ACCELERATION is NONE or not specified, (4) there are multiple reasons that the query is not qualified to be offloaded to IBM Db2 Analytics Accelerator V5. When there exists multiple reasons that a query is not qualified to be offloaded to a specific version of accelerator, Db2z will output the first reason it detects and populate it into DSN_QUERYINFO_TABLE. For example, when a query is not qualified to be offloaded to IBM Db2 Analytics Accelerator V5 with the following two reasons: (a) There is DECFLOAT in the query, (b) Based on costing, the query is a short-running query. Db2z normally will only populate the first reason it detects( in this case, it's DECFLOAT data type). However, under the above conditions, both reasons will be populated into DSN_QUERYINFO_TABLE table. . Additional Search Keywords: SQLACCELMODEL SQLDECFLOAT IDAAV5R1/K IDAAV7R1/K IDAAV7R5/K
Problem conclusion
After the fix, there will be no extra row populated into DSN_QUERYINFO_TABLE for Accelerator Modeling when QUERY ACCELERATION is NONE or not specified.
Temporary fix
Comments
APAR Information
APAR number
PH23848
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
2020-03-30
Closed date
2020-06-25
Last modified date
2020-08-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DSNXONZO
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI70279
UP20/07/07 P F007
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:
14 December 2020