SERVSIZE parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Automatically generated page update)
 
Line 29: Line 29:
====Handling SQL statements greater than 32k bytes====
====Handling SQL statements greater than 32k bytes====
<p>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.</p>
<p>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.</p>
[[Category:Server Parameters]]
[[Category:Server parameters]]
[[Category:Parameters]]
[[Category:Parameters]]

Revision as of 14:41, 19 April 2013

Summary

Default value
0
Parameter type
Server
Where set
View only; set on first NSERVS user's parameter lines
Related products
All
Introduced
Model 204 V6.1 or earlier

Description

The size of the server area to be allocated

SERVSIZE must not be a negative number. If the default value of zero 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 Rocket Model 204 System Manager's Guide in the chapter for defining the runtime environment (CCAIN).

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.