PI26511: ACCELERATED QUERY REFERENCING MORE THAN ONE DISABLED TABLE MAY RETURN SQLCODE4742 WITH INVALID REASON RSN13

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A query referencing tables t1 and t2 is routed to accelerator,
  2 accelerators are available to run the query.
  Table t1 is not enabled on first accelerator, t2 not enabled on
  second one.
  SQLCODE -4742 RSN 12 is expected in this case, instead DB2 is
  returning
  SQLCODE -4742 RSN 13
  DSN_QUERYINFO_TABLE.QI_DATA =
  The accelerator ....0... containing the tables of the query is
  not started.
  

Local fix

• n.a.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 for z/OS who use query      *
  *                 acceleration.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: EXPLAIN of an SQL statement that is     *
  *                      considered for query acceleration       *
  *                      when one or more tables is not enabled  *
  *                      for acceleration shows an incorrect     *
  *                      value in explain table                  *
  *                      DSN_QUERYINFO_TABLE.REASON_CODE         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  EXPLAIN of an SQL statement that is considered for query
  acceleration shows an incorrect value of 13 in explain table
  DSN_QUERYINFO_TABLE.REASON_CODE when:
  (1) More than one accelerator exists on the subsystem
  (2) Every accelerator is missing at least one table
      referenced in the SQL statement, meaning the query will
      never execute on any of the accelerators.
  
  The correct value for DSN_QUERYINFO_TABLE.REASON_CODE is 12
  to indicate that a table is not enabled for acceleration on
  one of the accelerators.
  
  Keywords:
  IDAAV3R1/K IDAAV4R1/K EXPLAIN
  

Problem conclusion

• DB2 code is fixed for expected EXPLAIN output.
  

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:

  UI24387 UI24388

Modules/Macros

•    DSNXONZA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI24387

     UP15/01/29 P F501

• RB10 PSY UI24388

     UP15/01/29 P F501

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.