DKUPDTWT parameter: Difference between revisions
| (3 intermediate revisions by 2 users not shown) | |||
| Line 15: | Line 15: | ||
==Description== | ==Description== | ||
<p>How long | <p>How long disk buffers, containing a file's modified pages, must have aged (in seconds) before they can be written to disk. Even after the write, the pages remain in the buffer pool for future reference until the file is closed by the last user. </p> | ||
<p>If DKUPDTWT is zero, <var class="product">Model 204</var> writes all of a file's modified pages to disk at the end of the last in-flight update of the file. The user who completed the last in-flight update waits for this disk update process to complete and for the message stating that the disk update is complete.</p> | <p>If DKUPDTWT is zero, <var class="product">Model 204</var> writes all of a file's modified pages to disk at the end of the last in-flight update of the file. The user who completed the last in-flight update waits for this disk update process to complete and for the message stating that the disk update is complete.</p> | ||
<p>If DKUPDTWT is nonzero, <var class="product">Model 204</var> delays the start of the disk update process for at least DKUPDTWT seconds, after which it can be the checkpoint pseudo subtask (CHKPST) that performs the disk update. The user who completed the last in-flight update does not have to wait for the disk update process to complete. </p> | <p>If DKUPDTWT is nonzero, <var class="product">Model 204</var> delays the start of the disk update process for at least DKUPDTWT seconds, after which it can be the checkpoint pseudo subtask (CHKPST) that performs the disk update. The user who completed the last in-flight update does not have to wait for the disk update process to complete. </p> | ||
| Line 21: | Line 21: | ||
<p>DKUPDTWT has a maximum of 60, and it also depends on the <var>[[CPTIME_parameter|CPTIME]]</var> parameter setting. If CPTIME is nonzero, DKUPDTWT must be less than or equal to CPTIME*30. </p> | <p>DKUPDTWT has a maximum of 60, and it also depends on the <var>[[CPTIME_parameter|CPTIME]]</var> parameter setting. If CPTIME is nonzero, DKUPDTWT must be less than or equal to CPTIME*30. </p> | ||
<p>The system manager can reset DKUPDTWT to zero while the online is running, and to a nonzero value as long as the CHKPST and CHKPTIMR pseudo subtasks were started during <var class="product">Model 204</var> initialization.</p> | <p>The system manager can reset DKUPDTWT to zero while the online is running, and to a nonzero value as long as the CHKPST and CHKPTIMR pseudo subtasks were started during <var class="product">Model 204</var> initialization.</p> | ||
<p>If [[Checkpoints:_Storing_before-images_of_changed_pages#Overview_of_sub-transaction_checkpoints|sub-transaction checkpointing]] is activated by setting <var>[[CPTYPE_parameter|CPTYPE]]</var> to 1, then DKUPDTWT must be set to 0</p> | |||
[[Category:System parameters]] | [[Category:System parameters]] | ||
[[Category:Parameters]] | [[Category:Parameters]] | ||
Latest revision as of 13:45, 7 July 2020
# seconds after file's last update before file is updated on disk
Summary
- Default value
- 0
- Parameter type
- System
- Where set
- On User 0's parameter line or reset by system manager
- Related products
- All
- Introduced
- Model 204 V3.2
Description
How long disk buffers, containing a file's modified pages, must have aged (in seconds) before they can be written to disk. Even after the write, the pages remain in the buffer pool for future reference until the file is closed by the last user.
If DKUPDTWT is zero, Model 204 writes all of a file's modified pages to disk at the end of the last in-flight update of the file. The user who completed the last in-flight update waits for this disk update process to complete and for the message stating that the disk update is complete.
If DKUPDTWT is nonzero, Model 204 delays the start of the disk update process for at least DKUPDTWT seconds, after which it can be the checkpoint pseudo subtask (CHKPST) that performs the disk update. The user who completed the last in-flight update does not have to wait for the disk update process to complete.
If DKUPDTWT is nonzero, the CHKPST and CHKPTIMR pseudo subtasks are started automatically at Model 204 initialization. An error message informs you if the NSUBTKS parameter is set too low to start these pseudo subtasks.
DKUPDTWT has a maximum of 60, and it also depends on the CPTIME parameter setting. If CPTIME is nonzero, DKUPDTWT must be less than or equal to CPTIME*30.
The system manager can reset DKUPDTWT to zero while the online is running, and to a nonzero value as long as the CHKPST and CHKPTIMR pseudo subtasks were started during Model 204 initialization.
If sub-transaction checkpointing is activated by setting CPTYPE to 1, then DKUPDTWT must be set to 0