COMPACTE command: Difference between revisions
(→Usage) |
(→Syntax) |
||
| Line 7: | Line 7: | ||
</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 EHIGHPG 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> | ||
| Line 27: | Line 27: | ||
</li> | </li> | ||
</ul> | </ul> | ||
==Usage== | ==Usage== | ||
To effectively compact Table E: | To effectively compact Table E: | ||
Revision as of 19:23, 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 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