COMPACTE command - Revision history

DCameron: /* Syntax */

2019-02-11T12:59:53Z

Syntax

← Older revision		Revision as of 12:59, 11 February 2019
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>

DCameron: /* Syntax */

2019-02-11T12:58:28Z

Syntax

← Older revision		Revision as of 12:58, 11 February 2019
Line 17:		Line 17:

	<li>		<li>
	<p>TO <var class="term">nn</var> 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>

DCameron: /* Summary */

2019-02-11T12:56:36Z

Summary

← Older revision		Revision as of 12:56, 11 February 2019
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 <var class="term">nn</var> TO <var class="term">nn</var> EXCL MAXPR <var class="term">nn</var>		<p class="syntax">COMPACTE FROM <var class="term">nn</var> TO <var class="term">nn</var> EXCL MAXPR <var class="term">nn</var>

ELowell: /* Syntax */

2013-07-18T19:23:28Z

Syntax

← Older revision		Revision as of 19:23, 18 July 2013
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:

ELowell: /* Usage */

2013-07-18T19:15:07Z

Usage

← Older revision		Revision as of 19:15, 18 July 2013
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>

ELowell: /* Usage */

2013-07-18T19:14:32Z

Usage

← Older revision		Revision as of 19:14, 18 July 2013
Line 31:		Line 31:
	<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 segments of interest.</li>

ELowell: /* Usage */

2013-07-18T19:13:55Z

Usage

← Older revision		Revision as of 19:13, 18 July 2013
Line 28:		Line 28:
	</ul>		</ul>
	==Usage==		==Usage==
	To effectively compact Table E~~, Rocket Software recommends running~~ a TABLEE command with the SEG option, identifying segments with large number of gaps~~, running~~ COMPACTE command for segments of interest~~, and then running~~ another TABLEE command for compacted segments to check the results.		To effectively compact Table E:
			<ol>
			<li>
			Run a TABLEE command with the SEG option, identifying segments with a large number of gaps.</li>
			<li>
			Run the COMPACTE command for segments of interest.</li>
			<li>Run another TABLEE command for the compacted segments to check the results.</li>
			</ol>

	==Example==		==Example==
	The following is an example of COMPACTE output.		The following is an example of COMPACTE output.

Alex: Automatically generated page update

2013-02-28T01:04:35Z

Automatically generated page update

New page

==Summary==
<dl>
<dt>Privileges
<dd>File Manager
<dt>Function
<dd>Combine as many page gaps between large objects as possible into contiguous, free Table E pages.
</dl>
==Syntax==
COMPACTE FROM nn TO nn EXCL MAXPR nn

Where: 
<ul>
<li>
FROM nn specifies the beginning segment number. The default is 0.
</li>

<li>
TO nn specifies the ending segment number. The default is EHIGHPG segment.
</li>

<li>
<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.
</li>

<li>
<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.
</li>
</ul>
==Usage==
To effectively compact Table E, Rocket Software recommends running a TABLEE command with the SEG option, identifying segments with large number of gaps, running COMPACTE command for segments of interest, and then running another TABLEE command for 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

[[Category:Commands]]