One table is used to store DB2® data.
About this task
Collect DB2 data
as follows:
- Estimate the number of application programs that are used in the CICS® region that use DB2. Call this number NUM_DB2_PROG.
- Estimate the average number of EXEC SQL calls per program. Call
this number AVG_DB2.
- Estimate the number of transaction and program associations. In
this example the estimate is that each can be associated with five
transactions.
- Calculate DB2 data space
as follows:
(120 * NUM_DB2_PROG * AVG_DB2 * PROG_TRAN_RATIO) = DB2_DS bytes