COMPACTE command: Difference between revisions
(→Usage) |
(→Syntax) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
<dd>File Manager | <dd>File Manager | ||
<dt>Function | <dt>Function | ||
<dd>Combine as many page gaps between large objects as possible into contiguous, free Table E pages. | <dd>Combine as many page gaps between large objects as possible into contiguous, free [[Table_E_(File_architecture)|Table E]] pages. | ||
</dl> | </dl> | ||
==Syntax== | ==Syntax== | ||
<p class="syntax">COMPACTE FROM nn TO nn EXCL MAXPR nn | <p class="syntax">COMPACTE FROM <var class="term">nn</var> TO <var class="term">nn</var> EXCL MAXPR <var class="term">nn</var> | ||
</p> | </p> | ||
<p>Where: </p> | <p>Where: </p> | ||
<ul> | <ul> | ||
<li> | <li> | ||
<p>FROM nn specifies the beginning segment number. The default is 0.</p> | <p>FROM <var class="term">nn</var> specifies the beginning segment number. The default is 0.</p> | ||
</li> | </li> | ||
<li> | <li> | ||
<p>TO nn specifies the ending segment number. The default is EHIGHPG segment.</p> | <p>TO <var class="term">nn</var> specifies the ending segment number. The default is <var>[[EHIGHPG_parameter|EHIGHPG]]</var> segment.</p> | ||
</li> | </li> | ||
<li> | <li> | ||
<p><var>EXCL</var> specifies an enqueue on file in exclusive mode and does not do constraints checking to speed up compaction process. The default is no.</p> | <p><var>EXCL</var> 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.</p> | ||
</li> | </li> | ||
<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> | ||
==Usage== | ==Usage== | ||
To effectively compact Table E: | To effectively compact Table E: | ||
<ol> | <ol> | ||
<li> | <li> | ||
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> | ||
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