INCREASE command: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
m (misc cleanup)
 
(3 intermediate revisions by 3 users not shown)
Line 8: Line 8:


There are two forms of the increase command:
There are two forms of the increase command:
<ul>
<li>The <var>[[#Syntax for INCREASE DATASETS|INCREASE DATASETS]]</var> command, which increases the datasets used by a <var class="product">Model&nbsp;204</var> file, and increases the free pages (which are counted by the <var>[[FREESIZE parameter|FREESIZE]]</var> parameter. </li>


<ul>
<li>The <var>[[#Syntax for INCREASE of a table|INCREASE]]</var> command ("non-<var>DATASET</var>"), which increases the space available in one of the tables of a <var class="product">Model&nbsp;204</var> file. </li>
<li>the <var>[[#Syntax for INCREASE DATASETS|INCREASE DATASETS]]</var> command, which increases the datasets used by a <var class="product">Model&nbsp;204</var> file, and increases the free pages (which are counted by the <var>[[FREESIZE parameter|FREESIZE]]</var> parameter
</li>the <var>[[#Syntax for INCREASE of a table|INCREASE]]</var> command ("non-<var>DATASET</var>") which increases the space available in one of the tables of a <var class="product">Model&nbsp;204</var> file.
</ul>
</ul>


Line 22: Line 22:


===Syntax notes===
===Syntax notes===
<p>An INCREASE command must be issued in file context. That is, the current default must be a file, not a group.</p>
<p>
<p>Each <var class="term">ddname</var> parameter can be separated by commas or by one or more blanks. A DD name, not a data set name, must be used in the command.</p>
An <var>INCREASE</var> command must be issued in file context. That is, the current default must be a file, not a group.</p>
<p>
Each <var class="term">ddname</var> parameter can be separated by commas or by one or more blanks. A DD name, not a data set name, must be used in the command.</p>


==Syntax for INCREASE of a table==
==Syntax for INCREASE of a table==
Line 29: Line 31:
</p>
</p>
   
   
<b>Where:</b>
Where:
<ul>  
<ul>  
<li>
<li><p><var class="term">n</var> is the number of pages in free space to be assigned to the specified table. The value of <var class="term">n</var> is in the range 1 through the value of the <var>FREESIZE</var> parameter (the number of unassigned pages available in the <var class="product">Model&nbsp;204</var> file).</p></li>
<p><var class="term">n</var> is the number of pages in free space to be assigned to the specified table. The value of n is in the range 1 through the value of the FREESIZE parameter (the number of unassigned pages available in the <var class="product">Model&nbsp;204</var> file).</p>
</li>
   
   
<li>
<li><p><var>DYNAMIC</var> (or <var>DYN</var>) specifies that Table B is to be increased even if the file is opened by other users and has requests compiled against it. This option is available from Model&nbsp;204 V7.1 onwards.</p></li>
<p><var>DYNAMIC</var> or <var>DYN</var> specifies that Table B is to be increased even if the file is opened by other users and has requests compiled against it.</p>
</ul>
</li>
 
</ul>
===Syntax notes===
===Syntax notes===
<p>An INCREASE command must be issued in file context. That is, the current default must be a file, not a group.</p>
<p>
An <var>INCREASE</var> command must be issued in file context. That is, the current default must be a file, not a group.</p>


==Example==
==Example==
Line 49: Line 49:
INCREASE TABLED 800
INCREASE TABLED 800
</p>
</p>
==Usage notes==
==Usage notes==
<p>If it is required to expand FREESIZE by adding extra data sets to the file to support the increase of a table, then the INCREASE DATASETS command should precede the INCREASE command for Table B, Table D, Table E, or Table X.</p>
<p>
<p>You can assign additional pages from free space for use by either Table B (except for [[File_Design_(File_Management)#Hash_Key_Files|hash key files]]), Table D, Table E, or Table X. The size of Tables A and C cannot be changed without reorganizing the file.</p>
If it is required to expand <var>FREESIZE</var> by adding extra data sets to the file to support the increase of a table, then the <var>INCREASE DATASETS</var> command should precede the <var>INCREASE</var> command for Table B, Table D, Table E, or Table X.</p>
<p>You can issue INCREASE DATASETS, INCREASE TABLEB, INCREASE TABLED, INCREASE TABLEE, and INCREASE TABLEX commands without stopping a file and bumping all users out of the file. The file may be accessed or updated at the same time while the INCREASE command is processing. </p>
<p>
<p>However, <var class="product">Model&nbsp;204</var> handles INCREASE processing only one type at a time in succession, not simultaneously. You cannot process an INCREASE DATASETS command and an INCREASE TABLEB command at the same time.</p>
You can assign additional pages from free space for use by either Table B (except for [[File design#Hash key files (X'08')|hash key files]]), Table D, Table E, or Table X. The size of Tables A and C cannot be changed without reorganizing the file.</p>
<p>You can increase Table B, even when the file is open and has requests compiled against it, by using the DYNAMIC option. Without this option the INCREASE TABLEB command processes only files that are not open by any other users or subsystems. There is a small performance penalty for MP/204 users: multiprocessing is stopped for a short time while internal changes are made.</p>
<p>
<p>Increasing and decreasing a file, the various tables that make up a file, and the relevant table parameters are explained in detail in the [[File management overview|File management]] articles, such as [[Managing file and table sizes]].</p>
You can issue <code>INCREASE DATASETS</code>, <code>INCREASE TABLEB</code>, <code>INCREASE TABLED</code>, <code>INCREASE TABLEE</code>, and <code>INCREASE TABLEX</code> commands without stopping a file and bumping all users out of the file. The file may be accessed or updated at the same time while the <var>INCREASE</var> command is processing. </p>
<p>If you are increasing the size of a table in response to a file full condition (FISTAT=X'08'), reset FISTAT to X'00' after performing the INCREASE command.</p>  
<p>
<p>However, make sure that the FISTAT X'02' bit (File is physically inconsistent) is not set. <b>Never</b> reset FISTAT for a physically inconsistent file.</p>
However, <var class="product">Model&nbsp;204</var> handles INCREASE processing only one type at a time in succession, not simultaneously. You cannot process an <code>INCREASE DATASETS</code> command and an <code>INCREASE TABLEB</code> command at the same time.</p>
<p>In Model 204 7.5 and later, the file full bit (FISTAT X'08') will be automatically cleared in a TBO file if table D is increased enough so that DSIZE is greater than or equal to DPGSRES+DPGSUSED.</p>
<p>
<p><b>Privileges required</b></p>
You can increase Table B, even when the file is open and has requests compiled against it, by using the <var>DYNAMIC</var> option. Without this option, an <code>INCREASE TABLEB</code> command processes only files that are not open by any other users or subsystems. There is a small performance penalty for [[MP/204]] users: multiprocessing is stopped for a short time while internal changes are made.</p>
<p>To use the INCREASE command you must have update authority to the selected file. If the file is open for read-only access, the INCREASE command is rejected with the following message:</p>
<p>
Increasing and decreasing a file, the various tables that make up a file, and the relevant table parameters are explained in detail in the [[File management overview|File management]] articles, such as [[Managing file and table sizes]].</p>
<p>
If you are increasing the size of a table in response to a file full condition (<var>FISTAT</var> X'08'), reset <var>FISTAT</var> to X'00' after performing the <var>INCREASE</var> command.</p>  
<p>
However, make sure that the <var>FISTAT</var> X'02' bit (File is physically inconsistent) is not set. <b>Never</b> reset <var>FISTAT</var> for a physically inconsistent file.</p>
<p>
In Model 204 7.5 and later, the file full bit (<var>FISTAT</var> X'08') is automatically cleared in a TBO file if Table D is increased enough so that <var>DSIZE</var> is greater than or equal to <code>DPGSRES+DPGSUSED</code>.</p>
<p>
<b>Privileges required</b></p>
<p>
To use the <var>INCREASE</var> command you must have update authority to the selected file. If the file is open for read-only access, the <var>INCREASE</var> command is rejected with the following message:</p>
<p class="code">M204.1036: UPDATES NOT PERMITTED
<p class="code">M204.1036: UPDATES NOT PERMITTED
</p>
</p>
<p>The INCREASE command cannot be used to increase XSIZE from zero.</p>
<p>
The <var>INCREASE</var> command cannot be used to increase <var>XSIZE</var> from zero.</p>


==See also==
==See also==
<ul>
<ul>
<li>Further information about the use of <var>INCREASE</var>, including issues concerning exclusive file access and increasing the number of file segments, can be found in the [[Managing file and table sizes]] article.
<li>Further information about the use of <var>INCREASE</var>, including issues concerning exclusive file access and increasing the number of file segments, can be found in the [[Managing file and table sizes]] article. </li>
<li>The <var>[[DECREASE command|DECREASE]]</var> command can be used to return unused pages, increasing <var>FREESIZE</var> so they can be used for another file table.
 
<li>The <var>[[DECREASE command|DECREASE]]</var> command can be used to return unused pages, increasing <var>FREESIZE</var> so they can be used for another file table. </li>
</ul>
</ul>
[[Category: File manager commands]]
[[Category: File manager commands]]
[[Category:Commands]]
[[Category:Commands]]

Latest revision as of 21:21, 21 March 2017

Summary

Privileges
File manager
Function
Increases the space available for a Model 204 file, or the space available in one of the tables of a Model 204 file.

There are two forms of the increase command:

  • The INCREASE DATASETS command, which increases the datasets used by a Model 204 file, and increases the free pages (which are counted by the FREESIZE parameter.
  • The INCREASE command ("non-DATASET"), which increases the space available in one of the tables of a Model 204 file.

Syntax for INCREASE DATASETS

INCREASE {DATASETS [WITH] ddname [,ddname]...}

Where: ddname is the data set whose pages are to be allocated to free space.

Syntax notes

An INCREASE command must be issued in file context. That is, the current default must be a file, not a group.

Each ddname parameter can be separated by commas or by one or more blanks. A DD name, not a data set name, must be used in the command.

Syntax for INCREASE of a table

INCREASE {TABLEB n [DYNAMIC|DYN]} | {TABLED | TABLEE | TABLEX} n

Where:

  • n is the number of pages in free space to be assigned to the specified table. The value of n is in the range 1 through the value of the FREESIZE parameter (the number of unassigned pages available in the Model 204 file).

  • DYNAMIC (or DYN) specifies that Table B is to be increased even if the file is opened by other users and has requests compiled against it. This option is available from Model 204 V7.1 onwards.

Syntax notes

An INCREASE command must be issued in file context. That is, the current default must be a file, not a group.

Example

OPEN CARS update password INCREASE DATASETS WITH CARS1, CAR2, C3, CABC INCREASE TABLEB 500 DYNAMIC INCREASE TABLED 800

Usage notes

If it is required to expand FREESIZE by adding extra data sets to the file to support the increase of a table, then the INCREASE DATASETS command should precede the INCREASE command for Table B, Table D, Table E, or Table X.

You can assign additional pages from free space for use by either Table B (except for hash key files), Table D, Table E, or Table X. The size of Tables A and C cannot be changed without reorganizing the file.

You can issue INCREASE DATASETS, INCREASE TABLEB, INCREASE TABLED, INCREASE TABLEE, and INCREASE TABLEX commands without stopping a file and bumping all users out of the file. The file may be accessed or updated at the same time while the INCREASE command is processing.

However, Model 204 handles INCREASE processing only one type at a time in succession, not simultaneously. You cannot process an INCREASE DATASETS command and an INCREASE TABLEB command at the same time.

You can increase Table B, even when the file is open and has requests compiled against it, by using the DYNAMIC option. Without this option, an INCREASE TABLEB command processes only files that are not open by any other users or subsystems. There is a small performance penalty for MP/204 users: multiprocessing is stopped for a short time while internal changes are made.

Increasing and decreasing a file, the various tables that make up a file, and the relevant table parameters are explained in detail in the File management articles, such as Managing file and table sizes.

If you are increasing the size of a table in response to a file full condition (FISTAT X'08'), reset FISTAT to X'00' after performing the INCREASE command.

However, make sure that the FISTAT X'02' bit (File is physically inconsistent) is not set. Never reset FISTAT for a physically inconsistent file.

In Model 204 7.5 and later, the file full bit (FISTAT X'08') is automatically cleared in a TBO file if Table D is increased enough so that DSIZE is greater than or equal to DPGSRES+DPGSUSED.

Privileges required

To use the INCREASE command you must have update authority to the selected file. If the file is open for read-only access, the INCREASE command is rejected with the following message:

M204.1036: UPDATES NOT PERMITTED

The INCREASE command cannot be used to increase XSIZE from zero.

See also

  • Further information about the use of INCREASE, including issues concerning exclusive file access and increasing the number of file segments, can be found in the Managing file and table sizes article.
  • The DECREASE command can be used to return unused pages, increasing FREESIZE so they can be used for another file table.