Calculate the DB2® space allocations using these assumptions and guidance.
To calculate the PRIQTY for tablespaces and indexes, use the calculation in Figure 1:
ROWS_PER_PAGE = 4089/ROW_SIZE
FREE_BYTES = 4089/100 * PERCENT_FREE
FREE_ROWS = FREE_BYTES/ROW_SIZE
NUM_OF_4K_PAGES = NUM_ROWS / (ROWS_PER_PAGE – FREE_ROWS)
PRIQTY = 4 * NUM_OF_4K_PAGES
The calculation in Figure 1 has three variables:
The ROW_SIZE and PERCENT_FREE for each tablespace and the indexes are in the tables provided for each DB2 table. To calculate the number of rows for each tablespace and index, see CICS tables and indexes: CIUCICS1 and CIUCICSX.
However, until you know how many EXEC CICS statements are used by the applications, it is difficult to estimate the number of rows for a DB2 table.
--Show me the number of rows in the CIU_CICS_DATA table
***INPUT STATEMENT:
SELECT COUNT(*) FROM CIU_CICS_DATA READONLY;
+----------------+
1_| 3037 |
+----------------+
For the CIU_CICS_DATA table use the
row count from the load module scanner jobs CIUJCLTS and CIUJCLTD.
Or run the sample SQL member, CIUSPACE, to report on the row count
for all of the CICS IA tables.
Use the reported values to re-create the table space and index if
required.