PK18505: DB2PE/PM SQLCODE100 IN ONLINE EXPLAIN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When customer is using online explain (Select View Online
  Activity-> Displau Thread Activity->Thread Detail panel -> SQL
  Statement and Program -> Explain). After the SQLCODE100 panel,
  the output of the explain is shown. The SQLCODE100 panel is only
  when the plan is bound with explain(NO) if it is bound with
  explain(yes) the panel is not shown.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1. Users of the Batch Explain function       *
  *                 2. Users of the OLM Explain function         *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1.  Regarding the Batch Explain functio *
  *                      1.1 The performance for EXPLAIN PLAN    *
  *                          is improved for DB2 V8 CompatMode,  *
  *                          V7 and V6. The access to the        *
  *                          catalog table SYSSTMT was changed.  *
  *                          Note: Indexes for table SYSSTMT     *
  *                          must be available.                  *
  *                      1.2 The number of SQL stmts for         *
  *                          EXPLAIN PLAN in the report          *
  *                          is corrected.                       *
  *                      2.  Regarding the OLM Explain function  *
  *                      2.1 The performance for EXPLAIN DBRM    *
  *                          is improved for DB2 V8 CompatMode,  *
  *                          V7 and V6. The access to the        *
  *                          catalog table SYSSTMT was changed.  *
  *                          Note: Indexes for table SYSSTMT     *
  *                          must be available.                  *
  *                      2.2 The unnecessary message SQLCODE100  *
  *                          for Thread-Explain is suppressed.   *
  *                      2.3 Valid display of msg FPEM761 and    *
  *                          FPEM762 for Thread-Explain.         *
  *                          The above msg depends on            *
  *                          - Thread with static or dynamic SQL *
  *                          - A DECLARE CURSOR stmt or others   *
  *                          - Precompiler with EBCDIC or        *
  *                            UNICODE output                    *
  *                          - Program bound as PLAN or PACKAGE  *
  *                          - Program bound with option         *
  *                            EXPLAIN(YES) or EXPLAIN(NO)       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1.  Users of the Batch Explain function
  1.1 Batch Explain performance improvement SYSSTMT
  1.2 Number of SQL stmts for EXPLAIN PLAN in report corrected
  2.  Users of the OLM Explain function
  2.1 OLM Explain performance improvement SYSSTMT
  2.2 Suppress unnecessary message SQLCODE100 for Thread-Explain
  2.3 Valid display of msg FPEM761 FPEM762 for Thread-Explain
  

Problem conclusion

• SYSMOD TITLE: EXPLAIN  (short Title of the PTF !)
  KEYWORDS:  EXPLAIN     (search key)
  

Temporary fix

Comments

APAR Information

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

  PK11875

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

  UK11125

Modules/Macros

•    DGO@FIST DGO@FPCK DGO@MAIN DGO@PLAN DGO@SPCK
  DGO@TDM3 DGO@TPM1 DGO@TPM2 DGO@TPM3 DGO@TPM4 DGO@TPM5 DGO@TSM1
  DGO@TSM2 DGO@TSM3 DGO@TSM4 DGO@TSM5 DGO@XPLC DGO@YDSQ DGO@YID0
  DGO@YIK0 DGO@YKSQ DGO@YODI DGO@YOKI DGO@YOPI DGO@YX00 DGOMYDSQ
  DGOMYID0 DGOMYIK0 DGOMYKSQ DGOMYODI DGOMYOKI DGOMYOPI DGOMYX00
  DGOYFIST DGOYFPCK DGOYGPCK DGOYMAIN DGOYPLAN DGOYPLA1 DGOYPLA2
  DGOYSPCK DGOYTDM0 DGOYTDM3 DGOYTPM0 DGOYTPM1 DGOYTPM2 DGOYTPM3
  DGOYTPM4 DGOYTPM5 DGOYTSM0 DGOYTSM1 DGOYTSM2 DGOYTSM3 DGOYTSM4
  DGOYTSM5 DGOYXPLC FPEYCV71 FPEYCV81 FPEYEXPL HKDB310J KD260SEX
  

Fix information

• Fixed component name

  OM XE DB2PE/PM/

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK11125

     UP06/01/27 P F601

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.