Calculating Db2® data space
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