A fix is available
APAR status
Closed as program error.
Error description
Various OMPE Accounting and Statistics tables issues
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component: * * - Batch Reporting * * - Performance Database users * **************************************************************** * PROBLEM DESCRIPTION: Some incorrect values have been * * detected in accounting and statistics * * Performance Database tables. * * 1.DB2PMFACCT_GBUFFER: * * a.columns WRITE_AND_REGISTER and * * WRITE_REGISTR_MULT are loaded from * * an incorrect position * * * * 2.DB2PMFACCT_GENERAL: * * a.columns RQ_CLIENT_PLAT, * * RQ_CLIENT_APPL, RQ_CLIENT_AUTHID, * * RQ_STRING are loaded with an * * incorrect DEFAULTIF clause * * b.column CLASS3_GLOBAL_CONT may * * contain incorrect values * * c.column CL2_SU_CPU_STPROC may * * contain incorrect values * * * * 3.DB2PMSACCT_GENERAL: * * a.column CLASS3_GLOBAL_CONT may * * contain incorrect values * * b.column PAR_ONEDB2_DCLTT may * * contain incorrect values * * c.column CL2_SU_CPU_STPROC may * * contain incorrect values * * * * 4.DB2PMFACCT_PROGRAM: * * a.column CLASS8_GLOBAL_CONT may * * contain incorrect values * * * * 5.DB2PMSACCT_PROGRAM: * * a.column CLASS8_GLOBAL_CONT may * * contain incorrect values * * * * 6.DB2PM_STAT_GENERAL * * a. column XPROC_REQUESTS may * * contain incorrect values * * * * An incorrect parameter HDRPDBCOL is * * used in the samples FPEP* in library * * TKANSAM for the Spreadsheet Input * * Data Generator. * * * **************************************************************** * RECOMMENDATION: Apply this PTF to fix incorrect values * * in the Performance Database and incorrect * * samples for the Spreadsheet Input Data * * Generator. * * * **************************************************************** PROBLEM SUMMARY: Performance Database: 1.a. Correct load positions. 2.a. Remove DEFAULTIF clauses. b. Correct FILE processing. c. Correct FILE processing. 3.a. Correct SAVE-FILE convert processing. b. Correct accounting REDUCE processing. c. Correct accounting REDUCE processing. 4.a. Correct FILE processing. 5.a. Correct SAVE-FILE processing. 6.a. Interpret related DB2 field QISEKSPG as snapshot value and not as DB2-accumulated value. Spreadsheet Input Data Generator: Replace parameter HDRPDBCOL by HDRPDCOL in samples. PROBLEM CONCLUSION: Performance Database: 1.a. Correct load positions. 2.a. Remove DEFAULTIF clauses. b. Correct FILE processing. c. Correct FILE processing. 3.a. Correct SAVE-FILE convert processing. b. Correct accounting REDUCE processing. c. Correct accounting REDUCE processing. 4.a. Correct FILE processing. 5.a. Correct SAVE-FILE processing. 6.a. Interpret related DB2 field QISEKSPG as snapshot value and not as DB2-accumulated value. Spreadsheet Input Data Generator: Replace parameter HDRPDBCOL by HDRPDCOL in samples.
Problem conclusion
Performance Database: 1.a. Correct load positions. 2.a. Remove DEFAULTIF clauses. b. Correct FILE processing. c. Correct FILE processing. 3.a. Correct SAVE-FILE convert processing. b. Correct accounting REDUCE processing. c. Correct accounting REDUCE processing. 4.a. Correct FILE processing. 5.a. Correct SAVE-FILE processing. 6.a. Interpret related DB2 field QISEKSPG as snapshot value and not as DB2-accumulated value. Spreadsheet Input Data Generator: Replace parameter HDRPDBCOL by HDRPDCOL in samples. KEYWORDS : PERFORMANCE DATABASE ACCOUNTING STATISTICS SPREADSHEET WRITE_AND_REGISTER WRITE_REGISTR_MULT RQ_CLIENT_PLAT RQ_CLIENT_APPL RQ_CLIENT_AUTHID RQ_STRING CLASS3_GLOBAL_CONT CL2_SU_CPU_STPROC PAR_ONEDB2_DCLTT CL2_SU_CPU_STPROC CLASS8_GLOBAL_CONT XPROC_REQUESTS HDRPDCOL
Temporary fix
Comments
APAR Information
APAR number
PM73071
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-09-17
Closed date
2013-01-24
Last modified date
2017-06-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK91158 UK91159
Modules/Macros
DGOADFGP DGOADIST DGOAFGEN DGOAFORM DGOAFPCK DGOALFGE DGOALFGP DGOAREDG DGOAREDX DGOFSISE DGOPACNV DGORAEXT DGOSACUM DGOSAPTS FPEPCSVA FPEPCSVB FPEPCSVJ FPEPCSVP FPEPCSVS
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
21 June 2017