Welcome
CICS® IA space considerations
Db2® space allocation
Calculate the Db2® space allocations using these assumptions and guidance.
Db2® tables and index: CIUDB2
Calculation of the space required for the Db2® tablespace and Db2 index for Db2 data.

Preface
This information describes the IBM® CICS® Interdependency Analyzer for z/OS®. It explains what the program does and how to set up and run its various components.
What's new in CICS® IA Version 6.3
CICS® IA Version 6.3 maintains broad functionality and provides full support for the new CICS Transaction Server 6.3. Building on previous releases, it includes updates for commands whose threadsafe status has been enhanced in CICS Transaction Server 6.3, enabling more applications to run without switching to QR TCB mode
Overview of the CICS® Interdependency Analyzer
This section gives an overview of the CICS® Interdependency Analyzer (CICS IA), and describes its components.
Getting Started with the CICS® IA plug-in for CICS Explorer®
The CICS® Interdependency Analyzer plug-in for CICS Explorer® provides an Eclipse-based interface to analyze your CICS IA data. It also provides cheat sheets that guide you through the steps required to configure and install CICS IA. It is recommended that you download the CICS IA plug-in and follow the steps in the cheat sheets.
Configuring CICS® IA
This section describes what you need to do before you can use CICS® IA.
Running the Collector
You run the CICS® IA Collector to look for instances of program commands that might cause resource dependencies or transaction affinities.
Updating the Dependency and Affinity database objects
The Dependency database objects contain accumulated data about your applications and the resources that they use. Update the database objects regularly to add new information recorded by the Collector in the VSAM dependency files.
Managing your CICS® IA data
With each new release CICS® IA captures more data. In volatile development environments this data can soon become out of date. If you have out of date data, the CICS IA plug-in might retrieve more data than you need. The presence of unwanted data might impede your analysis and provide confusing results.
The CICS® IA UDB database
CICS® IA provides jobs to unload CICS IA data into CSV files. These files can be used to populate the IBM® supported UDB databases.
Running the Reporter
Running the Program Threadsafe report
The threadsafe report can be run from the CICS IA Explorer plug-in or as a batch job using the sample CIUJTSQ2 that can be found in SCIUSAMP.CICS. The report runs the Db2® stored procedure CIUSPTSR.
Running the Load Module Scanner
The Load Module Scanner scans load modules for instances of program commands that could cause resource dependencies or transaction affinities.
Running the CSECT Scanner
The CICS® IA CSECT Scanner scans load modules for information that can be used to identify the version of each CSECT.
Running the Builder
The CICS® IA Builder runs as a batch job to build affinity-transaction-group definitions suitable for input to the CICS system management product, CICSPlex SM.
Running the sample Db2® query
This section describes how to run the sample CICS® IA batch query job CIUJSAMP.
Solving problems
This section helps you to isolate and determine the cause of CICS® IA problems.
Details of dependencies and affinities collected
Correlating Load Module Scanner and Dependency Reporter output to source
The structure of the CICS® IA database
Messages and codes
This section describes the messages that the Collector, Query interface, Dependency Reporter, Affinities Reporter, Load Module Scanner, CSECT Scanner, and Builder can issue, and the transaction abend codes that the Collector can produce.
CICS® IA space considerations
- Required data
  To calculate the space allocation requirements, estimate some values for the environment in which you want to run CICS® IA.
- Data space allocation
  The data space consists of a number of tables, both permanent and temporary. The number and size of the tables varies depending on whether you are collecting Interdependency data or Affinities data.
- VSAM data set allocation
  There are ten VSAM files associated with CICS® IA.
- Db2® space allocation
  Calculate the Db2® space allocations using these assumptions and guidance.
  - CICS® tables and index: CIUCICS1 and CIUCICSX
    How to calculate the space required for the Db2® tablespace and Db2 index for CICS® data.
  - Db2® tables and index: CIUDB2
    Calculation of the space required for the Db2® tablespace and Db2 index for Db2 data.
  - MQ tables and index: CIUMQ1
    Calculation of the space required for the Db2® tablespace and Db2 index for IBM MQ data.
  - IMS® tables and index: CIUIMS
    Calculation of the space required for the Db2® tablespace and Db2 index for IMS® data.
  - Natural tables and an index: CIUNAT
    Calculate the space required for the Db2® tablespace and Db2 index for Natural data.
  - Exit resource tables and index: CIUREXIT
    Calculation of the space required for the Db2® tablespace and Db2 index for the exit resource data.
  - File resource tables and index: CIURFILE
    Calculation of the space required for the Db2® tablespace and Db2 index for the file resource data.
  - Program resource tables and index: CIURPROG
    Calculation of the space required for the Db2® tablespace and Db2 index for the program resource data.
  - Transaction resource tables and index: CIURTRAN
    Calculation of the space required for the Db2® tablespace and Db2 index for the transaction ID resource data.
  - Transient data queue resource tables and index: CIURTDQ
    Calculation of the space required for the Db2® tablespace and Db2 index for the transient data queue resource data.
  - Temporary storage queue resource tables and index: CIURTSQ
    Calculation of the space required for the Db2® tablespace and Db2 index for the temporary storage queue resource data.
  - Web services resource tables and index: CIURWEB
    Calculation of the space required for the Db2® tablespace and Db2 index for the Web services resource data.
  - Affinity tables and indexes
    How to calculate the space required for the Db2® tablespace and Db2 indexes for Affinity data.
  - Load Module Scanner tables
    The default values set by CICS® IA are larger than required. To calculate the space to allocate for the Db2® tablespace and the Db2 indexes required for the Load Module Scanner, estimate the total number of rows.
  - CSECT Module Scanner tables
    The default values set by CICS® IA are larger than required. To calculate the space to allocate for the Db2® table space and the Db2 indexes required for the CSECT Module Scanner, estimate the total number of rows.
  - CICS® region tables
    The default values set by CICS® IA are larger than required. To calculate the space to allocate for the Db2® tablespace and the Db2 indexes required for CICS region information, estimate the total number of rows.
  - CICS® IA plug-in for CICS Explorer® Resource table: CIURESTB/X
    Calculation of the space required for the Db2® table space and the Db2 indexes required for the CICS® region information.
CICS® IA security
CICS® IA External Interfaces
The Appendix describes available Stored Procedures and Command Flow user exit.
Collecting dynamic COBOL calls
CICS® IA detects dynamic COBOL calls, which are collected by the Dependency and Command Flow Data collectors.
Accessibility
Accessibility features help a user who has a physical disability, such as restricted mobility or limited vision, to use software products successfully
Download PDF
Download the PDF format documentation for CICS Interdependency Analyzer for z/OS 6.3

Db2® tables and index: CIUDB2

Calculation of the space required for the Db2® tablespace and Db2® index for Db2® data.

To calculate the space, in KB, to allocate for the Db2® tablespace and the Db2® index required for Db2® data, you need to estimate the total number of rows.

This number is calculated from the following values; see Values required for each CICS® region.

NUM_DB2_PROG
AVG_Db2
PROG_TRAN_RATIO
NUM_REGION_D

Calculate the number of rows for the Db2® table as follows:

NUM_ROWS = (NUM_DB2_PROG * AVG_Db2 * 
            PROG_TRAN_RATIO * NUM_REGION_D)

Use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Worksheet for Db2 tablespace to calculate the PRIQTY and SECQTY as described in Db2 space allocation for the Db2® tablespace.

Table 1. Worksheet for Db2® tablespace
Tablespace	Row_Size	Percent_Free
CIUDB2D	189	15
Indexes
XIDB2D1	133	20