UTABLE command

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:

HTLEN
LFSCB
LFTBL
LGTBL
LHEAP
LITBL
LNTBL
LPDLST
LQTBL
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.