TABLEC command: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (link repair)
 
Line 6: Line 6:
<dd>Displays information about memory use in Table C of a <var class="product">Model&nbsp;204</var> file
<dd>Displays information about memory use in Table C of a <var class="product">Model&nbsp;204</var> file
</dl>
</dl>
==Syntax==
==Syntax==
<p class="syntax">TABLEC
<p class="syntax">TABLEC
</p>
</p>
==Example==
==Example==
<p class="code">TABLEC  
<p class="code">TABLEC  
Line 20: Line 22:
OVERFLOW IS 33
OVERFLOW IS 33
</p>
</p>
==Usage notes==
==Usage notes==
The TABLEC command displays the following information about Table C usage:  
The TABLEC command displays the following information about Table C usage:  
Line 50: Line 53:
<p>Percentage of property entries with overflow </p>
<p>Percentage of property entries with overflow </p>
</li>
</li>
</ul>
</ul>
<p>Table C contains all the hash index retrieval keys and associated values for a <var class="product">Model&nbsp;204</var> file. You can issue the TABLEC command only in file context (that is, the current default must be a file, not a group).</p>
<p>
<p>The percentage of Table C that is used is never 100 percent. A TABLE C FULL condition is usually reached when utilization exceeds 85 percent. For more information, see [[Tuning_the_hash_index#Using_the_TABLEC_command_in_Monitoring|Using the TABLEC command in monitoring]].</p>
Table C contains all the hash index retrieval keys and associated values for a <var class="product">Model&nbsp;204</var> file. You can issue the TABLEC command only in file context (that is, the current default must be a file, not a group).</p>
<p>
The percentage of Table C that is used is never 100 percent. A <code>TABLE C FULL</code> condition is usually reached when utilization exceeds 85 percent. For more information, see [[Tuning the hash index#Using the TABLEC command in monitoring|Using the TABLEC command in monitoring]].</p>
 
====Sending TABLEC output to the USE data set====
====Sending TABLEC output to the USE data set====
<p>If there is an open USE data set, the TABLEC command output is directed to it. See [[RESET COMMAND command|RESET COMMAND: Control USE data set support]] for a discussion of how to direct the output.</p>
<p>
<p>You must use the MSGCTL command to suppress the message number prefix to direct the output of the TABLEC command to a USE data set. This applies to the TABLEC command, which uses messages to display its output, and also to any other command that might produce messages.</p>
If there is an open USE data set, the TABLEC command output is directed to it. See [[RESET COMMAND command|RESET COMMAND: Control USE data set support]] for a discussion of how to direct the output.</p>
<p>For the TABLEC command, use the following MSGCTL statements to enable support for USE data set output: </p>
<p>
You must use the MSGCTL command to suppress the message number prefix to direct the output of the TABLEC command to a USE data set. This applies to the TABLEC command, which uses messages to display its output, and also to any other command that might produce messages.</p>
<p>
For the TABLEC command, use the following MSGCTL statements to enable support for USE data set output: </p>
<p class="code">MSGCTL M204.0638 NOCOUNT NOPREFIX CLASS=I
<p class="code">MSGCTL M204.0638 NOCOUNT NOPREFIX CLASS=I
MSGCTL M204.0639 NOCOUNT NOPREFIX CLASS=I
MSGCTL M204.0639 NOCOUNT NOPREFIX CLASS=I
Line 65: Line 74:
MSGCTL M204.1871 NOCOUNT NOPREFIX CLASS=I
MSGCTL M204.1871 NOCOUNT NOPREFIX CLASS=I
</p>
</p>
[[Category: File manager commands]]
[[Category: File manager commands]]
[[Category:Commands]]
[[Category:Commands]]

Latest revision as of 21:36, 3 December 2014

Summary

Privileges
File manager
Function
Displays information about memory use in Table C of a Model 204 file

Syntax

TABLEC

Example

TABLEC M204.0638: NUMBER OF SLOTS = 102400 M204.0639: SLOTS USED = 76800 M204.0640: PERCENTAGE OF TABLE C USED = 75 M204.1833: THE TOTAL NUMBER OF PROPERTY ENTRIES IS 7496 M204.1874: THE NUMBER OF PAGES WITH SPILLS IS 33 M204.1834: 2500 PRIMARY PROPERTY ENTRIES HAVE OVERFLOW M204.1871: THE PERCENTAGE OF PROPERTY ENTRIES WITH OVERFLOW IS 33

Usage notes

The TABLEC command displays the following information about Table C usage:

  • Number of slots in Table C

  • Number of slots used

  • Percentage of Table C used

  • Total number of property entries

  • Number of pages with spills

  • Number of primary property entries with overflow

  • Percentage of property entries with overflow

Table C contains all the hash index retrieval keys and associated values for a Model 204 file. You can issue the TABLEC command only in file context (that is, the current default must be a file, not a group).

The percentage of Table C that is used is never 100 percent. A TABLE C FULL condition is usually reached when utilization exceeds 85 percent. For more information, see Using the TABLEC command in monitoring.

Sending TABLEC output to the USE data set

If there is an open USE data set, the TABLEC command output is directed to it. See RESET COMMAND: Control USE data set support for a discussion of how to direct the output.

You must use the MSGCTL command to suppress the message number prefix to direct the output of the TABLEC command to a USE data set. This applies to the TABLEC command, which uses messages to display its output, and also to any other command that might produce messages.

For the TABLEC command, use the following MSGCTL statements to enable support for USE data set output:

MSGCTL M204.0638 NOCOUNT NOPREFIX CLASS=I MSGCTL M204.0639 NOCOUNT NOPREFIX CLASS=I MSGCTL M204.0640 NOCOUNT NOPREFIX CLASS=I MSGCTL M204.1833 NOCOUNT NOPREFIX CLASS=I MSGCTL M204.1874 NOCOUNT NOPREFIX CLASS=I MSGCTL M204.1834 NOCOUNT NOPREFIX CLASS=I MSGCTL M204.1871 NOCOUNT NOPREFIX CLASS=I