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

Obtain the fix for this APAR.

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