Managing file and table sizes: Difference between revisions
Jump to navigation
Jump to search
(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 ...") |
No edit summary |
||
| Line 1: | Line 1: | ||
There are two ways maintain table sizes: setting up the [[Auto Increase (File Management)|Auto Increase]] parameters in the file so that free space is added to the tables as needed; or the File Manager may use a number of commands to maintain the table sizes. | |||
The latter is described below. | |||
| Line 25: | Line 28: | ||
| segment boundaries need to be taken into account<br/>the [[MAXINCBP parameter]] needs to be set if you wish to increase<br/> Table B beyond the current segment boundary. | | segment boundaries need to be taken into account<br/>the [[MAXINCBP parameter]] needs to be set if you wish to increase<br/> Table B beyond the current segment boundary. | ||
|- | |- | ||
! scope="row"| INCREASE TABLEE or <br/> | ! scope="row"| INCREASE TABLED<br/>TABLEE or<br/>TABLEX | ||
| Move pages from free space to this table | | Move pages from free space to this table | ||
| No | | No | ||
| Up to maximum table size | | Up to maximum table size | ||
|- | |- | ||
|- | |||
! scope="row"| DECREASE TABLEB<br/>TABLED<br/>TABLEE<br/>TABLEX | |||
| Move pages to free space from the respective table | |||
| Yes | |||
| Only if the _HIGHPG statistic permits it | |||
|} | |} | ||
== Increase Datasets == | |||
== Increase Table B == | |||
== Increase Other Tables == | |||
== Decrease Table == | |||
[[Category:File Architecture and Management]] | |||
[[Category:File Management]] | |||
Revision as of 04:46, 18 March 2013
There are two ways maintain table sizes: setting up the Auto Increase parameters in the file so that free space is added to the tables as needed; or the File Manager may use a number of commands to maintain the table sizes.
The latter is described below.
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
accesssegment 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 TABLED
TABLEE or
TABLEXMove pages from free space to this table No Up to maximum table size DECREASE TABLEB
TABLED
TABLEE
TABLEXMove pages to free space from the respective table Yes Only if the _HIGHPG statistic permits it