VIEW command: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Automatically generated page update)
 
Line 32: Line 32:
</p>
</p>
==Usage notes==
==Usage notes==
<p>The VIEW command displays the current settings of any number of <var class="product">Model&nbsp;204</var> parameters or sets of parameters.</p>
<ul>
<li>The VIEW command displays the current settings of any number of <var class="product">Model&nbsp;204</var> parameters or sets of parameters.</p>
<p><var class="product">Model&nbsp;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&nbsp;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>You can also display the file and storage information described in the table below when you specify the following values with VIEW.</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> <th>
<tr class="head"><th>Value you specify  with VIEW or $VIEW</th>  
<p>Value you specify  with VIEW or $VIEW</p>
<th>Information displayed</th> </tr>
</th> <th>
<p> Information displayed</p>
</th> </tr>
    
    
<tr> <th><var>
<tr> <th><var>DTSLBOPR</var></th> <td>
<p>DTSLBOPR</p>
TBO files: Date and time a transaction is backed out during ROLL FORWARD processing.
</var></th> <td>
<p>
<p>TBO files: Date and time a transaction is backed out during ROLL FORWARD processing.</p>
Non-TBO files: Date and time a partial transaction is applied during ROLL FORWARD processing.</p></td> </tr>
<p>Non-TBO files: Date and time a partial transaction is applied during ROLL FORWARD processing.</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>DTSLCHKP</var></th> <td>
<p>DTSLCHKP</p>
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>
<p>Date and time of last checkpoint rolled back to. Will be blank if the file has also been rolled forward.</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>DTSLDKWR</var></th> <td>
<p>DTSLDKWR</p>
Date and time of last DKWR</td> </tr>
</var></th> <td>
<p>Date and time of last DKWR</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>DTSLRCVY</var></th> <td>
<p>DTSLRCVY</p>
Date and time of last recovery</td> </tr>
</var></th> <td>
<p>Date and time of last recovery</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>DTSLRFWD</var></th> <td>
<p>DTSLRFWD</p>
Date and time of last ROLL FORWARD</td> </tr>
</var></th> <td>
<p>Date and time of last ROLL FORWARD</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>DTSLUPDT</var></th> <td>
<p>DTSLUPDT</p>
Date and time of last update</td> </tr>
</var></th> <td>
<p>Date and time of last update</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>FIWHEN</var></th> <td>
<p>FIWHEN</p>
Date and time FISTAT was reset</td> </tr>
</var></th> <td>
<p>Date and time FISTAT was reset</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>FIWHO</var></th> <td>
<p>FIWHO</p>
Terminal ID that reset FISTAT</td> </tr>
</var></th> <td>
</table></li>
<p>Terminal ID that reset FISTAT</p>
</ul>
</td> </tr>
 
 
====Viewing parameter sets====
</table>
<p>
<p>Parameter sets</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>
<p>Set</p>
</th> <th>
<p>Meaning</p>
</th> </tr>
    
    
<tr> <th><var>
<tr> <th><var>ALL</var></th> <td>
<p>ALL</p>
All parameters</td> </tr>
</var></th> <td>
<p>All parameters</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>CWAIT</var></th> <td>
<p>CWAIT</p>
System parameters associated with the <var class="product">Model&nbsp;204</var> scheduler</td> </tr>
</var></th> <td>
<p>System parameters associated with the <var class="product">Model&nbsp;204</var> scheduler</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>ERRORS</var></th>  
<p>ERRORS</p>
<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>
<p>FPARMS</p>
File characteristic parameters</td> </tr>
</var></th> <td>
<p>File characteristic parameters</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>TABLES</var></th>  
<p>TABLES</p>
<td>File table parameters</td> </tr>
</var></th> <td>
<p>File table parameters</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>SYSTEM</var></th>  
<p>SYSTEM</p>
<td>System parameters</td> </tr>
</var></th> <td>
<p>System parameters</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>USER</var></th>  
<p>USER</p>
<td>User parameters, including those that can be reset by the user</td> </tr>
</var></th> <td>
<p>User parameters, including those that can be reset by the user</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>UTABLE</var></th>  
<p>UTABLE</p>
<td>User table parameters that determine how complex a request you can run
</var></th> <td>
</td> </tr>  
<p>User table parameters that determine how complex a request you can run</p>
</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>
<table>
 
   
====Viewing in Parallel Query Option/204====
<tr> <th>
<p>
<p>Parameter </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>
</th> <th>
 
<p>Parameter </p>
:<var>ASTRPPG</var>
</th> <th>
:<var>ATRPG</var>
<p>Parameter </p>
:<var>CURFILE</var>
</th> <th>
:<var>CURLOC</var>
<p>Parameter</p>
 
</th> </tr>
:<var>FICREATE</var>
 
:<var>FILEORG</var>
<tr> <th><var>
:<var>FITRANS</var>
<p>ASTRPPG </p>
:<var>HASHKEY</var>
</var></th> <td>
<p>ATRPG </p>
</td> <td>
<p>CURFILE </p>
</td> <td>
<p>CURLOC</p>
</td> </tr>
   
   
<tr> <th><var>
:<var>LOCATION</var>
<p>FICREATE </p>
:<var>OPENCTL</var>
</var></th> <td>
:<var>RECSCTY</var>
<p>FILEORG </p>
:<var>SORTKEY</var>
</td> <td>
 
<p>FITRANS </p>
<p>
</td> <td>
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>HASHKEY</p>
<p>
</td> </tr>
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>
 
<tr> <th><var>
<p>LOCATION </p>
</var></th> <td>
<p>OPENCTL </p>
</td> <td>
<p>RECSCTY </p>
</td> <td>
<p>SORTKEY</p>
</td> </tr>
 
</table>
<p>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. </p>
<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&nbsp;204</var> release prior to V6R1.0, you would see similar results to the following VIEW commands:</p>
<p>
If the file was created and initialized in a <var class="product">Model&nbsp;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> If the file was created in V5R1 but initialized in V6R1.0: </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> If the file was created and initialized in V6R1.0: </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.

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