FIXSIZE parameter: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
m (misc formatting) |
||
| Line 13: | Line 13: | ||
<dd><var class="product">Model 204 V6.1</var> or earlier | <dd><var class="product">Model 204 V6.1</var> or earlier | ||
</dl> | </dl> | ||
==Description== | ==Description== | ||
<p>The size of the user's server tables that are fixed by initialization | <p> | ||
<p>For non-SQL processing, FIXSIZE is determined according to the following calculation: </p> | The size of the user's server tables that are fixed by initialization. </p> | ||
<p> | |||
For non-SQL processing, <var>FIXSIZE</var> is determined according to the following calculation: </p> | |||
<p class="code">FIXSIZE = 2536 | <p class="code">FIXSIZE = 2536 | ||
+ ((LAUDPROC + 9) * 4)dwr | + ((LAUDPROC + 9) * 4)dwr | ||
| Line 25: | Line 28: | ||
+ (3 * (NORQS + 1))dwr | + (3 * (NORQS + 1))dwr | ||
</p> | </p> | ||
<p> | <p>Where: </p> | ||
<ul> | <ul> | ||
<li> | <li>dwr, "double word rounded," means round to the next multiple of eight, unless it already is a multiple of eight. </li> | ||
dwr, "double word rounded," means round to the next multiple of eight, unless it already is a multiple of eight. </li> | |||
<li> | <li>The following adjustments might apply: | ||
The following adjustments might apply: | |||
<ul> | <ul> | ||
<li> | <li> | ||
NRMTFILE is zero except for PQO users.</li> | <var>NRMTFILE</var> is zero, except for PQO users.</li> | ||
<li> | |||
Add to the NFILES term (since its CCAIN value gets increased automatically by <var class="product">Model 204</var>): | <li>Add to the <var>NFILES</var> term (since its CCAIN value gets increased automatically by <var class="product">Model 204</var>): | ||
+1 if either the SYSOPT 1 bit or 2 bit is set | <p> | ||
+1 if either the <var>SYSOPT</var> 1 bit or 2 bit is set </p> | |||
<li> | <p> | ||
If any SQL threads (IODEV 19) are specified in the CCAIN, add 6328 bytes for C language work areas to the FIXSIZE calculation. </li> | +2 if both the <var>SYSOPT</var> 1 and 2 bits are set </p></li> | ||
<li>If any SQL threads (<var>IODEV</var> 19) are specified in the CCAIN, add 6328 bytes for C language work areas to the <var>FIXSIZE</var> calculation. </li> | |||
</ul> | </ul> | ||
</li> | </li> | ||
Revision as of 16:00, 8 July 2015
Fixed server size requirement
Summary
- Default value
- None
- Parameter type
- Utable
- Where set
- View-only
- Related products
- All
- Introduced
- Model 204 V6.1 or earlier
Description
The size of the user's server tables that are fixed by initialization.
For non-SQL processing, FIXSIZE is determined according to the following calculation:
FIXSIZE = 2536 + ((LAUDPROC + 9) * 4)dwr + (LIBUFF + 4)dwr + (LOBUFF + 5)dwr + (LOUTPB)dwr + ((NGROUP + 12) * (NRMTFILE + NFILES + 1))dwr + (NRMTFILE + 1)dwr + (3 * (NORQS + 1))dwr
Where:
- dwr, "double word rounded," means round to the next multiple of eight, unless it already is a multiple of eight.
- The following adjustments might apply:
- NRMTFILE is zero, except for PQO users.
- Add to the NFILES term (since its CCAIN value gets increased automatically by Model 204):
+1 if either the SYSOPT 1 bit or 2 bit is set
+2 if both the SYSOPT 1 and 2 bits are set
- If any SQL threads (IODEV 19) are specified in the CCAIN, add 6328 bytes for C language work areas to the FIXSIZE calculation.
Fixed server tables as well as variable server tables, those that can be modified during the Model 204 run, are discussed in Server tables.