IBM Support

CP12: CICS PA - Charting historical CICS performance data

Downloadable files


SupportPac CP12 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

SupportPac CP12 was last updated in June 2017, to provide support for IBM CICS Performance Analyzer for z/OS (CICS PA) V5.4. SupportPac CP12 facilitates the transfer of 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.

This SupportPac can be used to complement the functions provided by the CICS PA plug-in for CICS Explorer.

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 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.

  • Scenario 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.

  • Scenario 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.

  • Scenario 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.

What's New? - June 2017 update
The macros are updated to work with Excel 2010 and 2016, taking account of changes in the Excel object model that have occurred since Excel 2003. Previously, several of the scenarios would not run correctly in Excel 2010 or Excel 2016; now they all run correctly.

Scenario 1 has been changed so that you have the option of taking input from a CSV file or from DB2, instead of solely from DB2. It now also handles long-running transactions with a task termination count of zero whereas previously these could cause a 'divide by zero' macro error.

Scenario 5 has been amended to take account of changes in CICS TS V4.1, CICS TS V4.2, and CICS TS V5.1:
  • The charts now show T8 CPU Time (if there is any T8 CPU Time).
  • If J8 CPU Time or J9 CPU Time fields are present in the CSV extract, there is no error, but those fields are not shown in the charts.

Scenario 6 documentation now states that you must refer to cells in formulas by cell reference, such as B1 rather than by label, such as ‘Current MAXTASK’. This is necessary because the Accept labels in formulas option was removed in Excel 2007.

To take account of changes to the Excel menus, toolbars, and ribbon in recent versions of Excel, you can now run the macros by clicking a button in the CP12 group on the Home tab in Excel.

All files are now provided in the most up-to-date file format: .xls files are now provided as .xlsx or .xlsm files, and .xla files are provided as .xlam files.

Any user of CICS Performance Analyzer.

Author: Debbie Butts/Satish Tanna, CICS Development, IBM Hursley, UK.
Category: 2
Released: 22Dec05
Updated: 22Jun17
Current Version: 3.0


The minimum level of prerequisites for this SupportPac are:

  • IBM CICS Performance Analyzer for z/OS V5.1, or later.
  • Microsoft Windows 10 - for the supplied script (.wsf and .vbs) and batch (.bat) files
  • Microsoft Excel 2010, or later.
    • The supplied Excel macros and add-ins have been tested with Excel 2010 and Excel 2016.
    • Unless indicated otherwise, instructions in this document for performing actions in Excel refer to the Excel 2016 user interface.
  • IBM DB2 QMF for z/OS V11.1 - for the supplied QMF objects.
  • IBM DB2 V11.1 - for the processing features.

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.

cp12.pdf US English 1979000

Download package

Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options 22 Jun 17 US English 1670416 HTTP

Technical support

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.

Other CICS SupportPacs
To view the complete portfolio of CICS SupportPacs, go to the CICS SupportPacs Home Page

Product Alias/Synonym


Document information

More support for: CICS Performance Analyzer for z/OS

Software version: 5.1, 5.2, 5.3, 5.4

Operating system(s): z/OS

Reference #: 4011321

Modified date: 19 March 2010

Translate this page: