FIXSIZE parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
mNo edit summary
 
(4 intermediate revisions by 3 users not shown)
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>
<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 class="code">FIXSIZE = 2536
<p>
       + ((LAUDPROC + 9) * 4)dwr
For non-SQL processing, <var>FIXSIZE</var> is determined according to the following calculation: </p>
       + (LIBUFF + 4)dwr
<p class="code">Fixed table size = 2520
      + ((MAXINCL+6) * 80)dwr
       + ((LAUDPROC + 9) * (MAXINCL-1))dwr
       + (LIBUFF + 4)  
       + (LOBUFF + 5)dwr
       + (LOBUFF + 5)dwr
       + (LOUTPB)dwr
       + (LOUTPB)dwr
       + ((NGROUP + 12) * (NRMTFILE + NFILES + 1))dwr
       + (((NGROUP + 12) * (NRMTFILE + NFILES + 1)) + (NRMTFILE + 1))dwr
      + (NRMTFILE + 1)dwr
       + ((NORQS*3) + 2)dwr
       + (3 * (NORQS + 1))dwr
      + (3 * ERRMSGL)
</p>
</p>
<p>where: </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&nbsp;204</var>):
<li>Add to the <var>NFILES</var> term (since its CCAIN value gets increased automatically by <var class="product">Model&nbsp;204</var>):  
+1 if either the SYSOPT 1 bit or 2 bit is set
<p>
+2 if both the SYSOPT 1 and 2 bits are set</li>
+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>

Latest revision as of 16:45, 25 April 2017

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:

Fixed table size = 2520 + ((MAXINCL+6) * 80)dwr + ((LAUDPROC + 9) * (MAXINCL-1))dwr + (LIBUFF + 4) + (LOBUFF + 5)dwr + (LOUTPB)dwr + (((NGROUP + 12) * (NRMTFILE + NFILES + 1)) + (NRMTFILE + 1))dwr + ((NORQS*3) + 2)dwr + (3 * ERRMSGL)

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.