PM37037: DYNAMIC SQL STATEMENT TEXT IS NOT POPULATED IN DCS APPLICATION SNAPSHOT AND COUNTERS ARE NOT POPULATED IN CLASSIC PANEL ZDBCP.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• To measure connectivity performance between the db2 connect
  gateway, where the Performance Expert Agent runs, and the host
  database, Performance Expert Agent issues a dummy select
  statement against the host database and right away gets a DCS
  application snapshot to get the needed performance counters.
  .
  The needed select statement is being identified by its dynamic
  SQL statement text, which is not available in some cases in the
  snapshot output, therefore the statements can not be identified
  and the counters can not be collected.
  .
  

Local fix

• As an instance owner, stop the local db2 instance, where the
  accounting string.
  .
  Performance Expert Agent runs, using db2stop command and start
  it back using db2start.
  .
  Apply the apar fix for the final solution, which uses the
  accounting string.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Performance Expert Agent for             *
  *                     DB2 Connect Monitoring                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Dynamic SQL statement text is not       *
  *                      populated in DCS application snapshot   *
  *                      and counters are not populated.         *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  - The APAR/PTF points the user to the updated Agent code on
    the web, which fixes the issue.
  - A so called "accounting string" is being set to identify the
    needed local DCS application (and it's needed statement) in
    the DCS application snapshot, instead of using dynamic SQL
    statement text.
  - Keywords in the Agent's log:
    - No data blocks found
    - CollectedGroup.findDataBlockByStringCounter
    - 'DYNASTMTTEXT'
  
  PROBLEM CONCLUSION:
  - The APAR/PTF points the user to the updated Agent code on
    the web, which fixes the issue.
  - This PTF corresponds to the code level E9007 of the
    Performance Expert Agent for DB2 Connect Monitoring.
  

Problem conclusion

• - The APAR/PTF points the user to the updated Agent code on
    the web, which fixes the issue.
  - This PTF corresponds to the code level E9007 of the
    Performance Expert Agent for DB2 Connect Monitoring.
  
  KEYWORDS : NO DATA BLOCKS FOUND
             COLLECTEDGROUP.FINDDATABLOCKBYSTRINGCOUNTER
             'DYNASTMTTEXT' DYNASTMTTEXT
  

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:

  UK67178

Modules/Macros

• DGOK$INF
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK67178

     UP11/04/29 P F104

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.