IBM Support

PI47444: SELECT ON A VIEW WITH CORRELATED TABLE EXPRESSION REFERENCE ABENDS WHEN ROUTED TO THE ACCELERATOR

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • We have a view definition with correlated table expression
    reference like
    SELECT ...
     From table1 A
     Left Outer Join Table
     ( Select .*
      From table2 B
       Where A.col1 = B.col1 ) AS X
    This is not supported on the accelerator. We get SQLCODE901
    -901 with error message
    ANALYTICS ACCELERATOR TOKENS 42S02: relation does not  exist
    DWA_LOCATION_x.DWA_USER_x.ACC00n
    .
    Expected is SQLCODE4742 -4742 reason 9.
    

Local fix

  • n.a.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use query      *
    *                 acceleration.                                *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR fixes an SQLCODE -901 or      *
    *                      -204 when a query referencing a view    *
    *                      that contains a table expression with   *
    *                      one or more correlated references to    *
    *                      other tables in the same FROM clause    *
    *                      is considered for acceleration.         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR fixes an SQLCODE -901 or -204 when a query
    referencing a view that contains a table expression with one or
    more correlated references to other tables in the same FROM
    clause is incorrectly considered eligible for acceleration.
    
    Keywords:
    IDAAV4R1/K SQLCODE901 SQLCODE204 SQLVIEW SQLTABLEEXPR
    

Problem conclusion

  • Code is fixed such that queries referencing a view that contain
    a table expression with one or more correlated references to
    other tables in the same FROM clause are no longer considered
    eligible for acceleration.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI47444

  • 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

    2015-08-25

  • Closed date

    2015-10-21

  • Last modified date

    2015-12-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI32264 UI32265

Modules/Macros

  •    DSNXONZO
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI32264

       UP15/11/06 P F511

  • RB10 PSY UI32265

       UP15/11/06 P F511

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 #: PI47444

Modified date: 02 December 2015


Translate this page: