IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PI26511

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-09-29

  • Closed date

    2015-01-14

  • Last modified date

    2015-02-03

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



Document information

More support for: DB2 for z/OS

Software version: A10

Reference #: PI26511

Modified date: 03 February 2015


Translate this page: