Managing file and table sizes

From m204wiki
Revision as of 23:34, 17 March 2013 by Rob (talk | contribs) (Created page with " == Overview of Capabilities == Because of the hashed nature of Tables A and C, these tables can only be changed with the CREATE command during a [[File Reorganization ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Overview of Capabilities

Because of the hashed nature of Tables A and C, these tables can only be changed with the CREATE command during a file reorganisation.

The other tables may be modified using the INCREASE and DECREASE command, as follows:

Command Description Exclusive Access? Limitations
INCREASE dataset Add an additional dataset to a Model 204 file. No A model 204 file may have up to 255 datasets

The additional pages are formatted as free space

INCREASE TABLEB Move pages from free space to Table B No, but the DYNAMIC sub-parameter
is required if you don't have exclusive
access
segment boundaries need to be taken into account
the MAXINCBP parameter needs to be set if you wish to increase
Table B beyond the current segment boundary.
INCREASE TABLEE or
TABLEX
Move pages from free space to this table No Up to maximum table size