COMPACTE command: Difference between revisions
(→Syntax) |
(→Syntax) |
||
| Line 25: | Line 25: | ||
<li> | <li> | ||
<p><var>MAXPR</var> 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.</p> | <p><var>MAXPR</var> specifies a number of page reads before the command allows a [[Checkpoints:_Storing_before-images_of_changed_pages|checkpoint]] and whether the user is being bumped or exceeding limits, such as I/O, CPU slices, or a higher priority user.</p> | ||
</li> | </li> | ||
</ul> | </ul> | ||
Latest revision as of 12:59, 11 February 2019
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 the compaction process). The default is no EXCL.
-
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