PK75872: THE DB2 V8 VALUES "RW", "T " AND "V " FOR THE PLAN_TABLE COLUMN ACCESSTYPE ARE CURRENTLY NOT SUPPORTED IN BATCH EXPLAIN.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• the DB2 V8 values "RW", "T " and "V " for the PLAN_TABLE column
  ACCESSTYPE are currently not supported in Batch Explain.
  

Local fix

• No work around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Explain                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.                                      *
  *                      Report text "INVALID ACCESSTYPE" is     *
  *                      displayed if the DB2 V8                 *
  *                      PLAN_TABLE.ACCESSTYPE field has the     *
  *                      value "RW", "T " or "V ".               *
  *                      2.                                      *
  *                      Report text "INVALID ACCESSTYPE" is     *
  *                      displayed if the DB2 V9                 *
  *                      PLAN_TABLE.ACCESSTYPE field has the     *
  *                      value "DI", "DU", "DX", "E " or "P ".   *
  *                      3.                                      *
  *                      No report text is displayed if the      *
  *                      PLAN_TABLE.JOIN_TYPE field has the      *
  *                      value "P".                              *
  *                      4.                                      *
  *                      No report text is displayed if the      *
  *                      PLAN_TABLE.PARALLELISM_MODE field has   *
  *                      the value "X".                          *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. Report text "INVALID ACCESSTYPE" is displayed
     if the DB2 V8 PLAN_TABLE.ACCESSTYPE field has the
     value "RW", "T " or "V ".
  2. Report text "INVALID ACCESSTYPE" is displayed
     if the DB2 V9 PLAN_TABLE.ACCESSTYPE field has the
     value "DI", "DU", "DX", "E " or "P ".
  3. No report text is displayed if the
     PLAN_TABLE.JOIN_TYPE field has the value "P".
  4. No report text is displayed if the
     PLAN_TABLE.PARALLELISM_MODE field has the value "X".
  
  PROBLEM CONCLUSION:
  1. Report lines for DB2 V8 PLAN_TABLE.ACCESSTYPE
     "RW" - WORK FILE SCAN (MATERIALIZED USER DEFINED TABLE
            FUNCTION)
     "T " - SPARSE INDEX (STAR JOIN WORK FILES)
     "V " - BUFFERS FOR AN INSERT STATEMENT WITHIN A SELECT
  2. Report lines for DB2 V9 PLAN_TABLE.ACCESSTYPE
     "DI" - INTERSECTION OF MULTIPLE DOCID LISTS
     "DU" - UNION OF MULTIPLE DOCID LISTS
     "DX" - XML INDEX SCAN
     "E " - DIRECT ROW ACCESS USING A ROW CHANGE TIMESTAMP
     "P " - DYNAMIC PAIR-WISE INDEX SCAN
  3. Report line for PLAN_TABLE.JOIN_TYPE
     "P"  - PAIR-WISE JOIN OPERATION WILL BE USED
  4. Report line for PLAN_TABLE.PARALLELISM_MODE
     "X"  - SYSPLEX QUERY PARALLELISM WILL BE USED
  
  KEYWORDS:
  BATCH-EXPLAIN PLAN_TABLE.ACCESSTYPE
  PLAN_TABLE.JOIN_TYPE PLAN_TABLE.PARALLELISM_MODE
  

Problem conclusion

• PROBLEM CONCLUSION:
  1. Report lines for DB2 V8 PLAN_TABLE.ACCESSTYPE
     "RW" - WORK FILE SCAN (MATERIALIZED USER DEFINED TABLE
            FUNCTION)
     "T " - SPARSE INDEX (STAR JOIN WORK FILES)
     "V " - BUFFERS FOR AN INSERT STATEMENT WITHIN A SELECT
  2. Report lines for DB2 V9 PLAN_TABLE.ACCESSTYPE
     "DI" - INTERSECTION OF MULTIPLE DOCID LISTS
     "DU" - UNION OF MULTIPLE DOCID LISTS
     "DX" - XML INDEX SCAN
     "E " - DIRECT ROW ACCESS USING A ROW CHANGE TIMESTAMP
     "P " - DYNAMIC PAIR-WISE INDEX SCAN
  3. Report line for PLAN_TABLE.JOIN_TYPE
     "P"  - PAIR-WISE JOIN OPERATION WILL BE USED
  4. Report line for PLAN_TABLE.PARALLELISM_MODE
     "X"  - SYSPLEX QUERY PARALLELISM WILL BE USED
  
  KEYWORDS:
  BATCH-EXPLAIN PLAN_TABLE.ACCESSTYPE
  PLAN_TABLE.JOIN_TYPE PLAN_TABLE.PARALLELISM_MODE
  

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:

  UK44805

Modules/Macros

•    DGO@BLOK DGO@CNDX DGO@FIST DGO@MAIN DGO@SPCK
  DGO@TCO1 DGO@TDB1 DGO@TDM3 DGO@TIX1 DGO@TIX3 DGO@TKY3 DGO@TPG1
  DGO@TPG2 DGO@TPG3 DGO@TPG4 DGO@TPG5 DGO@TPL1 DGO@TPL3 DGO@TPL4
  DGO@TPM1 DGO@TPM2 DGO@TPM3 DGO@TPM4 DGO@TPM5 DGO@TPT0 DGO@TSM1
  DGO@TSM2 DGO@TSM3 DGO@TSM4 DGO@TSM5 DGO@TTB1 DGO@TTC1 DGO@XPCK
  DGO@XPLC DGO@YDSQ DGO@YE01 DGO@YID0 DGO@YIK0 DGO@YI00 DGO@YKSQ
  DGO@YOCD DGO@YOCI DGO@YODI DGO@YOII DGO@YOIM DGO@YOKI DGO@YOPI
  DGO@YOPT DGO@YOTI DGO@YOTS DGO@YQPT DGO@YX00 DGOMYDSQ DGOMYE01
  DGOMYID0 DGOMYIK0 DGOMYI00 DGOMYKSQ DGOMYOCD DGOMYOCI DGOMYODI
  DGOMYOII DGOMYOIM DGOMYOKI DGOMYOPI DGOMYOPT DGOMYOTI DGOMYOTS
  DGOMYQPT DGOMYX00 DGOYBLOK DGOYCNDX DGOYFIST DGOYJOIN DGOYMAIN
  DGOYPSUM DGOYRTC0 DGOYSPCK DGOYSTAB DGOYSUMM DGOYSVRS DGOYTCO1
  DGOYTDB1 DGOYTDM3 DGOYTIX1 DGOYTIX3 DGOYTKY3 DGOYTPG1 DGOYTPG2
  DGOYTPG3 DGOYTPG4 DGOYTPG5 DGOYTPL1 DGOYTPL3 DGOYTPL4 DGOYTPM1
  DGOYTPM2 DGOYTPM3 DGOYTPM4 DGOYTPM5 DGOYTPT0 DGOYTSM1 DGOYTSM2
  DGOYTSM3 DGOYTSM4 DGOYTSM5 DGOYTTB1 DGOYTTC1 DGOYU100 DGOYXPCK
  DGOYXPLC
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK44805

     UP09/03/13 P F903

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.