VIEW command: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
 
(9 intermediate revisions by 3 users not shown)
Line 4: Line 4:
<dd>Any user can specify a <var>VIEW</var> command for any parameter, except where noted. For example, only the system manager or the system administrator can specify <var>VIEW ERRORS</var>.
<dd>Any user can specify a <var>VIEW</var> command for any parameter, except where noted. For example, only the system manager or the system administrator can specify <var>VIEW ERRORS</var>.
<dt>Function
<dt>Function
<dd>Displays the current settings of one or more <var class="product">Model&nbsp;204</var> parameters or sets of parameters.
<dd>Displays the current settings of one or more [[List of Model 204 parameters|Model&nbsp;204 parameters]] or sets of parameters.
</dl>
</dl>


Line 30: Line 30:
Individual parameter names can be interspersed with parameter set names, in any order, except for <var>ERRORS</var>, which must appear last.</p>
Individual parameter names can be interspersed with parameter set names, in any order, except for <var>ERRORS</var>, which must appear last.</p>


==VIEW ERRORS==
===VIEW ERRORS===
<p>
<p>
<var>VIEW ERRORS</var> displays error messages that have been issued for SNAPs or error messages that have the <var>SAVE</var> option set. The <var>SAVE</var> option can be set by the [[MSGCTL command]]. <var>VIEW ERRORS</var> can be specified only by the system manager or system administrator. <var>VIEW ERRORS</var> is different from other <var>VIEW</var> commands in that it doesn't really display parameter values but instead displays error messages that have been issued.
<var>VIEW ERRORS</var> displays error messages that have been issued for SNAPs or error messages that have the <var>SAVE</var> option set. The <var>SAVE</var> option can be set by the [[MSGCTL command]]. <var>VIEW ERRORS</var> can be specified only by the system manager or system administrator. <var>VIEW ERRORS</var> is different from other <var>VIEW</var> commands in that it doesn't really display parameter values but instead displays error messages that have been issued.
Line 42: Line 42:
==Usage notes==
==Usage notes==
<ul>
<ul>
<li>The <var>VIEW</var> command displays the current settings of any number of <var class="product">Model&nbsp;204</var> parameters or sets of parameters.</li>
<li>The <var>VIEW</var> command displays the current settings of any number of <var class="product">Model&nbsp;204</var> parameters or sets of parameters. Parameters can be specified in any order.</li>
<p><var class="product">Model&nbsp;204</var> parameters, with exceptions such as <var>ERRLEN</var> and <var>ERRSAVE</var>, can be specified in the <var>VIEW</var> command. Parameters can be specified in any order.</p>
<p></p>
 
<li>Some parameters cannot be changed.  A small number of them can be changed with the <var>UTABLE</var> command, which is [[#utable|mentioned below]]. Others can be changed with the <var>[[RESET command|RESET]]</var> command. </li>
<p></p>
 
<li>A parameter's value can also be retrieved with the <var>[[$View]]</var> function.</li>
<p></p>


<li>You can also display the file and storage information described in the table below when you specify the following values with <var>VIEW</var>.
<li>You can also display the file and storage information described in the table below when you specify the following values with <var>VIEW</var>.
Line 52: Line 58:
<th>Information displayed</th> </tr>
<th>Information displayed</th> </tr>
    
    
<tr> <th><var>DTSLBOPR</var></th> <td>
<tr>  
TBO files: Date and time a transaction is backed out during <var>ROLL FORWARD</var> processing.
<th><var>DTSLBOPR</var></th>  
<td>TBO files: Date and time a transaction is backed out during <var>ROLL FORWARD</var> processing.
<p>
<p>
Non-TBO files: Date and time a partial transaction is applied during <var>ROLL FORWARD</var> processing.</p></td> </tr>
Non-TBO files: Date and time a partial transaction is applied during <var>ROLL FORWARD</var> processing.</p></td> </tr>
   
   
<tr> <th><var>DTSLCHKP</var></th> <td>
<tr>  
Date and time of last checkpoint rolled back to. Will be blank if the file has also been rolled forward.</td> </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>
   
   
<tr> <th><var>DTSLDKWR</var></th> <td>
<tr>  
Date and time of last DKWR</td> </tr>
<th><var>DTSLDKWR</var></th>  
<td>Date and time of last DKWR</td> </tr>
   
   
<tr> <th><var>DTSLRCVY</var></th> <td>
<tr>  
Date and time of last recovery</td> </tr>
<th><var>DTSLRCVY</var></th>  
<td>Date and time of last recovery</td> </tr>
   
   
<tr> <th><var>DTSLRFWD</var></th> <td>
<tr>  
Date and time of last <var>ROLL FORWARD</var></td> </tr>
<th><var>DTSLRFWD</var></th>  
<td>Date and time of last <var>ROLL FORWARD</var></td> </tr>
   
   
<tr> <th><var>DTSLUPDT</var></th> <td>
<tr>  
Date and time of last update</td> </tr>
<th><var>DTSLUPDT</var></th>  
<td>Date and time of last update</td> </tr>
   
   
<tr> <th><var>FIWHEN</var></th> <td>
<tr>  
Date and time <var>FISTAT</var> was reset</td> </tr>
<th><var>FIWHEN</var></th>  
<td>Date and time <var>FISTAT</var> was reset</td> </tr>
   
   
<tr> <th><var>FIWHO</var></th> <td>
<tr>  
Terminal ID that reset <var>FISTAT</var></td> </tr>   
<th><var>FIWHO</var></th>  
<td>Terminal ID that reset <var>FISTAT</var></td> </tr>   
</table></li>
</table></li>
</ul>
</ul>
Line 108: Line 122:
   
   
<tr> <th><var>USER</var></th>  
<tr> <th><var>USER</var></th>  
<td>User parameters, including those that can be reset by the user</td> </tr>
<td>User parameters.</td> </tr>
   
   
<tr> <th><var>UTABLE</var></th>  
<tr id="utable"> <th><var>UTABLE</var></th>  
<td>User table parameters that determine how complex a request you can run
<td>User table parameters that determine how complex a request you can run. See the <var>[[UTABLE command|UTABLE]]</var> command for details.
</td> </tr>   
</td> </tr>   
</table>
</table>
Line 121: Line 135:
====Viewing in Parallel Query Option/204====
====Viewing in Parallel Query Option/204====
<p>
<p>
In <var class="product">Parallel Query Option/204</var>, the <var>VIEW</var> command is not reliable for all file parameters. In remote file context, reliable <var>VIEW</var> command results are guaranteed only for the following parameters: </p>
In <var class="product">[[PQO: Overview of Parallel Query Option/204|Parallel Query Option/204]]</var>, the <var>VIEW</var> command is not reliable for all file parameters. In remote file context, reliable <var>VIEW</var> command results are guaranteed only for the following parameters: </p>


:<var>ASTRPPG</var>
:<var>ASTRPPG</var>
Line 141: Line 155:
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>
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>
<p>
For examples of remote file context <var>VIEW</var> command displays for individual file parameters, see the <var class="book">[[Media:M204_PQO204UserGuide_V75.pdf|Parallel Query Option/204 User's Guide]]</var>. </p>
For examples of remote file context <var>VIEW</var> command displays for individual file parameters, see [[PQO: Managing the PQO network#Using the VIEW command|Using the VIEW command in PQO]]. </p>
 
==See also==
<p>
<p>
For viewing command related information, see [[VIEW COMMAND command]].
For viewing command related information, see [[VIEW COMMAND command]].
</p>
</p>
<p>For a complete list of <var class="product">Model&nbsp;204</var> parameters, see [[List of Model 204 parameters]].</p>


[[Category: System administrator commands]]
[[Category: System administrator commands]]
[[Category: System manager commands]]
[[Category: System manager commands]]
[[Category:Operator commands]]
[[Category: Operator commands]]
[[Category: General user commands]]
[[Category: User commands]]
[[Category:Commands]]
[[Category:Commands]]

Latest revision as of 16:28, 22 March 2017

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] ...

Where:

parameter A Model 204 parameter.
parameter-set A set of Model 204 parameters of a particular type (see the table of parameter sets 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.

VIEW ERRORS

VIEW ERRORS displays error messages that have been issued for SNAPs or error messages that have the SAVE option set. The SAVE option can be set by the MSGCTL command. VIEW ERRORS can be specified only by the system manager or system administrator. VIEW ERRORS is different from other VIEW commands in that it doesn't really display parameter values but instead displays error messages that have been issued.

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. Parameters can be specified in any order.

  • Some parameters cannot be changed. A small number of them can be changed with the UTABLE command, which is mentioned below. Others can be changed with the RESET command.

  • A parameter's value can also be retrieved with the $View function.

  • 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.

Parameter sets viewable with VIEW
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.
UTABLE User table parameters that determine how complex a request you can run. See the UTABLE command for details.

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 Parallel Query Option/204, 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 Using the VIEW command in PQO.

See also

For viewing command related information, see VIEW COMMAND command.

For a complete list of Model 204 parameters, see List of Model 204 parameters.

Retrieved from "https://m204wiki.rocketsoftware.com/index.php?title=VIEW_command&oldid=102310"