COMPACTE command: Difference between revisions

From m204wiki
Jump to navigation Jump to search
 
(3 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:

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:

  1. Run a TABLEE command with the SEG option, identifying segments with a large number of gaps.
  2. Run the COMPACTE command for the segments of interest.
  3. 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