How Db2 determines the initial value of DSMAX
Db2 uses a formula to calculate the initial value for the DSMAX subsystem parameter.
Db2 calculates the initial value of the DSMAX subsystem parameter according to the following formula:
databases × ((tables ×indexes) + table-spaces)- databases
- The number of concurrent databases specified in the DATABASES field on installation panel DSNTIPE.
- tables
- The number of tables per database specified in the TABLES field on installation panel DSNTIPD.
- indexes
- The number of indexes per table. The installation CLIST sets this variable to 2.
- table-spaces
- The number of table spaces per database specified in the TABLE SPACES field on installation panel DSNTIPD.
The calculated value is shown on CLIST calculations panel 1: DSNTIPC