Natural tables and an index: CIUNAT

Calculate the space required for the DB2® tablespace and DB2 index for Natural data.

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

This number is calculated from the following values:
  • NUM_NATURAL_PROG
  • AVG_NATURAL
  • PROG_TRAN_RATIO
  • NUM_REGION_D
See Values required for each CICS® region.
Calculate the number of rows for the Natural table as follows:
NUM_ROWS = (NUM_NATURAL_PROG * AVG_NATURAL * 
            PROG_TRAN_RATIO * NUM_REGION_D)

Use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Table 1 to calculate the PRIQTY and SECQTY as described in Figure 1 for the DB2 tablespace.

Table 1. Worksheet for Natural tablespace
Tablespace Row_Size Percent_Free PRIQTY SECQTY
CIUNATD 267 15    
Index        
XNATDUNI 124 20    

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 7 February 2014


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