PK92329: VARIOUS EXPLAIN TABLE FIXES:DSN_VIRTUAL_INDEXES,DSN_PGROUP_TABLE, DSN_PTASK_TABLE, DSN_QUERY_TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Various Explain table fixes: DSN_VIRTUAL_INDEXES,
  DSN_PGROUP_TABLE, DSN_PTASK_TABLE, DSN_QUERY_TABLE
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 Explain.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: (1) An ABEND0CF RC0F at DSNXOLCM+D8F8   *
  *                      occurs when a row exists in             *
  *                      DSN_VIRTUAL_INDEXES with MODE='D' for a *
  *                      partitioning index on an index-         *
  *                      controlled partitioned table.           *
  *                       A row in DSN_VIRTUAL_INDEXES with      *
  *                      MODE='D' and a value of NULL for all    *
  *                      COLNOn and ORDERINGn columns is         *
  *                      incorrectly ignored.                    *
  *                                                              *
  *                      (2) Pruned query blocks incorrectly     *
  *                       appear in DSN_PGROUP_TABLE and         *
  *                       DSN_PTASK_TABLE.                       *
  *                                                              *
  *                      (3) DSN_PREDICAT_TABLE.TEXT does not    *
  *                       show the base column name when the     *
  *                       SQL uses a correlation name.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  (1) An ABEND0CF RC0F at DSNXOLCM+D8F8 occurs when a row exists
   in DSN_VIRTUAL_INDEXES with MODE='D' for a partitioning index
   on an index-controlled partitioned table.
     A row in DSN_VIRTUAL_INDEXES with MODE='D' and a value of
   NULL for all COLNOn and ORDERINGn columns is incorrectly
   ignored.
  
  (2) Pruned query blocks incorrectly appear in DSN_PGROUP_TABLE
      and DSN_PTASK_TABLE.
  
  (3) The base column name does not appear in
      DSN_PREDICAT_TABLE.TEXT when the predicate uses a
      correlation name.  As a result the TEXT column does not
      match the value in DSN_PREDICAT_TABLE.LEFT_HAND_SIDE and/or
      DSN_PREDICAT_TABLE.RIGHT_HAND_SIDE.
  
  Additional Keywords:
  DSN_VIRTUAL_INDEXES DSN_PGROUP_TABLE DSN_PTASK_TABLE
  DSN_PREDICAT_TABLE ABEND0CF  RC0F RC0000000F
  DSNXOLCM+D8F8 SQLEXPLAIN COLNO1 ORDERING1
  

Problem conclusion

• (1) DB2 was changed to properly process MODE='D' for a
   partitioning index on an index-controlled partitioned table for
   DSN_VIRTUAL_INDEXES.
      DB2 was changed to properly process MODE='D' when all COLNOn
   and ORDERINGn columns have a NULL value.
  
  (2) Pruned query blocks no longer appear in DSN_PGROUP_TABLE and
   DSN_PTASK_TABLE.
  
  (3) DSN_PREDICAT_TABLE.TEXT matches the value in LEFT_HAND_SIDE
   and RIGHT_HAND_SIDE for a correlation column name.
  

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:

  UK54180 UK54181

Modules/Macros

• DSNDOREC DSNXODTX DSNXOGP  DSNXOLL  DSNXOSJH
  DSNXOTL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK54180

     UP10/02/23 P F002

• R910 PSY UK54181

     UP10/02/23 P F002

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.