COMPACTE command: Difference between revisions
(→Usage) |
(→Usage) |
||
| Line 33: | Line 33: | ||
Run a [[TABLEE command]] with the SEG option, identifying segments with a large number of gaps.</li> | Run a [[TABLEE command]] with the SEG option, identifying segments with a large number of gaps.</li> | ||
<li> | <li> | ||
Run the COMPACTE command for segments of interest.</li> | Run the COMPACTE command for the segments of interest.</li> | ||
<li>Run another TABLEE command for the compacted segments to check the results.</li> | <li>Run another TABLEE command for the compacted segments to check the results.</li> | ||
</ol> | </ol> | ||
Revision as of 19:15, 18 July 2013
Summary
- Privileges
- File Manager
- Function
- Combine as many page gaps between large objects as possible into contiguous, free Table E pages.
Syntax
COMPACTE FROM nn TO nn EXCL MAXPR nn
Where:
-
FROM nn specifies the beginning segment number. The default is 0.
-
TO nn specifies the ending segment number. The default is EHIGHPG segment.
-
EXCL specifies an enqueue on file in exclusive mode and does not do constraints checking to speed up compaction process. The default is no.
-
MAXPR specifies a number of page reads before the command allows a checkpoint and whether the user is being bumped or exceeding limits, such as I/O, CPU slices, or a higher priority user.
Usage
To effectively compact Table E:
- Run a TABLEE command with the SEG option, identifying segments with a large number of gaps.
- Run the COMPACTE command for the segments of interest.
- Run another TABLEE command for the compacted segments to check the results.
Example
The following is an example of COMPACTE output.
COMPACTE MAXPR 99 FROM 0 TO 10 EXCL *** M204.2811: NUMBER OF MOVED OBJECTS: 18327 *** M204.2812: NUMBER OF MOVED PAGES: 85849 *** M204.2813: NUMBER OF RECORD LOCKING CONFLICTS: 0 *** M204.2814: NUMBER OF MULTISEGMENT OBJECTS: 0