A fix is available
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 number
PM74730
Reported component name
DB2 QUERY MONIT
Reported component ID
5655E6701
Reported release
310
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-10-10
Closed date
2013-02-15
Last modified date
2013-03-04
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0"}]
Document Information
Modified date:
18 March 2021