PK78640: SQLCODE -514 appearance when several PE Server subtasks collect DB2 CONNECT DATA ALSO SQL -204

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 sqlcode -514 occurs. The error
  code indicates that a still not prepared cursor is
  tried to be closed.
  Additional symptom fixed by apar is SQL -204 when
  using CA/DIRECTOR.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   PE Server subtask                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Negative sqlcode -514 occurrence while  *
  *                      more than one PE Server subtasks are    *
  *                      running and collecting DB2 Connect data *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  User starts several OMEGAMON Collector started tasks
  to collect DB2 Connect data for the same DB2 subsystem
  or for members of the same DB2 data sharing group and
  observes within Query Monitor, Platinum Detector, CRD
  (collect report data - the feature of the PE 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
  was tried to be closed.
  
  PROBLEM CONCLUSION:
  Some omitted commit and rollback statements were added to the
  code
  

Problem conclusion

• Some omitted commit and rollback statements were added to the co
  code
  
  The service level of the
  OMEGAMON collector PE Server subtask
  FPEV0000I  DATA SERVER INITIALIZATION
  FPEV0114I  PTF BUILD IS 09.310 for V 4.1
  FPEV0114I  PTF BUILD IS 09.310 for V 4.2
  
  
  KEYWORDS :
  SQLCODE -514
  

Temporary fix

Comments

APAR Information

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

  PK71270

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

Modules/Macros

• B390SPA1 B390SPA2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSN UK51855

     UP09/11/17 P F911

• R420 PSN UK51856

     UP09/11/17 P F911

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.