PI14462: DUPLICATE LINES IN THE PLAN_TABLE DATA OF THE "EXPLAIN INFORMATION FOR STATEMENT" REPORT OF THE EEE FILE.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Duplicate lines in the PLAN_TABLE data of the "EXPLAIN
  Information for Statement" report of the EEE file.
  
  FOR EXAMPLE:
  - the user specified package collid1.pkg1 on panel 1.2 to
    EXPLAIN
  - The PLAN_TABLE data of the "EXPLAIN Information for Statement"
    report in the EEE file shows information for collid2.pkg1
  
  SQLPA incorrectly shows information for both collid2.pkg1 along
  with expected information for collid1.pkg1 because the QUERYNO
  is the same.
  
  The PTF will correct the program to show only the specified
  collection id details.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of SQL Performance Analyzer.       *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      Duplicate lines in the report           *
  *                      for PLAN_TABLE data.                    *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• Apply the PTF for problem resolution.
  

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:

  UI17989 UI17990

Modules/Macros

• ANLEEE
  

Fix information

• Fixed component name

  DB2 SQL PERF AN

• Fixed component ID

  5697F5701

Applicable component levels

• R410 PSY UI17989

     UP14/05/20 P F405

• R420 PSY UI17990

     UP14/05/20 P F405

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.