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
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