CP12: CICS PA - Charting historical CICS performance data
Downloadable files
Abstract
This SupportPac™ explains how to transfer data from CICS® Performance Analyzer for z/OS® into a DB2® table or comma separated value (CSV) file to create various charts and reports.
Download Description
This SupportPac describes how to use CICS Performance Analyzer for z/OS (CICS PA) to transfer CICS statistics or performance data to DB2 tables or comma-separated value (CSV) files. Example scenarios are provided for creating charts and reports from those DB2 tables or CSV files, including working code and sample files.
The example scenarios provided by this SupportPac serve two purposes. First, they create charts or reports that help answer common CICS performance-related questions. Second, they demonstrate different tools and techniques.
Scenario 1. Are we meeting service-level agreements (SLA)? Creates bar charts of CICS transaction response times compared to an SLA value.
This scenario uses a Microsoft® Office Excel 2003 for Windows® (Excel) macro to query z/OS-based DB2 tables and then create a set of bar charts.
Scenario 2. Why is a transaction slow? Creates bar charts of a variety of CICS performance data for selected CICS transactions.
This scenario uses an Excel macro to create bar charts from a CSV file.
Scenario 3. Tuning local shared resource (LSR) buffer pools. Creates a tabular report of LSR buffer pool statistics.
This scenario uses DB2 Query Management Facility (QMF™) for z/OS to query DB2 tables and then format the results.
NEW IN THIS RELEASE
This SupportPac includes three new Excel add-ins for working with statistics or performance data provided by CICS PA:
NewScenario 4. Compare Before-After Excel add-in. Compares two CICS PA performance data summary extracts, using colors to indicate differences in corresponding cells: increases in shades of red, decreases in shades of green.
This scenario uses an Excel add-in to create a workbook from two CSV files.
NewScenario 5. TCB Mode Analysis Excel add-in. Creates bar charts of average response times, CPU times, and TCB mode switches for each transaction ID in a performance data summary extract. You can set warning thresholds to highlight transaction IDs with long response times or high numbers of TCB mode switches. You can also create an interactive timeline chart of a performance data list extract of detailed threadsafe-related CICS performance data (or any CICS performance field).
*Requires a CICS PA performance data summary extract that has been generated using the CICS PA supplied sample summary report form CPU3SEXT.
This scenario uses Excel add-ins to create charts from CSV files.
NewScenario 6. Timeline Chart Excel add-in. Creates an interactive timeline chart of a CICS PA performance or statistics data extract. If your z/OS system allows job submission using FTP, you can use this add-in to submit a CICS PA job on z/OS, transfer the resulting CSV file to your PC, and create a chart, all with the click of a single button in Excel.
This scenario uses Excel add-ins to create charts from CSV files.
Installing these add-ins creates a new "CICS Performance Analyzer" item under the Excel Tools menu, with sub-items for each add-in.
The cross-reference tables in the appendix "DB2 names for CICS statistics" have been updated for CICS Transaction Server for z/OS (CICS TS) V3.2 and CICS Transaction Gateway (CICS TG) V7.1.
SKILL LEVEL REQUIRED
Any user of CICS Performance Analyzer
CICS Performance Analyzer for z/OS V2.1 with service applied, up to and including PTF for APAR PK60975
Microsoft Windows XP Professional SP2
Microsoft Excel 2003
DB2 QMF for z/OS V7.1
DB2 Universal Database for z/OS V7.1
Installation Instructions
The sample files and PDF are contained in one .zip file. In addition the PDF is provided separately. For instructions on using the sample files, open cp12.pdf in Adobe Acrobat reader.
Category 2 SupportPacs are provided in good faith and AS-IS. There is no warranty or further service implied or committed and any supplied sample code is not supported by IBM product service channels.
Please read the license file that accompanies the SupportPac, to determine if you want to use it.
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.
Rate this page
Please take a moment to complete this form to help us better serve you.
