DTS parameter: Difference between revisions
m (add link) |
(adding Usage section and text that seems to have been missed during wiki conversion) |
||
| Line 34: | Line 34: | ||
<p class="note"><b>Note:</b> During <var>[[FLOD command|FLOD]]</var>/<var>[[FILELOAD command|FILELOAD]]</var>, 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.</p> | <p class="note"><b>Note:</b> During <var>[[FLOD command|FLOD]]</var>/<var>[[FILELOAD command|FILELOAD]]</var>, 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.</p> | ||
==Usage== | |||
When DTS=0, then your user thread does no date/time stamp processing on any file. To turn DTS processing off for a file, you must stop the file and turn off the FOPT=X’10’ bit. This suspends date/time stamp processing for this file for all users. | |||
<p>Currently, there is no feature that can suspend date/time processing for some files for some users.</p> | |||
<p>Furthermore, DTS is not supported under Parallel Query Option. If you attempt a remote open of a data/time stamp file (FOPT=X’10), the following message is issued:</p> | |||
<p class="code">M204.1977: %F MAY NOT BE ACCESSED REMOTELY</p> | |||
==See also== | ==See also== | ||
Revision as of 20:35, 29 March 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. 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.
| 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. |
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 (FOPT 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.
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
When DTS=0, then your user thread does no date/time stamp processing on any file. To turn DTS processing off for a file, you must stop the file and turn off the FOPT=X’10’ bit. This suspends date/time stamp processing for this file for all users.
Currently, there is no feature that can suspend date/time processing for some files for some users.
Furthermore, DTS is not supported under Parallel Query Option. If you attempt a remote open of a data/time stamp file (FOPT=X’10), the following message is issued:
M204.1977: %F MAY NOT BE ACCESSED REMOTELY