TABLEC command - Revision history

JAL: link repair

2014-12-03T21:36:40Z

link repair

← Older revision		Revision as of 21:36, 3 December 2014
Line 6:		Line 6:
	<dd>Displays information about memory use in Table C of a <var class="product">Model 204</var> file		<dd>Displays information about memory use in Table C of a <var class="product">Model 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 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 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]]

ELowell: /* Usage notes */

2013-07-01T18:27:42Z

Usage notes

← Older revision		Revision as of 18:27, 1 July 2013
Line 52:		Line 52:
	</ul>		</ul>
	<p>Table C contains all the hash index retrieval keys and associated values for a <var class="product">Model 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>Table C contains all the hash index retrieval keys and associated values for a <var class="product">Model 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 TABLE C FULL condition is usually reached when utilization exceeds 85 percent. For ~~a full discussion of file tables and utilization~~, see the ~~<var class="product">Model 204</var> File Manager's Guide~~.</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>
	====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>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>

Alex: Automatically generated page update

2013-02-28T01:05:31Z

Automatically generated page update

New page

==Summary==
<dl>
<dt>Privileges
<dd>File manager
<dt>Function
<dd>Displays information about memory use in Table C of a <var class="product">Model 204</var> file
</dl>
==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:
<ul>
<li>
Number of slots in Table C
</li>

<li>
Number of slots used
</li>

<li>
Percentage of Table C used
</li>

<li>
Total number of property entries
</li>

<li>
Number of pages with spills
</li>

<li>
Number of primary property entries with overflow
</li>

<li>
Percentage of property entries with overflow 
</li>
</ul>
Table C contains all the hash index retrieval keys and associated values for a <var class="product">Model 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).
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 a full discussion of file tables and utilization, see the <var class="product">Model 204</var> File Manager's Guide.
====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 command|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

[[Category: File manager commands]]
[[Category:Commands]]