A fix is available
APAR status
Closed as unreproducible in next release.
Error description
Exploit DB2 10 APAR PM90886 and OMPE V511 APAR PM94202 in OMPE Performance Database and Spreadsheets.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM * * users of component * * - Batch Reporting * * - PDB - Performance Database * * - PE Server subtask * **************************************************************** * PROBLEM DESCRIPTION: 1. Batch reports, Performance * * Database, Spreadsheet Input Data * * Generator and PE Server subtask do not * * support ACCELERATOR ELIGIBLE TIME * * fields introduced with * * DB2 10 APAR PM90886 / PTF UK97693 and * * DB2 11 APAR PM96478 / PTF UI13488. * * * * 2. Performance Database and * * Spreadsheet Input Data Generator do * * not support enhancements of DB2 * * Instrumentation Facility related to * * IBM DB2 Analytics Accelerator V4 * * introduced with * * DB2 10 APAR PM96767 / PTF UI12630 and * * DB2 11 APAR PM95832 / PTF UI13394. * * * * 3. Accounting client information * * fields provided by distributed * * applications may contain data that * * corrupts the CSV format (e.g. CSV * * delimiter, non-EBCDIC character). * * The character strings processed by * * the Spreadsheet Input Data Generator * * and written to the CSV data set * * should be enclosed with * * double quotes. * * * * 4. FILTERING for PACKAGE does not * * work correctly for Batch ACCOUNTING * * TRACE and FILE when using INCLUDE or * * EXCLUDE (PACKAGE(*)). * * * * 5. The ACCELERATOR data blocks in * * Batch Accounting and Statistics * * reports have unfavorable positions in * * the default LONG layouts. * * * * 6a. Formatting problems exist for * * fields QBGL2S, QBGLWA, QBSTHST, QBSTRHS * * in the statistics reports. * * * * 6b. Formatting problems exist for * * fields Q8STCCPU, Q8STWCPU, Q8STDSKU * * in the statistics accelerator table * * and spreadsheet. * **************************************************************** * RECOMMENDATION: Apply this PTF * **************************************************************** PROBLEM SUMMARY: 1. Support ACCELERATOR ELIGIBLE TIME fields in Batch Reports, Performance Database, Spreadsheet Input Data Generator and PE Server subtask. 2. Support instrumentation enhancements of IBM DB2 Analytics Accelerator V4 in Performance Database and Spreadsheet Input Data Generator. 3. Enclose character strings written by the Spreadsheet Input Data Generator with double quotes and replace double quotes within a string by two double quotes. 4. FILTERING for PACKAGE does not work correctly for Batch ACCOUNTING TRACE and FILE and is reworked. 5. The ACCELERATOR data blocks in Batch Accounting and Statistics reports have unfavorable positions in the layouts and are rearranged. 6a. Format the fields QBGL2S, QBGLWA, QBSTHST, QBSTRHS correctly in the per second column in statistics reports. 6b. Format the fiels Q8STCCPU, Q8STWCPU, Q8STDSKU as % values in the statistics accelerator table and spreadsheet. PROBLEM CONCLUSION: 1. Support ACCELERATOR ELIGIBLE TIME fields in Batch Reports, Performance Database, Spreadsheet Input Data Generator and PE Server subtask. Some Accounting Report layouts changed: - A new data block named MEASURED/ELIG TIMES has been added to the LONG layouts of Accounting TRACE and REPORT. The new block can also be enabled in SHORT layouts via UTR. All fields regarding ELIGIBLE TIMES are shown now in this block. - The sequence of data blocks in the layouts has been rearranged. - Fields of data block QUERY PARALLELISM have been renamed. - The SERVICE UNIT data blocks named TOTAL SU and AVERAGE SU have been changed. They include service units of CPU or Specialty Engine (SE) eligible fields. - The new data block is also included now in the TIME layout. - The service unit data block TOTAL SU is included now in the PTA and STP layouts of Accounting TRACE. 2. Support instrumentation enhancements of IBM DB2 Analytics Accelerator V4 in Performance Database and Spreadsheet Input Data Generator. 3. Enclose character strings written by the Spreadsheet Input Data Generator with double quotes and replace double quotes within a string by two double quotes. 4. Correct the filtering code for PACKAGE when used by Batch Accounting. 5. The ACCELERATOR data block in Batch Accounting TRACE and REPORT and Batch Statistics TRACE and REPORT have been moved in the LONG layouts before the Buffer Pool data blocks. 6a. Format the fields QBGL2S, QBGLWA, QBSTHST, QBSTRHS correctly in the per second column in statistics reports. 6b. Format the fiels Q8STCCPU, Q8STWCPU, Q8STDSKU as % values in the statistics accelerator table and spreadsheet. KEYWORDS: ACCELERATOR ELIGIBLE TIME TIMES MODELING SPREADSHEET MEASURED/ELIGIBLE QUERY PARALLELISM TOTAL AVERAGE SU SERVICE UNIT UNITS TIMES/EVENTS ELAPSED CLASS 1 APPLICATION 2 IN DB2 FILTERING ACCELERATOR DATA BLOCK DSNDQ8ST
Problem conclusion
Temporary fix
Comments
PROBLEM SUMMARY: 1. Support ACCELERATOR ELIGIBLE TIME fields in Batch Reports, Performance Database, Spreadsheet Input Data Generator and PE Server subtask. 2. Support instrumentation enhancements of IBM DB2 Analytics Accelerator V4 in Performance Database and Spreadsheet Input Data Generator. 3. Enclose character strings written by the Spreadsheet Input Data Generator with double quotes and replace double quotes within a string by two double quotes. 4. FILTERING for PACKAGE does not work correctly for Batch ACCOUNTING TRACE and FILE and is reworked. 5. The ACCELERATOR data blocks in Batch Accounting and Statistics reports have unfavorable positions in the layouts and are rearranged. 6a. Format the fields QBGL2S, QBGLWA, QBSTHST, QBSTRHS correctly in the per second column in statistics reports. 6b. Format the fiels Q8STCCPU, Q8STWCPU, Q8STDSKU as % values in the statistics accelerator table and spreadsheet. PROBLEM CONCLUSION: 1. Support ACCELERATOR ELIGIBLE TIME fields in Batch Reports, Performance Database, Spreadsheet Input Data Generator and PE Server subtask. Some Accounting Report layouts changed: - A new data block named MEASURED/ELIG TIMES has been added to the LONG layouts of Accounting TRACE and REPORT. The new block can also be enabled in SHORT layouts via UTR. All fields regarding ELIGIBLE TIMES are shown now in this block. - The sequence of data blocks in the layouts has been rearranged. - Fields of data block QUERY PARALLELISM have been renamed. - The SERVICE UNIT data blocks named TOTAL SU and AVERAGE SU have been changed. They include service units of CPU or Specialty Engine (SE) eligible fields. - The new data block is also included now in the TIME layout. - The service unit data block TOTAL SU is included now in the PTA and STP layouts of Accounting TRACE. 2. Support instrumentation enhancements of IBM DB2 Analytics Accelerator V4 in Performance Database and Spreadsheet Input Data Generator. 3. Enclose character strings written by the Spreadsheet Input Data Generator with double quotes and replace double quotes within a string by two double quotes. 4. Correct the filtering code for PACKAGE when used by Batch Accounting. 5. The ACCELERATOR data block in Batch Accounting TRACE and REPORT and Batch Statistics TRACE and REPORT have been moved in the LONG layouts before the Buffer Pool data blocks. 6a. Format the fields QBGL2S, QBGLWA, QBSTHST, QBSTRHS correctly in the per second column in statistics reports. 6b. Format the fiels Q8STCCPU, Q8STWCPU, Q8STDSKU as % values in the statistics accelerator table and spreadsheet. KEYWORDS: ACCELERATOR ELIGIBLE TIME TIMES MODELING SPREADSHEET MEASURED/ELIGIBLE QUERY PARALLELISM TOTAL AVERAGE SU SERVICE UNIT UNITS TIMES/EVENTS ELAPSED CLASS 1 APPLICATION 2 IN DB2 FILTERING ACCELERATOR DATA BLOCK DSNDQ8ST
APAR Information
APAR number
PI08288
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
520
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-12-18
Closed date
2014-03-13
Last modified date
2014-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI15982
Modules/Macros
BPOMAXA0 DGOAACUM DGOABFGE DGOABLOG DGOABORD DGOABORE DGOABSGE DGOACALC DGOACALX DGOACFGE DGOACMER DGOACO ***This field was truncated. To obtain the full apar record, please contact your local support center.***
| SH12699100 |
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R520 PSY UI15982
UP14/03/15 P F403
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.2.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.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 April 2014