PM74730: INTEGRATE WITH OQWT USING STAGING TABLES (LI028736)

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Attached is the IBM specification for using staging tables to
  transfer workload data to OQWT. This is in support of LI028736.
  .
  h2. Stages
  h3. DDL for Staging tables
  Write SQL to create the tables (DDL) using the table definitions
  in the attached document.
  h3. Populate Staging Tables
  h5. Provide a copy of some data to IBM
  We'll find out from IBM what format they'll need.
  h3. Install new OQWT
  Install the pre-release of the new version of OQWT (will be
  provided by Jason Sizto)
  h3. Integrate
  Start implementing the integration protocol
  h3. Enhance the "Tune All" UI
  Allow users to specify workload name and the connection to the
  "staging" DB2
  h3. Implement an Admin UI
  While we will ask OQWT to clean up the staging tables, sometimes
  a "workload" can be left in the staging tables. Users will need
  to manage (and clean up) workloads from the staging tables.
  h2. Tag for this work
  Please make a new sandbox (or project, whatever you do in your
  development environment) using the branch tag:
  QM31R0_3034_3139_03JUL12_OQWT2_BBRANCH
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Query Monitor.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Attached is the IBM specification for   *
  *                      using staging tables to transfer        *
  *                      workload data to OQWT. This is in       *
  *                      support of LI028736.                    *
  *                      h2. Stages                              *
  *                      h3. DDL for Staging tables              *
  *                      Write SQL to create the tables (DDL)    *
  *                      using the table definitions in the      *
  *                      attached document.                      *
  *                      h3. Populate Staging Tables             *
  *                      h5. Provide a copy of some data to IBM  *
  *                      We'll find out from IBM what format     *
  *                      they'll need.                           *
  *                      h3. Install new OQWT                    *
  *                      Install the pre-release of the new      *
  *                      version of OQWT (will be provided by    *
  *                      Jason Sizto)                            *
  *                      h3. Integrate                           *
  *                      Start implementing the integration      *
  *                      protocol                                *
  *                      h3. Enhance the "Tune All" UI           *
  *                      Allow users to specify workload name    *
  *                      and the connection to the "staging"     *
  *                      DB2                                     *
  *                      h3. Implement an Admin UI               *
  *                      While we will ask OQWT to clean up the  *
  *                      staging tables, sometimes a "workload"  *
  *                      can be left in the staging tables.      *
  *                      Users will need to manage (and clean    *
  *                      up) workloads from the staging tables.  *
  *                      h2. Tag for this work                   *
  *                      Please make a new sandbox (or project,  *
  *                      whatever you do in your development     *
  *                      environment) using the branch tag:      *
  *                      QM31R0_3034_3139_03JUL12_OQWT2_BBRANCH  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

  UK91729

Modules/Macros

•    CQM$CHLP CQM$LINK CQM$MAIN CQM$SMKY CQM$SM01
  CQM$SM02 CQM$VSTR CQM#BCMX CQM#CQMA CQM#CQ31 CQM#CQ32 CQM#FEXP
  CQM#FMTR CQM#INIX CQM#INTX CQM#IVCV CQM#IVSM CQM#MAIN CQM#PARM
  CQM#PCIQ CQM#PCIX CQM#QAPI CQM#QAPX CQM#QSQL CQM#SDAQ CQM#SDIR
  CQM#SSMN CQM#SWTX CQM#UINX CQM@ITXT CQM@WDB2 CQMBLOB  CQMCAE
  CQMCAEPT CQMCAPI  CQMCPXPT CQMCSDDL CQMC0186 CQMC0187 CQMHSUMJ
  CQMHSUMP CQMJAR   CQMMCALX CQMMCMOX CQMMEACX CQMMEAPX CQMMEARX
  CQMMEASX CQMMEMTX CQMMESQX CQMME8CX CQMME8PX CQMME8RX CQMME8SX
  CQMME9CX CQMME9PX CQMME9RX CQMME9SX CQMMMETX CQMMQAPX CQMOREDX
  CQMPARSE CQMTTXTX
  

Fix information

• Fixed component name

  DB2 QUERY MONIT

• Fixed component ID

  5655E6701

Applicable component levels

• R310 PSY UK91729

     UP13/02/26 P F302

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.