PK64014: DGOVDB2C+AA8 ABEND0C4-11 DURING SQL STATEMENTS MONITORING VIA PE CLIENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• From the PE Client, listing Dynamic Statement Cache with filter
  "Rows Examined" results and an ABEND0C4-11 in CSECT
  DGOVDB2C+AA8 (PK47340) on a MVCL instruction x'0E68' with
  R6 bad.
  Launch Workstation client
  
  Logon on to a DB2 subsystem.
  Click Statistics Details ICON.  Statis Details window opens up.
  Click on "SQL Statements" under "Dynamic SQL Statements" folder
  of navigator tree.
  
  Click the filter ICON.  Dynamic Statement Cache filter window
  opens.
  Select "Statements with highest value" filter method to use.
  Select "Rows exam." field and click OK close filter window.
  On Statistics Details window, click the check mark
  "Receive statement cache information".
  .
  A few moments later I receive an error window in the GUI client
  and
  this appears in the PESERVER log.
  
  IEA995I SYMPTOM DUMP OUTPUT  248
  SYSTEM COMPLETION CODE=0C4  REASON CODE=00000004
  TIME=12.38.23  SEQ=58630  CPU=0000  ASID=0118
  PSW AT TIME OF ERROR  078D0000   90AE0A2A  ILC 2  INTC 04
    ACTIVE LOAD MODULE           ADDRESS=10AC4400  OFFSET=0001C62A
    NAME=DGOVDB2I
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   PE Server                                *
  *                 -   ISPF Monitoring dialogs                  *
  *                 -   Performance Expert Client                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Abend S0C4-04 in the section            *
  *                      DGOVDB2I.DGOVDB2C when the user of      *
  *                      Performance Expert or ISPF              *
  *                      Monitoring dialogs monitors             *
  *                      SQL Statements per Statistics           *
  *                      Details option.                         *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Abend S0C4-04 in the section DGOVDB2I.DGOVDB2C when the user of
  Performance Expert or ISPF Monitoring dialogs monitors
  SQL Statements per Statistics Details option.
  
  PROBLEM CONCLUSION:
  The problem was fixed by length of an internal buffer
  correction.
  

Problem conclusion

• The problem was fixed by length of an internal buffer
  correction.
  
  For V310:
  The service level of the
  OMEGAMON server subtask PESERVER
  FPEV0000I  DATA SERVER INITIALIZATION
  FPEV0114I  PTF BUILD IS 08.141
  
  For V410:
  The service level of the
  OMEGAMON server subtask PESERVER
  FPEV0000I  DATA SERVER INITIALIZATION
  FPEV0114I  PTF BUILD IS 08.141
  
  KEYWORDS : DGOVDB2I DGOVDB2C S0C4 0C4 DYNAMIC SQL STATEMENTS
  

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:

  UK36640 UK36641

Modules/Macros

• DGOVDB2C DGOVMSTR
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK36640

     UP08/05/22 P F805

• R410 PSY UK36641

     UP08/05/22 P F805

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.