PK34702: FORWARD FIT V2 EXPLAIN APARS:PK24510 PK27610 PK32352 PK09324: SYSPACKAGE PERF,NO REPORT,MSGFPEY0509W,DGOMYWCM INVALID COL TYPE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. When using batch explain with DB2PE V2.1 code, the explains
  have very poor performance due to tablespace scans on, for
  example SYSKEYS and SYSPACKAGE.
  2. When I run a batch explain using the first and last
  parametersno output is received, however, RC=0.
  When running same job without first and last parameter output
  is received.
  3. DB2PE EXPLAIN MSGFPEY0509W  FUNCTION STEP SELECT FOR TABLE
  DGO_SYSTABLES FAILED. SQLCODE=100 DSNT404I SQLCODE = 100, NOT
  FOUND:  ROW NOT FOUND FOR FETCH,UPDATE, OR DELETE, OR THE
  RESULT OF A QUERY IS AN EMPTY TABLE.DSNT418I SQLSTATE   =
  02000 SQLSTATE RETURN CODE
  Situation occurs when PLAN_TABLE column TNAME has value D
  4. Panel DGOMYWCM shows an invalid column type and length if
  more columns are displayed. The next sub panel DGOMYWCI shows
  the correct info.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 - Batch Explain                              *
  *                 - Online Monitor Explain                     *
  *                 - ISPF Monitoring dialogs                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: --------------------------------------- *
  *                      1.  For the Batch Explain function      *
  *                      1.1 The performance for EXPLAIN PACKAGE *
  *                          is improved for DB2 V8 CompatMode   *
  *                          and V7. The access to the catalog   *
  *                          tables SYSPACKAGE, SYSPACKLIST, and *
  *                          SYSKEYS was changed.                *
  *                      1.2 Batch explain doesn't produce       *
  *                          reports when the EXPLAIN PACKAGE    *
  *                          command is using the FIRST and LAST *
  *                          parameter.                          *
  *                      1.3 Message "FPEY0509W Function step    *
  *                          SELECT for table DGO_SYSTABLES      *
  *                          FAILED" occurs if the PLAN_TABLE    *
  *                          column TABLE_TYPE has the value     *
  *                          "W" for a work table. For this      *
  *                          situation this message is invalid.  *
  *                      1.4 DB2 V9 toleration support for a     *
  *                          PLAN_TABLE up to 59 columns.        *
  *                                                              *
  *                      2.  For the OLM Explain function        *
  *                      2.1 The performance for EXPLAIN PACKAGE *
  *                          is improved for DB2 V8 CompatMode   *
  *                          and V7. The access to the catalog   *
  *                          tables SYSPACKAGE, SYSPACKLIST, and *
  *                          SYSKEYS was changed.                *
  *                      2.2 Panel DGOMYWCM shows an invalid     *
  *                          column type and length if more than *
  *                          one column is displayed. The next   *
  *                          subpanel DGOMYWCI shows the correct *
  *                          info.                               *
  *                      2.3 DB2 V9 toleration support for a     *
  *                          PLAN_TABLE up to 59 columns.        *
  *                                                              *
  *                      3.  For the ISPF Monitoring dialog      *
  *                      3.1 Performing a split screen from the  *
  *                          OMPE Online Monitor and trying to   *
  *                          get into thread panel option 3 user *
  *                          experiences IEA995I SYMPTOM DUMP    *
  *                          OUTPUT. SYSTEM COMPLETION CODE=0C1. *
  *                          FPEMMAIN terminated abnormally.     *
  *                      --------------------------------------- *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  --------------------------------------------------------------
  1.  Users of the Batch Explain function
  1.1 Performance improvement SYSPACKAGE
  1.2 No report with FIRST and LAST parameter
  1.3 MSGFPEY0509W Function step SELECT for table DGO_SYSTABLES
      failed. SQLCODE=100
  1.4 DB2 V9 toleration support for a PLAN_TABLE up to 59 cols.
  
  2.  Users of the OLM Explain function
  2.1 Performance improvement SYSPACKAGE
  2.2 Panel DGOMYWCM shows invalid column type and length
  2.3 DB2 V9 toleration support for a PLAN_TABLE up to 59 cols.
  
  3.  Users of the ISPF Monitoring dialog
  3.1 Performing a split screen from the OMPE Online Monitor and
      trying to get into thread panel option 3 user experiences
      IEA995I SYMPTOM DUMP OUTPUT. SYSTEM COMPLETION CODE=0C1.
      FPEMMAIN terminated abnormally.
  --------------------------------------------------------------
  

Problem conclusion

• --------------------------------------------------------------
  1.  Users of the Batch Explain function
  1.1 Performance improvement SYSPACKAGE
  1.2 The filter defined by the FIRST and LAST parameter was
      corrected.
  1.3 No error message occurs if the PLAN_TABLE column
      TABLE_TYPE has a value "W" for a work table.
  1.4 DB2 V9 toleration support for a PLAN_TABLE up to 59 cols.
  
  2.  Users of the OLM Explain function
  2.1 Performance improvement SYSPACKAGE
  2.2 Panel DGOMYWCM shows valid column type and length
  2.3 DB2 V9 toleration support for a PLAN_TABLE up to 59 cols.
  
  3.  Users of the ISPF Monitoring dialog
  3.1 Trying to start the OMPE Online Monitor in a
      ISPF split screen session results in message
      "FPEU0015I Second session not supported".
  
  KEYWORDS: EXPLAIN DB2V9 ISPFOLM SPLITSCREEN
  --------------------------------------------------------------
  

Temporary fix

Comments

APAR Information

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

  PK31673

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

  UK20317

Modules/Macros

•    DGO@ALPT DGO@BLOK DGO@CNDX DGO@MAIN DGO@SEEE
  DGO@SPCK DGO@TKY3 DGO@TPG1 DGO@TPG2 DGO@TPG3 DGO@TPG4 DGO@TPG5
  DGO@TPL1 DGO@TPL3 DGO@TPL4 DGO@TPM2 DGO@TSM4 DGO@XPCK DGO@XPLC
  DGO@YE00 DGO@YE01 DGO@YIK0 DGO@YI00 DGO@YOCD DGO@YOCI DGO@YOCM
  DGO@YOKI DGO@YOPI DGO@YOPT DGO@YQPT DGO@YX00 DGOMYE00 DGOMYE01
  DGOMYIK0 DGOMYI00 DGOMYOCD DGOMYOCI DGOMYOCM DGOMYOKI DGOMYOPI
  DGOMYOPT DGOMYQPT DGOMYX00 DGOYALPT DGOYBLOK DGOYCKPT DGOYCNDX
  DGOYFPCK DGOYGPCK DGOYJOIN DGOYMAIN DGOYPHDR DGOYPLA1 DGOYRTB0
  DGOYSEEE DGOYSPCK DGOYSTAB DGOYSUMM DGOYSVRS DGOYTKY0 DGOYTKY3
  DGOYTPG0 DGOYTPG1 DGOYTPG2 DGOYTPG3 DGOYTPG4 DGOYTPG5 DGOYTPL0
  DGOYTPL1 DGOYTPL3 DGOYTPL4 DGOYTPM2 DGOYTSM4 DGOYT000 DGOYXPCK
  DGOYXPC1 DGOYXPC2 DGOYXPC3 DGOYXPC4 DGOYXPC5 DGOYXPLC FPEFMAIN
  FPEYCV71 FPEYCV81 FPEYEXPL HKDB410J KD261SEX
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK20317

     UP06/12/08 P F612

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.