PK71270: PE SERVER SUBTASK GENERATES NEGATIVE SQLCODE -514

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• User starts OMPE Server started task and observes
  within Query Monitor, Platinum Detector, CRD (collect
  report data)- the feature of OMPE Server subtask or
  other tools monitoring SQL activity or generating its
  reports that negative SQLCODE514 occurs. The error
  code indicates that a still not prepared cursor is
  tried to be closed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   PE Server subtask                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Negative sqlcode -514 occurrence during *
  *                      OMPE Server subtask running             *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  User starts OMPE Server started task and observes
  within Query Monitor, Platinum Detector, CRD (collect
  report data)- the feature of OMPE Server subtask or
  other tools monitoring SQL activity or generating its
  reports that negative sqlcode -514 occurs. The error
  code indicates that a still not prepared cursor is
  tried to be closed.
  
  PROBLEM CONCLUSION:
  The solution given refuses of cursor use for a certain
  SELECT SQL statement.
  

Problem conclusion

• The solution given refuses of cursor use for a certain
  SELECT SQL statement.
  
  KEYWORDS :  SQLCODE -514
  

Temporary fix

Comments

• ž**** PE09/01/15 PTF IN ERROR. SEE APAR PK78632  FOR DESCRIPTION
  

APAR Information

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

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

  UK42686 PK78640

Modules/Macros

• DGOVMSTR FPE@WRP2 FPEVWRP2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK42686

     UP08/12/23 P F812

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.