PH23848: POSSIBLE EXTRA ROW IN DSN_QUERYINFO_TABLE AFTER EXPLAIN OF QUERYWITH DECFLOAT AND MODELING ON FOR IBM DB2 ANALYTICS ACCELERATOR

Obtain the fix for this APAR.

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