FIXSIZE parameter: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
|||
| Line 43: | Line 43: | ||
</li> | </li> | ||
</ul> | </ul> | ||
<p>Fixed server tables as well as variable server tables, those that can be modified during the <var class="product">Model 204</var> run, are discussed in | <p> | ||
Fixed server tables as well as variable server tables, those that can be modified during the <var class="product">Model 204</var> run, are discussed in [[Defining the runtime environment (CCAIN)#Server tables|Server tables]]. </p> | |||
[[Category:Utable parameters]] | [[Category:Utable parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Revision as of 20:00, 30 October 2014
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.