VIEW command: Difference between revisions
m (Automatically generated page update) |
m (→Usage notes) |
||
Line 32: | Line 32: | ||
</p> | </p> | ||
==Usage notes== | ==Usage notes== | ||
< | <ul> | ||
<li>The VIEW command displays the current settings of any number of <var class="product">Model 204</var> parameters or sets of parameters.</p> | |||
<p><var class="product">Model 204</var> parameters, with exceptions such as ERRLEN and ERRSAVE, can be specified in the VIEW command. Parameters can be specified in any order.</p> | <p><var class="product">Model 204</var> parameters, with exceptions such as ERRLEN and ERRSAVE, can be specified in the VIEW command. Parameters can be specified in any order.</p> | ||
< | |||
<li>You can also display the file and storage information described in the table below when you specify the following values with VIEW. | |||
<table> | <table> | ||
<caption>VIEW command special parameters </caption> | <caption>VIEW command special parameters </caption> | ||
<tr> | <tr class="head"><th>Value you specify with VIEW or $VIEW</th> | ||
<th>Information displayed</th> </tr> | |||
</th> </tr> | |||
<tr> <th><var | <tr> <th><var>DTSLBOPR</var></th> <td> | ||
TBO files: Date and time a transaction is backed out during ROLL FORWARD processing. | |||
</var></th> <td> | <p> | ||
Non-TBO files: Date and time a partial transaction is applied during ROLL FORWARD processing.</p></td> </tr> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>DTSLCHKP</var></th> <td> | ||
Date and time of last checkpoint rolled back to. Will be blank if the file has also been rolled forward.</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>DTSLDKWR</var></th> <td> | ||
Date and time of last DKWR</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>DTSLRCVY</var></th> <td> | ||
Date and time of last recovery</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>DTSLRFWD</var></th> <td> | ||
Date and time of last ROLL FORWARD</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>DTSLUPDT</var></th> <td> | ||
Date and time of last update</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>FIWHEN</var></th> <td> | ||
Date and time FISTAT was reset</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>FIWHO</var></th> <td> | ||
Terminal ID that reset FISTAT</td> </tr> | |||
</var></th> <td> | </table></li> | ||
</ul> | |||
</td> </tr> | |||
====Viewing parameter sets==== | |||
</table> | <p> | ||
< | One or more sets of parameters also can be specified in the VIEW command. Valid set names are listed in the following table.</p> | ||
<p>One or more sets of parameters also can be specified in the VIEW command. Valid set names are listed in the following table.</p> | |||
<table> | <table> | ||
<caption>Parameter sets viewable with VIEW</caption> | <caption>Parameter sets viewable with VIEW</caption> | ||
<tr class="head"> <th>Set</th> | |||
<tr> <th | <th>Meaning</th> </tr> | ||
</th> </tr> | |||
<tr> <th><var | <tr> <th><var>ALL</var></th> <td> | ||
All parameters</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>CWAIT</var></th> <td> | ||
System parameters associated with the <var class="product">Model 204</var> scheduler</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>ERRORS</var></th> | ||
<td>Error messages that accompany SNAPs or error messages that have the SAVE option set. The SAVE option can be set by the MSGCTL command. (This parameter can be specified only by the system manager or system administrator.) </td> </tr> | |||
</var></th> <td>Error messages that accompany SNAPs or error messages that have the SAVE option set. The SAVE option can be set by the MSGCTL command. (This parameter can be specified only by the system manager or system administrator.) </td> </tr> | |||
<tr> <th><var | <tr> <th><var>FPARMS</var></th> <td> | ||
File characteristic parameters</td> </tr> | |||
</var></th> <td> | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>TABLES</var></th> | ||
<td>File table parameters</td> </tr> | |||
</var></th> <td | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>SYSTEM</var></th> | ||
<td>System parameters</td> </tr> | |||
</var></th> <td | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>USER</var></th> | ||
<td>User parameters, including those that can be reset by the user</td> </tr> | |||
</var></th> <td | |||
</td> </tr> | |||
<tr> <th><var | <tr> <th><var>UTABLE</var></th> | ||
<td>User table parameters that determine how complex a request you can run | |||
</var></th> <td | </td> </tr> | ||
</td> </tr> | |||
</table> | </table> | ||
<p>You can display these values individually by specifying them by name in the VIEW command (for example, VIEW STORMAX or when the ALL or the SYSTEM option of the VIEW command is selected). </p> | <p> | ||
<p>The VIEW FPARMS and VIEW TABLES commands display information about the default file. They must be issued in file context-that is, the current default must be a file, not a group. If these commands are issued in group context, the null string is returned. If a user does not have the correct privilege, use of the VIEW command to display restricted file parameters generates an error message.</p> | You can display these values individually by specifying them by name in the VIEW command (for example, VIEW STORMAX or when the ALL or the SYSTEM option of the VIEW command is selected). </p> | ||
====Parallel Query Option/204==== | <p> | ||
<p>In PQO, the VIEW command is not reliable for all file parameters. In remote file context, reliable VIEW command results are guaranteed only for the following parameters: </p> | The VIEW FPARMS and VIEW TABLES commands display information about the default file. They must be issued in file context-that is, the current default must be a file, not a group. If these commands are issued in group context, the null string is returned. If a user does not have the correct privilege, use of the VIEW command to display restricted file parameters generates an error message.</p> | ||
====Viewing in Parallel Query Option/204==== | |||
< | <p> | ||
In PQO, the VIEW command is not reliable for all file parameters. In remote file context, reliable VIEW command results are guaranteed only for the following parameters: </p> | |||
< | |||
:<var>ASTRPPG</var> | |||
< | :<var>ATRPG</var> | ||
:<var>CURFILE</var> | |||
< | :<var>CURLOC</var> | ||
:<var>FICREATE</var> | |||
:<var>FILEORG</var> | |||
:<var>FITRANS</var> | |||
:<var>HASHKEY</var> | |||
< | |||
< | |||
< | |||
:<var>LOCATION</var> | |||
:<var>OPENCTL</var> | |||
< | :<var>RECSCTY</var> | ||
< | :<var>SORTKEY</var> | ||
< | |||
<p> | |||
Similarly, for <var>VIEW FPARMS</var> or <var>VIEW TABLES</var> commands in remote file context, correct information is guaranteed only for the file parameters listed in the previous table. </p> | |||
< | <p> | ||
< | For examples of remote file context <var>VIEW</var> command displays for individual file parameters, see the <var class="book">Parallel Query Option/204 User's Guide</var>. </p> | ||
</var> | |||
<p>For examples of remote file context VIEW command displays for individual file parameters, see the <var>Parallel Query Option/204 User's Guide</var>. </p> | |||
====Viewing the ESIZE parameter across Model 204 versions==== | ====Viewing the ESIZE parameter across Model 204 versions==== | ||
<p>If the file was created and initialized in a <var class="product">Model 204</var> release prior to V6R1 | <p> | ||
If the file was created and initialized in a <var class="product">Model 204</var> release prior to V6R1, you would see similar results from the following <var>VIEW</var> commands:</p> | |||
<p class="code">IN TEST VIEW FICREATE | <p class="code">IN TEST VIEW FICREATE | ||
FICREATE 3 RELEASE 9.0 (OR LATER) CREATE FORMAT | FICREATE 3 RELEASE 9.0 (OR LATER) CREATE FORMAT | ||
IN TEST VIEW ESIZE | IN TEST VIEW ESIZE | ||
M204.2671: PARAMETER ESIZE IS NOT SUPPORTED BEFORE VERSION 6.1 | M204.2671: PARAMETER ESIZE IS NOT SUPPORTED BEFORE VERSION 6.1 | ||
</p><p> | </p> | ||
<p> | |||
If the file was created in V5R1 but initialized in V6R1: </p> | |||
<p class="code">IN TEST VIEW FICREATE | <p class="code">IN TEST VIEW FICREATE | ||
FICREATE 3 RELEASE 9.0 (OR LATER) CREATE FORMAT | FICREATE 3 RELEASE 9.0 (OR LATER) CREATE FORMAT | ||
IN TEST VIEW ESIZE | IN TEST VIEW ESIZE | ||
M204.2671: PARAMETER ESIZE IS NOT SUPPORTED BEFORE VERSION 6.1 | M204.2671: PARAMETER ESIZE IS NOT SUPPORTED BEFORE VERSION 6.1 | ||
</p><p> | </p> | ||
<p> | |||
If the file was created and initialized in V6R1: </p> | |||
<p class="code">IN TEST610 VIEW FICREATE | <p class="code">IN TEST610 VIEW FICREATE | ||
FICREATE 6 RELEASE V6R1.0 CREATE FORMAT | FICREATE 6 RELEASE V6R1.0 CREATE FORMAT | ||
Line 218: | Line 157: | ||
<b>ESIZE 20</b> PAGES IN TABLE E | <b>ESIZE 20</b> PAGES IN TABLE E | ||
</p> | </p> | ||
====Viewing the EHIGHPG parameter==== | ====Viewing the EHIGHPG parameter==== | ||
<p>You can see the value of the EHIGHPG parameter by issuing a VIEW command. </p> | <p> | ||
You can see the value of the EHIGHPG parameter by issuing a <var>VIEW</var> command. </p> | |||
[[Category: System administrator commands]] | [[Category: System administrator commands]] | ||
[[Category: System manager commands]] | [[Category: System manager commands]] | ||
[[Category: General user commands]] | [[Category: General user commands]] | ||
[[Category:Commands]] | [[Category:Commands]] |
Revision as of 22:36, 21 February 2014
Summary
- Privileges
- Any user can specify a VIEW command for any parameter, except where noted. For example, only the system manager or the system administrator can specify VIEW ERRORS.
- Function
- Displays the current settings of one or more Model 204 parameters or sets of parameters
Syntax
VIEW [{parameter | parameter-set} [{parameter | parameter-set}]]
Where:
parameter | is a Model 204 parameter. |
---|---|
parameter-set | is a set of Model 204 parameters of a particular type (see the discussion below). |
Syntax notes
If no parameters or parameter sets are specified in the command, Model 204 displays the settings of all parameters.
Individual parameter names can be interspersed with parameter set names, in any order, except for ERRORS, which must appear last.
Example
VIEW OUTLPP OUTLPP 60 OUTPUT LINES PER PAGE
Usage notes
- The VIEW command displays the current settings of any number of Model 204 parameters or sets of parameters.
Model 204 parameters, with exceptions such as ERRLEN and ERRSAVE, can be specified in the VIEW command. Parameters can be specified in any order.
- You can also display the file and storage information described in the table below when you specify the following values with VIEW.
VIEW command special parameters Value you specify with VIEW or $VIEW Information displayed DTSLBOPR TBO files: Date and time a transaction is backed out during ROLL FORWARD processing.
Non-TBO files: Date and time a partial transaction is applied during ROLL FORWARD processing.
DTSLCHKP Date and time of last checkpoint rolled back to. Will be blank if the file has also been rolled forward. DTSLDKWR Date and time of last DKWR DTSLRCVY Date and time of last recovery DTSLRFWD Date and time of last ROLL FORWARD DTSLUPDT Date and time of last update FIWHEN Date and time FISTAT was reset FIWHO Terminal ID that reset FISTAT
Viewing parameter sets
One or more sets of parameters also can be specified in the VIEW command. Valid set names are listed in the following table.
Set | Meaning |
---|---|
ALL | All parameters |
CWAIT | System parameters associated with the Model 204 scheduler |
ERRORS | Error messages that accompany SNAPs or error messages that have the SAVE option set. The SAVE option can be set by the MSGCTL command. (This parameter can be specified only by the system manager or system administrator.) |
FPARMS | File characteristic parameters |
TABLES | File table parameters |
SYSTEM | System parameters |
USER | User parameters, including those that can be reset by the user |
UTABLE | User table parameters that determine how complex a request you can run |
You can display these values individually by specifying them by name in the VIEW command (for example, VIEW STORMAX or when the ALL or the SYSTEM option of the VIEW command is selected).
The VIEW FPARMS and VIEW TABLES commands display information about the default file. They must be issued in file context-that is, the current default must be a file, not a group. If these commands are issued in group context, the null string is returned. If a user does not have the correct privilege, use of the VIEW command to display restricted file parameters generates an error message.
Viewing in Parallel Query Option/204
In PQO, the VIEW command is not reliable for all file parameters. In remote file context, reliable VIEW command results are guaranteed only for the following parameters:
- ASTRPPG
- ATRPG
- CURFILE
- CURLOC
- FICREATE
- FILEORG
- FITRANS
- HASHKEY
- LOCATION
- OPENCTL
- RECSCTY
- SORTKEY
Similarly, for VIEW FPARMS or VIEW TABLES commands in remote file context, correct information is guaranteed only for the file parameters listed in the previous table.
For examples of remote file context VIEW command displays for individual file parameters, see the Parallel Query Option/204 User's Guide.
Viewing the ESIZE parameter across Model 204 versions
If the file was created and initialized in a Model 204 release prior to V6R1, you would see similar results from the following VIEW commands:
IN TEST VIEW FICREATE FICREATE 3 RELEASE 9.0 (OR LATER) CREATE FORMAT IN TEST VIEW ESIZE M204.2671: PARAMETER ESIZE IS NOT SUPPORTED BEFORE VERSION 6.1
If the file was created in V5R1 but initialized in V6R1:
IN TEST VIEW FICREATE FICREATE 3 RELEASE 9.0 (OR LATER) CREATE FORMAT IN TEST VIEW ESIZE M204.2671: PARAMETER ESIZE IS NOT SUPPORTED BEFORE VERSION 6.1
If the file was created and initialized in V6R1:
IN TEST610 VIEW FICREATE FICREATE 6 RELEASE V6R1.0 CREATE FORMAT IN TEST610 VIEW ESIZE ESIZE 20 PAGES IN TABLE E
Viewing the EHIGHPG parameter
You can see the value of the EHIGHPG parameter by issuing a VIEW command.