SERVSIZE parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
 
(One intermediate revision by one other user not shown)
Line 5: Line 5:
<dt>Default value
<dt>Default value
<dd>65536 as of version 7.7 (and zap maintenance in 7.6, 7.5, and 7.4); formerly, 0
<dd>65536 as of version 7.7 (and zap maintenance in 7.6, 7.5, and 7.4); formerly, 0
<dd>0 as of version 7.9
<dt>Parameter type
<dt>Parameter type
<dd>Server
<dd>Server
Line 18: Line 19:
<p>
<p>
The size of the server area to be allocated, rounded up to a multiple of the smallest operating system page size. So, for example, an Online with servers set to 750000 will show 753664 (the next highest multiple of the 4096 page size) under z/OS.</p>
The size of the server area to be allocated, rounded up to a multiple of the smallest operating system page size. So, for example, an Online with servers set to 750000 will show 753664 (the next highest multiple of the 4096 page size) under z/OS.</p>
<p> Under 7.9, if the entire server is placed above the bar using <var>[[SERVGA parameter|SERVGA]]</var> and/or <var>[[SERVNSA parameter|SERVNSA]]</var>, this parameter should be omitted (or set to zero) in order to avoid below the bar allocation.</p>
<p>
<p>
<var>SERVSIZE</var> must not be a negative number. If the default value is used, the server area allocated is exactly large enough to contain the tables for the user specified on the same parameter line. If a positive value less than <var>[[FIXSIZE parameter|FIXSIZE]]</var> (user's fixed size) is specified, <var class="product">Model&nbsp;204</var> increases the value so that the server area allocated is large enough to hold the user's fixed size.  </p>
<var>SERVSIZE</var> must not be a negative number. If the default value is used, the server area allocated is exactly large enough to contain the tables for the user specified on the same parameter line. If a positive value less than <var>[[FIXSIZE parameter|FIXSIZE]]</var> (user's fixed size) is specified, <var class="product">Model&nbsp;204</var> increases the value so that the server area allocated is large enough to hold the user's fixed size.  </p>
Line 36: Line 38:
====Handling SQL statements greater than 32K bytes====
====Handling SQL statements greater than 32K bytes====
<p>
<p>
When handling an SQL statement that is greater than 32K, you must consider the <var>SERVSIZE</var> parameter: If its value is not large enough, the error message invoked includes the name of the relevant parameter whose value needs to be increased (<var>LSTBL</var>, <var>LNTBL</var>, etc.).</p>
When handling an SQL statement that is greater than 32K, you must consider the <var>SERVSIZE</var> parameter: If its value is not large enough, the error message invoked includes the name of the relevant parameter whose value needs to be increased (<var>[[LSTBL_parameter|LSTBL]]</var>, <var>[[LNTBL_parameter|LNTBL]]</var>, etc.).</p>


[[Category:Parameters]]
[[Category:Parameters]]

Latest revision as of 02:05, 26 January 2021

Maximum size of this server

Summary

Default value
65536 as of version 7.7 (and zap maintenance in 7.6, 7.5, and 7.4); formerly, 0
0 as of version 7.9
Parameter type
Server
Where set
View only; set on first NSERVS user's parameter lines
Related products
All
Introduced
Model 204 V2.1 or earlier

Description

The size of the server area to be allocated, rounded up to a multiple of the smallest operating system page size. So, for example, an Online with servers set to 750000 will show 753664 (the next highest multiple of the 4096 page size) under z/OS.

Under 7.9, if the entire server is placed above the bar using SERVGA and/or SERVNSA, this parameter should be omitted (or set to zero) in order to avoid below the bar allocation.

SERVSIZE must not be a negative number. If the default value is used, the server area allocated is exactly large enough to contain the tables for the user specified on the same parameter line. If a positive value less than FIXSIZE (user's fixed size) is specified, Model 204 increases the value so that the server area allocated is large enough to hold the user's fixed size.

In a Model 204 run that uses server swapping (the typical case for Online runs), the size of each server is likely to be limited by the physical device used for swapping.

  • When a CKD device is used for swapping, server size is limited to the device's cylinder size.
  • When an FBA device is used, server size is limited by the amount of virtual memory available to Model 204.
  • All servers defined for the run, along with many other blocks of storage, must fit in virtual memory.
  • In a run that does not use server swapping (the typical case for batch runs), the servers for all users in the run must fit in virtual memory.

For a description of how the sizes of the fixed table and the variable table are calculated, see Sizing user server areas.

Handling SQL statements greater than 32K bytes

When handling an SQL statement that is greater than 32K, you must consider the SERVSIZE parameter: If its value is not large enough, the error message invoked includes the name of the relevant parameter whose value needs to be increased (LSTBL, LNTBL, etc.).