Example of primary and secondary space allocation

Primary and secondary space allocation quantities are affected by a CREATE statement and two subsequent ALTER statements.

This example assumes a maximum data set size of less than 32 GB, and the following parameter values on installation panel DSNTIP7:

  • TABLE SPACE ALLOCATION = 0
  • INDEX SPACE ALLOCATION = 0
  • OPTIMIZE EXTENT SIZING = YES
Table 1. Example of specified and actual space allocations
Action Specified PRIQTY Actual primary quantity allocated Specified SECQTY Actual secondary quantity allocated
CREATE TABLESPACE 100 KB 100 KB 1000 KB 2 cylinders
ALTER TABLESPACE -1 1 cylinder 2000 KB 3 cylinders
ALTER TABLESPACE   1 cylinder -1 1 cylinder