DTS parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Added a Note: for FLOD/FILELOAD processing)
m (misc formatting)
 
(17 intermediate revisions by 4 users not shown)
Line 11: Line 11:
<dd>All
<dd>All
<dt>Introduced
<dt>Introduced
<dd><var class="product">Model 204 V7.4</var>
<dd><var class="product">Model 204 V7.1</var>
</dl>
</dl>
==Description==
==Description==
<p>Enables date/time stamp processing when set to 1. A system manager can reset DTS to zero to disable automatic date/time stamps. Turning off the date/time stamp feature does not imply that you cannot update any field, including the date/time stamp field; it simply stops automatic updates to the date/time stamp field.</p>
<p>
Enables [[Adding a date-time stamp field#Overview of the date-time stamp feature|date/time stamp processing]] when set to 1. System managers can reset <var>DTS</var> to 0 to disable automatic date/time stamps. When <var>DTS</var> is 0, if you have file manager privileges, you can update a <var>DTSFN</var> field with values of your choosing.</p>
 
<table>
<table>
<tr><th>Value</th> <th>Behavior</th></tr>
<tr class="head"><th>Value</th> <th>Behavior</th></tr>
<tr><th align="right"><var>1 </var></th><td>For date/time stamp files, transactions participate in DTS updating. The date/time stamp field of an updated record is automatically updated at the beginning of COMMIT processing. <p>This is the default setting for the parameter.</p>
<tr><th align="right"><var>1 </var></th><td>For date/time stamp files, transactions participate in DTS updating. The date/time stamp field of an updated record is automatically updated at the beginning of <var>COMMIT</var> processing.  
<p>
This is the default setting for the parameter.</p>
</td></tr>
</td></tr>
<tr><th align="right"><var>0 </var></th><td>Transactions do not participate in DTS updating. When a transaction does not participate in DTS processing, the date/time stamp field will not be updated on records that are themselves updated.  
 
<tr><th align="right"><var>0 </var></th>
<td>Transactions do not participate in DTS updating. When a transaction does not participate in DTS processing, the date/time stamp field will not be updated on records that are themselves updated.  
</td></tr>
</td></tr>
</table>
</table>
<p>The DTS parameter may be reset only by a user with system manager privileges. In addition, the user must have file manager privileges for any DTS-enabled (<var>[[FOPT parameter|FOPT]]</var> X'10') files opened, either before or after DTS is reset to 0. Turning off the DTS parameter affects updates only to date/time stamp files, so no special restrictions were placed on the file with no date/time stamp.</p>


<p><b>Note:</b> During FLOD/FILELOAD, the DTS field, if one is defined to the file, is not updated. This means that a new DTS field defined as part of a file reorg will not have a value calculated during the reorg.  Existing DTS fields are only added from TAPEI input and are not automatically updated by the DTS feature.</p>
<ul>
<li>You must be a system manager to reset the <var>DTS</var> parameter. You can reset <var>DTS</var> for your thread only.
<p>
If <code>DTS=0</code> is set in the CCAIN for the Online, it is ignored and <code>DTS=1</code> is assumed, and a warning message is written to the audit trail.</p></li>
 
<li>If you are resetting <var>DTS</var> to 0, any open files with the <var>[[FOPT parameter|FOPT]]</var> parameter X'10' bit on must have been opened with file manager privileges, or the <code>RESET DTS</code> will fail.</li>
 
<li>If the value of the <var>DTS</var> parameter is 0 on a thread, subsequent opens of <var>FOPT</var> X'10' files must obtain file manager privileges, or the <code>OPEN FILE <i>filename</i></code> will fail.</li>
</ul>
 
<p class="note"><b>Note:</b> During <var>[[FLOD command|FLOD]]</var>/<var>[[FILELOAD command|FILELOAD]]</var>, the <var>DTS</var> field, if one is defined to the file, is not updated. This means that a new <var>DTS</var> field defined as part of a file reorganization will not have a value calculated during the reorganization.  Existing <var>DTS</var> fields are only added from TAPEI input, and they are not automatically updated by the DTS feature.</p>
 
==Usage==
<ul>
<li>If you reset <var>DTS</var> to 0 on your thread (for example, in a [[BATCH204]] or [[Program Communication facilities#BATCH2 facility|BATCH2]] job, or any Online thread), no date/time stamp processing occurs for any file accessed on this thread. </li>
 
<li>If you have file manager privileges for a date/time stamp file, you can turn DTS processing off by resetting <var>FOPT</var> to turn off the X'10' bit. This suspends date/time stamp processing for this file for all users.
<p>
Currently, the <var>DTS</var> parameter cannot suspend automatic date/time stamp processing for all files in an Online; that is, the <code>DTS=1</code> default of the Online cannot be <var>SET</var> or <var>RESET</var> to <code>DTS=0</code>.</p></li>
 
<li><var>DTS</var> is not supported under [[PQO|Parallel Query Option]]. Any attempt to open a remote date/time stamp file (<var>FOPT</var> X'10') fails.</li>
</ul>
 
==See also==
<ul>
<li>[[Setting up the date-time stamp field]] </li>
<li>[[Adding a date-time stamp field]] </li>
</ul>
 
[[Category:User parameters]]
[[Category:User parameters]]
[[Category:Parameters]]
[[Category:Parameters]]

Latest revision as of 19:18, 3 August 2017

Date time stamp updates (1=automatic, 0=bypassed)

Summary

Default value
1
Parameter type
User
Where set
Reset by system manager
Related products
All
Introduced
Model 204 V7.1

Description

Enables date/time stamp processing when set to 1. System managers can reset DTS to 0 to disable automatic date/time stamps. When DTS is 0, if you have file manager privileges, you can update a DTSFN field with values of your choosing.

Value Behavior
1 For date/time stamp files, transactions participate in DTS updating. The date/time stamp field of an updated record is automatically updated at the beginning of COMMIT processing.

This is the default setting for the parameter.

0 Transactions do not participate in DTS updating. When a transaction does not participate in DTS processing, the date/time stamp field will not be updated on records that are themselves updated.
  • You must be a system manager to reset the DTS parameter. You can reset DTS for your thread only.

    If DTS=0 is set in the CCAIN for the Online, it is ignored and DTS=1 is assumed, and a warning message is written to the audit trail.

  • If you are resetting DTS to 0, any open files with the FOPT parameter X'10' bit on must have been opened with file manager privileges, or the RESET DTS will fail.
  • If the value of the DTS parameter is 0 on a thread, subsequent opens of FOPT X'10' files must obtain file manager privileges, or the OPEN FILE filename will fail.

Note: During FLOD/FILELOAD, the DTS field, if one is defined to the file, is not updated. This means that a new DTS field defined as part of a file reorganization will not have a value calculated during the reorganization. Existing DTS fields are only added from TAPEI input, and they are not automatically updated by the DTS feature.

Usage

  • If you reset DTS to 0 on your thread (for example, in a BATCH204 or BATCH2 job, or any Online thread), no date/time stamp processing occurs for any file accessed on this thread.
  • If you have file manager privileges for a date/time stamp file, you can turn DTS processing off by resetting FOPT to turn off the X'10' bit. This suspends date/time stamp processing for this file for all users.

    Currently, the DTS parameter cannot suspend automatic date/time stamp processing for all files in an Online; that is, the DTS=1 default of the Online cannot be SET or RESET to DTS=0.

  • DTS is not supported under Parallel Query Option. Any attempt to open a remote date/time stamp file (FOPT X'10') fails.

See also