PK36298: DB2 ZPARM OPTION "GENERATE DESCRIBE FOR STATIC SQL" IN DB2 TO SUPPORT PE CLIENT BECOMES OBSOLETE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Starting with PE Client shipped in PTF UK19795 the ZPARM option
  "Generate Describe For Static SQL" does no longer have to be set
  for the DB2 subsystem to be monitored with OMEGAMON XE for DB2
  on z/OS using the  PE Worstation Client.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   OMEGAMON Server                          *
  *                     with Performance Warehouse               *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the DB2 ZPARM "Generate Describe   *
  *                      For Static SQL" is not set for the DB2  *
  *                      subsystem to be monitored and function  *
  *                      Performance Warehouse is activated      *
  *                      the start up of the corresponding       *
  *                      OMEGAMON XE data server instance        *
  *                      component fails and error message       *
  *                      FPEV0156E is issued.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Error message FPEV0156E is issued during start up
  of OMEGAMON XE sever.
  

Problem conclusion

Temporary fix

Comments

• Starting with the PE Workstation Client shipped in PTF UK19795
  (WSLevel L1364) the ZPARM
  "Generate Describe For Static SQL" does no longer
  have to be set for the DB2 subsystem to be monitored with
  OMEGAMON XE for DB2 on z/OS using the Performance Warehouse
  interface of the PE Worstation Client.
  -----------------------------------
  Keywords: ZPARM Generate Describe For Static SQL PWH
            FPEV0156E
  

APAR Information

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

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

  UK20992

Modules/Macros

•    DGOVMIDI DGOVM000 DGOVM001
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK20992

     UP07/01/05 P F701

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.