PI92156: PROVIDE VIEW DEFINITION FOR OPM PERFDB SCHEMA TO EXTRACT SQL STATEMENT LEVEL INFORMATION

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• APARONPUB
  The SQL Statements Dashboard that is part of the OMEGAMON Db2
  Performance Expert product and visualizes static and dynamic SQL
  statement data.
  The SQL statement data shown is stored in the Optim Performance
  Manager (OPM) Repository Database (a.k.a. PERFDB); the PERFDB
  resides on a Db2 LUW instance.
  The subject new function APAR will provide a VIEW definition
  (DDL) that will project on the respective PERFDB schema tables,
  that is it will extract SQL statement text and SQL statement
  metrics data.
  The data SELECTed from the new VIEW definition has be
  transferred to a Db2 for z/OS Db2 subsystem (for example using
  the Cross Loader functionality) in order to being used in the
  Data Server Manager embedded Query Workload Tuner functionality
  as a "User Defined Repository" (UDR) source.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM                *
  *                 users of component                           *
  *                 - OPM (SQL Dashboard)                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The SQL Statements Dashboard is part of *
  *                      the OMEGAMON Db2 Performance Expert     *
  *                      product that visualizes static and      *
  *                      dynamic SQL statement data. This SQL    *
  *                      statement data one sees on the display  *
  *                      is stored in the Optim Performance      *
  *                      Manager (OPM) Repository Database       *
  *                      (a.k.a. PERFDB) that resides on a Db2   *
  *                      LUW instance. The subject new function  *
  *                      APAR will provide a VIEW definition     *
  *                      (DDL) - based on the PERFDB schema      *
  *                      tables - that extracts SQL statement    *
  *                      text and SQL statement metrics data to  *
  *                      enable integration with the Data Server *
  *                      Manager-based Query Workload Tuner      *
  *                      functionality.                          *
  *                      The data SELECTed from this new VIEW    *
  *                      definition could then be transferred to *
  *                      a Db2 for z/OS Db2 subsystem (for       *
  *                      example using the Cross-Loader          *
  *                      functionality) in order to being used   *
  *                      in the Data Server Manager embedded     *
  *                      Query Workload Tuner functionality      *
  *                      (i.e. as the "User Defined Repository"  *
  *                      source).                                *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The subject new function APAR will provide a VIEW definition
  (DDL) for the OPM PERFDB that extracts SQL statement text and
  SQL statement metrics data to enable the integration with the
  Data Server Manager-based Query Workload Tuner functionality.
  

Problem conclusion

Temporary fix

Comments

• Apply the PTF to enable the new functionality and follow the
  necessary steps in the setup section of the provided sample
  member.
  
  Search Keywords:
  OPM, UDR, DSM, SQLDASHBOARD, PERFDB, VIEW
  

APAR Information

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

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

  UI53758

Modules/Macros

•    DGOCVOPM
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI53758

     UP18/02/12 P F802

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.