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

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

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

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.

Any user of CICS Performance Analyzer

Author: Debbie Butts, CICS Development, Hursley
Category: 2
Released: 22Dec05
Updated: 18Mar10
Current Version: 2.1


This SupportPac requires:

  • CICS Performance Analyzer for z/OS V3.1, or
    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.

cp12.pdf US English 1979000

Download package

Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options 07/03/2008 US English 1675000 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: 2.1, 3.1

Operating system(s): z/OS

Reference #: 4011321

Modified date: 19 March 2010

Translate this page: