PK50235: OMPE ISPF ONLINE MONITOR EXPLAIN FUNCTION USING DISTRIBUTED RESULTS IN MESSAGE FPEM760 THE SQL STATEMENT IS NOT RECOGNIZED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running a select * from db2 tables from a distributed
  environment
  Planname . . . . . . . . . . . . : DISTSERV
  Connection ID  . . . . . . . . . : SERVER
  Connection type    . . . . . . . : DRDA Protocol
  user experiences the following error
  FPEM760 The SQL statement is not recognized or cannot be
  explained.
  
  Only SELECT, INSERT, UPDATE, and DELETE statements can be
  explained
  .
  When issuing a EXPLAIN from panel
   DGOMTWC2                      SQL Statement
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 - OMEGAMON Server                            *
  *                 - ISPF Monitoring dialogs                    *
  *                 - Explain                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Running a SQL statement                 *
  *                      "select * from any db2 table"           *
  *                      from a distributed environment          *
  *                      the user experiences the following      *
  *                      error message when issuing a EXPLAIN    *
  *                      from panel DGOMTWCS or DGOMTWC2:        *
  *                      "FPEM760 The SQL statement is not       *
  *                      recognized or cannot be explained."     *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  Running a SQL statement "select * from any db2 table" from a
  distributed environment the user experiences the following error
  message when issuing a EXPLAIN from panel DGOMTWCS or DGOMTWC2:
  "FPEM760
  The SQL statement is not recognized or cannot be explained."
  

Problem conclusion

• A distributed SQL statement with statement number ZERO can be
  EXPLAINED now.
  KEYWORDS: EXPLAIN FPEM760 DISTRIBUTED-SQL STMTNO-ZERO
  

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:

  PK51835 UK29064 UK29065

Modules/Macros

•    DGO@TPM3 DGO@YEDY DGO@YE00 DGO@YKSQ DGOFECHK
  DGOFEDPM DGOFEETD DGOMEXA0 DGOMEX00 DGOMSX00 DGOMTADJ DGOMTD01
  DGOMTPOP DGOMTREF DGOMTSQL DGOMTX00 DGOMYEDS DGOMYEDY DGOMYE00
  DGOMYKSQ DGOVISI  DGOVMSTR DGOVM000 DGOVM001 DGOVM002 DGOYTPM0
  DGOYTPM3 DGOZCRD  DGOZFL1  DGOZFL2  DGOZFL3  FPECMAIN FPEFMAIN
  FPEUFIOI FPEUFIO2 FPEUFIXE FPEUFIXS FPEUFI24 FPEUFLNS FPEUFLN2
  FPEUFLSP FPEUFLS2 FPEUFOCR FPEUFOC2 FPEUFTDS FPEUFTS2 FPEUFUDA
  FPEUFUIS FPEUFUIT FPEUFUNI FPEUFUN2 FPEUFWMX FPEUFYDY FPEUFYD2
  FPEUFYLD FPEUFYST FPEUFYS2 FPEUIFCI FPEUIFC2 FPEUT020
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK29064

     UP07/09/15 P F709

• R410 PSY UK29065

     UP07/09/15 P F709

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.