Calculating DB2 data space

One table is used to store DB2® data.

About this task

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

Task Task

Feedback


Timestamp icon Last updated: Friday, 7 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic///ciuugc00384.html