PI43273: REPEATED OR DUPLICATE ROWS DISPLAYED IN FORMATTED EXPLAIN REPORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is reporting seeing repeated or duplicate entries in
  the formatted EXPLAIN report:
  .
  SDSF OUTPUT DISPLAY ESIPNSEX JOB08618  DSID   104 LINE 6,380
  COMMAND INPUT ===>
  THE FOLLOWING   1 EXPLAIN REQUESTS WERE PROCESSED:
  1:    G00P PACKAGE  : COLCRP2                      .BDCREVTC
              DETAIL REPORT REQUESTED
        DBRM/PACK   STMT TYP
  BDCREVTC     814 P S  MATCHING INDEX SCAN(3/5)-DATA PAGES 1-2
  BDCREVTC     814 P S  MATCHING INDEX SCAN(3/5)-DATA PAGES 1-7
  BDCREVTC     814 P S  MATCHING INDEX SCAN(3/5)-DATA PAGES 1-12
  BDCREVTC     814 P S  MATCHING INDEX SCAN(3/5)-DATA PAGES 1-17
  BDCREVTC     814 P    ADDITIONAL SORT FOR ORDER BY        1-22
  BDCREVTC     814 P    ADDITIONAL SORT FOR ORDER BY        1-24
  BDCREVTC     814 P    ADDITIONAL SORT FOR ORDER BY        1-26
  BDCREVTC     814 P    ADDITIONAL SORT FOR ORDER BY        1-28
  BDCREVTC     852 P S  MATCHING INDEX SCAN(3/5)-DATA PAGES 1-30
  BDCREVTC     852 P S  MATCHING INDEX SCAN(3/5)-DATA PAGES 1-35
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - EXPLAIN                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Repeated or duplicate rows displayed    *
  *                      on BATCH EXPLAIN report summary page.   *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  The DB2 tool Path Checker copies PLAN_TABLE rows and
  modify only the columns HINT_USED and OPTHINT.
  In BATCH EXPLAIN all PLAN_TABLE rows are reported.
  This leads to identical access path text on the EXPLAIN
  summary page. The last token of a summary page row is a
  page reference to the full formatted PLAN_TABLE row.
  This page reference is different.
  
  PROBLEM CONCLUSION:
  Duplicate access path text on the EXPLAIN summary page
  is suppressed.
  
  KEYWORDS:
  EXPLAIN SUMMARY REPORT DUPLICATE ROWS
  

Problem conclusion

• Duplicate access path text on the EXPLAIN summary page
  is suppressed.
  

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:

  UI28657 UI28658 UI28659 UI28660

Modules/Macros

•    DGOYPSUM
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UI28657

     UP15/06/19 P F506

• R511 PSY UI28658

     UP15/06/19 P F506

• R520 PSY UI28659

     UP15/06/19 P F506

• R530 PSY UI28660

     UP15/06/19 P F506

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.