DTS parameter: Difference between revisions
(→Usage) |
|||
| Line 42: | Line 42: | ||
<li>If <var>DTS</var> is 0, your user thread does no date/time stamp processing on any file. To turn <var>DTS</var> processing off for a file, you must stop the file and turn off the <var>FOPT</var> X'10' bit. This suspends date/time stamp processing for this file for all users. | <li>If <var>DTS</var> is 0, your user thread does no date/time stamp processing on any file. To turn <var>DTS</var> processing off for a file, you must stop the file and turn off the <var>FOPT</var> X'10' bit. This suspends date/time stamp processing for this file for all users. | ||
<p> | <p> | ||
Currently, there is no feature that can suspend date/time processing for some files for some users.</p></li> | Currently, there is no feature that can suspend date/time processing for some files for some users, or suspend date/time processing for all users.</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') will fail.</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') will fail.</li> | ||
Revision as of 22:02, 1 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 will be ignored and DTS=1 will be assumed.
- When 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 DTS is 0, 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, or suspend date/time processing for all users.
- DTS is not supported under Parallel Query Option. Any attempt to open a remote date/time stamp file (FOPT X'10') will fail.