COMPACTE command: Difference between revisions
m (Automatically generated page update) |
(→Usage) |
||
| Line 28: | Line 28: | ||
</ul> | </ul> | ||
==Usage== | ==Usage== | ||
To effectively compact Table E | 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. | ||
Revision as of 19:13, 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 compaction process. The default is no.
-
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 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