DB2 Contention Analyzer
Critical Path Software has completed the development of DB2 Contention Analyzer, a new tool developed over the past 5 years, which uses TURBO our expert performance tuning database combined with your DB2, CICS and User Catalog statistics to identify and fix spikes and Slow Response times in performance occurring in DB2/CICS regions.
No other software has this ability.
A full-blown analysis by DB2 Contention Analyzer will accomplish the following:
●
Identify contention from outside interferences
● Improve Online Response Time
● Reduce system overhead from DB2, CICS, User Catalogs, Bootstrap files.
● Reduce DB2 region overhead
● Reduce CICS region overhead
● Reduce DB2 TCB/CPU
● Reduce CICS TCB/CPU
● Reduce DB2 SRB/CPU
● Reduce CICS SRB/CPU
● Increase Transactions/Second
● Reduce or eliminate Runaway Transactions
● Reduce DB2 System File I/O
● Reduce CICS System File I/O
●
Eliminate On-Line Spiking
●
Improve Look-aside hit ratios
●
Improve the balance of LSR Buffer Pools
●
Allow running of more SQL's (DB2) per second (Queries)
To accomplish this we will need:
●
Listcats of the User Catalog(s) which contain the CICS system and work files
●
CICS shut down statistics for the Region being analyzed
●
CICS compile deck used for the CICS Region GEN
●
Listcats for all the files used in the CICS Region
●
Listcats of the User application catalogs
●
Also, all files that access the CICS region that we are analyzing
This is the result of an actual analysis of a CPSI client's DB2/CICS region.
Will Reduce On-Line Spiking
Will Reduce or eliminate Runaway Transactions
Will Reduce MIPS used by this CICS region
Will Improve On-Line Response Time
Will Increase the Number of Transactions/Second
Will Reduce Total CICS I/O
Will Improve Look-aside hit ratios
Will Increase the Number of SQL's (DB2) per second (Queries)
Will Reduce CPU Contention from outside interferences
Will Reduce I/O Contention from outside interferences Will Reduce
Will Reduce system overhead
Will Reduce CICS region overhead
Will Reduce CICS Application TCB/CPU:
1. From Reduced Transaction CPU
2. From Reduced PPT Table CPU
3. From Reduced FCT Table CPU
4. From Reduced TCT Table CPU
5. From improved File definitions
6. From Reduced File I/O
TOTAL
Will Reduce CICS System Overhead SRB/CPU:
1. From System file contention
2. From System file improvement
3. From reduced lost I/O waits
4. From improved Look-A-Side hits
5. From improved File definitions
6. From Reduced File I/O
7. From Improved balance of LSR Buffer Pools
TOTAL
3%
3%
3%
2%
2%
3%
3%
1%
2%
3%
2%
4%
4%
89%
73%
14%
12%
16%
19%
6%
21%
5%
11%
9%
24%
17%
20%