CICS Interdependency Analyzer
By
Don Fowler, MCE, Inc., Sept 2004
CICS Interdependency Analyzer has been in the CICS toolkit for many years. IBM announced a new release of the product in September 2004. This new release provides significant enhancements to an already excellent tool.
CICS IA is a unique tool that
aids a user in understanding the resource usage and placement in their CICS systems.
Information provided by CICS IA can assist the user to:
A CICS System Programmer or IT Professional in a
Capacity/Performance role might utilize this tool to:
A batch job is provided to
load data captured by the Transaction Affinities utility (part of CICS TS) into the
tools Resource Relationship DB2 tables for analysis. This provides a single point of
control for reporting on, managing and housekeeping of the collected data.
The powerhouse SQL query facility interface is enhanced to assist in analysis of data in the affinities data tables. A set of sample SQL queries is provided to allow resource comparisons on the data in the DB2 tables. These enable basic predictive capabilities, for example:
1. Comparison of applications across regions
2. Comparison of all interdependencies across regions
The Collector function now supports long resource names of up to 200 bytes. The Collector for the DB2 subsystem now identifies the resource name whenever possible.
Task Control Block (TCB) information is gathered by the
Collector. This may be useful for identifying CICS-DB2 programs that are not threadsafe.
An IA tool user can now differentiate between types of
Temporary Storage Queues (TSQs) - Main, auxiliary, and Coupling Facility.
A set of sample SQL queries and jobs is provided to allow housekeeping functions to be performed on the data in the tools DB2 tables. For example:
The Scanner has been enhanced to report on
affinities and interdependencies, and provides an option to load Scanner data into a DB2
table.
You can now load data captured by the
Transaction Affinities utility (part of CICS TS) into CICS IA DB2 tables for analysis.
1. Exist when persistent state data is created in a CICS AOR.
2. Subsequent instances MUST execute in the same AOR.
3. Duration of the affinity is the lifetime of the state data.
Intended for those users planning to use CICS workload management. It can be used to create basic CPSM definitions. Some captured EXEC CICS commands overlap with CICS IA.
The table (Table 1) below provides a description of what IA provides to enhance the basic TAU captured data.
CICS Interdependency Analyzer V1.3 adds value for affinity analysis by providing a single point of access to interdependency and affinity data and a flexible and easy to use interface for managing affinity data. This can aid the user by answering questions like:
show me all Inter Transaction Affinities by
region
show me all ENQ/DEQ type affinities by
application
show me all affinities for program ABCD
show me Transaction System Affinities for
transaction XXXX
show me all affinity groups which have CPSM
groups built.
Software pre-requisites are:
IBM OS/390, V2.10 or IBM z/OS at any level
IBM CICS Transaction Server for OS/390, Version 1.3 or IBM CICS Transaction Server for z/OS, Version 2.2 or Version 2.3
IBM
DB2 Universal Database Server for OS/390, Version 6.1 or later
The latest release of CICS Interdependency Analyzer nicely folds transaction affinity data into an easily queried and easily built relational database.
CICS IA helps the technical professional to understand
their CICS applications (some over 30 years old! With documentation lost or incomplete) in
order to maintain and update these applications with the full knowledge of resource
interdependencies involved.