TABLEC command

From m204wiki
Revision as of 21:36, 3 December 2014 by JAL (talk | contribs) (link repair)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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