UTABLE command: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Automatically generated page update)
 
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>
<table>
<ul>
 
<li>HTLEN </li>
<tr> <th>
<li>LFSCB </li>
<p>Parameter </p>
<li>LFTBL</li>
</th> <th>
<li>LGTBL </li>
<p>Parameter </p>
<li>LHEAP </li>
</th> <th>
<li>LITBL</li>
<p>Parameter</p>
<li>LNTBL </li>
</th> </tr>
<li>LPDLST </li>
 
<li>LQTBL</li>
<tr> <th><var>
<li>LSTBL </li>
<p>HTLEN </p>
<li>LTTBL </li>
</var></th> <td>
<li>LVTBL</li>
<p>LFSCB </p>
<li>LXTBL </li>
</td> <td>
<li>MAXHDR </li>
<p>LFTBL</p>
<li>MAXTRL</li>
</td> </tr>
</ul>
<tr> <th><var>
<p>LGTBL </p>
</var></th> <td>
<p>LHEAP </p>
</td> <td>
<p>LITBL</p>
</td> </tr>
<tr> <th><var>
<p>LNTBL </p>
</var></th> <td>
<p>LPDLST </p>
</td> <td>
<p>LQTBL</p>
</td> </tr>
<tr> <th><var>
<p>LSTBL </p>
</var></th> <td>
<p>LTTBL </p>
</td> <td>
<p>LVTBL</p>
</td> </tr>
<tr> <th><var>
<p>LXTBL </p>
</var></th> <td>
<p>MAXHDR </p>
</td> <td>
<p>MAXTRL</p>
</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>
<p>When changing table sizes for open files or groups, keep the following restrictions and interdependencies in mind: </p>
<p>When changing table sizes for open files or groups, keep the following restrictions and interdependencies in mind: </p>
<ul>  
<ul>
<li>
<li>
<p>If you request an LFTBL size that is smaller than the amount required by your currently open groups, the following message is displayed: </p>
<p>If you request an LFTBL size that is smaller than the amount required by your currently open groups, the following message is displayed: </p>
<p class="code">*** M204.1941: NEW LFTBL MUST BE AT LEAST nn, FILES MUST BE CLOSED  
<p class="code">*** M204.1941: NEW LFTBL MUST BE AT LEAST nn, FILES MUST BE CLOSED
</p>
</p>
</li>
</li>
Line 115: Line 81:
<li>
<li>
<p>If you change LFTBL, LXTBL, LGTBL, or LITBL, and you have stacked $READ arguments in your ITBL, then the following message is displayed: </p>
<p>If you change LFTBL, LXTBL, LGTBL, or LITBL, and you have stacked $READ arguments in your ITBL, then the following message is displayed: </p>
<p class="code">*** M204.0102: LITBL RESET CLEARS STACKED ARGUMENTS  
<p class="code">*** M204.0102: LITBL RESET CLEARS STACKED ARGUMENTS
</p>
</p>
</li>
</li>
Line 127: Line 93:
<li>
<li>
<p>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: </p>
<p>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: </p>
<p class="code">*** M204.1076: DO YOU REALLY WANT TO CONTINUE?  
<p class="code">*** M204.1076: DO YOU REALLY WANT TO CONTINUE?
</p>
</p>
<p>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. </p>
<p>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. </p>

Revision as of 14:48, 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:

  • 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.

Retrieved from "https://m204wiki.rocketsoftware.com/index.php?title=UTABLE_command&oldid=60813"