PH49972: DB2 13 FOR Z/OS NEW FUNCTION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 13 for z/OS new function enhancement to the PLAN_TABLE.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 13 for z/OS users who have a query                   *
  * containing view or table expression.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Currently, if a query contains a view                        *
  * or table expression, the                                     *
  * PLAN_TABLE.PARENT_PLANNO column value                        *
  * might not be populated for the query                         *
  * block that produces the result rows                          *
  * for that view or table expression.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  After a query that contains a view or table expression is
  explained, the PLAN_TABLE contains a plan for accessing the
  view or table expression, and it also contains a child query
  block that produces the result rows for the view or table
  expression. However, there is currently no linkage between the
  plan and the child query block in some scenarios. This APAR
  addresses the cases and write the PLAN_TABLE.PLANNO of the
  plan into PLAN_TABLE.PARENT_PLANNO of the corresponding child
  query block.
  Example:
  SELECT  DISTINCT TX.CX
  FROM TABLE (SELECT DISTINCT T1.C1, T2.C2
              FROM T1, T2
              WHERE T1.C1=T2.C1
              ) AS TX(CX, CY)
  ;
  In this query, the top query block contains a table expression
  TX, the child query block with T1, T2 is the source of TX.
  After this query is explained, PLAN_TABLE has a row for
  accessing TX in the top query block and the PLANNO of the row
  is 1. This APAR writes PLAN_TABLE.PARENT_PLANNO=1 into all the
  rows for the child query block in PLAN_TABLE.
  Additional Keywords:
  SQLVIEW SQLTABLEEXPR SQLEXPLAIN
  

Problem conclusion

Temporary fix

Comments

• If a query contains a view or table expression, the
  PLAN_TABLE.PARENT_PLANNO column value will be populated for
  the query block that produces the result rows for that view
  or table expression.
  

APAR Information

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

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

  UI83371

Modules/Macros

• DSNXOGP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI83371

     UP22/12/15 P F212

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.