UTABLE command: Difference between revisions

From m204wiki
Jump to navigation Jump to search
Line 40: Line 40:
<p>The UTABLE command allows a user to change the size of the server tables or to help determine the minimum SERVSIZE value needed for tables of specified sizes.</p>
<p>The UTABLE command allows a user to change the size of the server tables or to help determine the minimum SERVSIZE value needed for tables of specified sizes.</p>
<p>You can reset the following parameters using the UTABLE command:</p>
<p>You can reset the following parameters using the UTABLE command:</p>
<ul>
<table>
<li>HTLEN </li>
<tr><th>Parameter</th><th>Meaning</th></tr>
<li>LFSCB </li>
<tr><td><var>HTLEN</var></td><td></td></tr>
<li>LFTBL</li>
<tr><td><var>LFSCB</var></td><td></td></tr>
<li>LGTBL </li>
<tr><td><var>LFTBL</var></td><td>Number of bytes in FTBL</td></tr>
<li>LHEAP </li>
<tr><td><var>LGTBL</var></td><td>Number of bytes in GTBL</td></tr>
<li>LITBL</li>
<tr><td><var>LHEAP</var></td><td></td></tr>
<li>LNTBL </li>
<tr><td><var>LITBL</var></td><td></td></tr>
<li>LPDLST </li>
<tr><td><var>LNTBL</var></td><td>Number of 12 byte entries in NTBL</td></tr>
<li>LQTBL</li>
<tr><td><var>LPDLST</var></td><td></td></tr>
<li>LSTBL </li>
<tr><td><var>LQTBL</var></td><td>Number of 16 byte entries in QTBL</td></tr>
<li>LTTBL </li>
<tr><td><var>LSTBL</var></td><td></td></tr>
<li>LVTBL</li>
<tr><td><var>LTTBL</var></td><td></td></tr>
<li>LXTBL </li>
<tr><td><var>LVTBL</var></td><td></td></tr>
<li>MAXHDR </li>
<tr><td><var>LXTBL</var></td><td></td></tr>
<li>MAXTRL</li>
<tr><td><var>MAXHDR</var></td><td></td></tr>
</ul>
<tr><td><var>MAXTRL</var></td><td></td></tr>
</table>
<p>You can specify any number of user table parameters. For information on specifying parameter values, refer to Chapter 1. </p>
<p>You can specify any number of user table parameters. For information on specifying parameter values, refer to Chapter 1. </p>
<p>If a User Language application makes extensive use of file groups, you can optimize server utilization by adjusting table sizes while files or groups are open.</p>
<p>If a User Language application makes extensive use of file groups, you can optimize server utilization by adjusting table sizes while files or groups are open.</p>

Revision as of 15:19, 11 July 2013

Summary

Privileges
Any user
Function
Sets or calculates the size of your server tables

Syntax

UTABLE [(SIZE)] parameter=value [,parameter=value] ...

Where:

SIZE indicates that the overall size of the server is calculated, but that the table sizes is not reset.
parameter is a Model 204 user table (UTABLE) parameter.
value is the new value of the parameter.

Syntax notes

Equal signs and commas are optional.

Example

UTABLE LNTBL = 100 LSTBL = 700 LNTBL 100 LENGTH OF NTBL LSTBL 700 LENGTH OF STBL *** M204.0098: MINIMUM SERVSIZE FOR THESE TABLES = 47448

Usage notes

The UTABLE command allows a user to change the size of the server tables or to help determine the minimum SERVSIZE value needed for tables of specified sizes.

You can reset the following parameters using the UTABLE command:

ParameterMeaning
HTLEN
LFSCB
LFTBLNumber of bytes in FTBL
LGTBLNumber of bytes in GTBL
LHEAP
LITBL
LNTBLNumber of 12 byte entries in NTBL
LPDLST
LQTBLNumber of 16 byte entries in QTBL
LSTBL
LTTBL
LVTBL
LXTBL
MAXHDR
MAXTRL

You can specify any number of user table parameters. For information on specifying parameter values, refer to Chapter 1.

If a User Language application makes extensive use of file groups, you can optimize server utilization by adjusting table sizes while files or groups are open.

When changing table sizes for open files or groups, keep the following restrictions and interdependencies in mind:

  • If you request an LFTBL size that is smaller than the amount required by your currently open groups, the following message is displayed:

    *** M204.1941: NEW LFTBL MUST BE AT LEAST nn, FILES MUST BE CLOSED

  • If you change either LFTBL or LXTBL, and you have entries in your XTBL, the following message is displayed:

    *** M204.0100: FILES MUST BE CLOSED TO CHANGE XTBL

  • If you change LFTBL, LXTBL, or LGTBL, and you have entries in your GTBL, then the following message is displayed:

    *** M204.0101: ALLOCATED GLOBALS WILL BE CLEARED

  • If you change LFTBL, LXTBL, LGTBL, or LITBL, and you have stacked $READ arguments in your ITBL, then the following message is displayed:

    *** M204.0102: LITBL RESET CLEARS STACKED ARGUMENTS

  • If you are in an application subsystem and either of the "FILES MUST BE CLOSED" messages is issued (M204.1941 or M204.0100), then the following message is issued and the UTABLE command is terminated:

    *** M204.1195: CAN'T CLOSE ALL FILES FROM A SUBSYSTEM

  • If you are not in an application subsystem and any of the conditions described above occurs, the following message is displayed and you can elect to terminate the operation by entering N:

    *** M204.1076: DO YOU REALLY WANT TO CONTINUE?

    If you enter Y, all open files and groups are closed. If M204.1195 or M204.0100 were issued, GTBL and/or ITBL are cleared, and the UTABLE command continues processing.

Changing the size of any table using UTABLE causes an outstanding END MORE to be canceled.

An increase in size of one server table can require a decrease in size of one or more of the other server tables. This happens if you are already in the largest server and all available table space within the server has been used.