Adjust Page Writer Options

Database Administration

Reference : PROMON Utility : R&D Administrative Functions : Adjust Page Writer Options

Lets you manually override APW behavior. (This is rarely necessary. Do not change these options unless directed to do so by Technical Support.)

PROMON Adjust Page Writer Options menu

The following shows a sample Adjust Page Writer Options menu.

01/25/02        OpenEdge Monitor (R&D)
16:19:34        Adjust Page Writer Options

               1. APW queue check time:        100 milliseconds
               2. APW buffers scan time:       1 seconds
               3. APW buffers per scan:        1
               4. APW writes per scan:         25

Choose one of the following options:

APW queue check time — Allows you to dynamically adjust the value of the Page Writer Queue Delay (-pwqdelay) parameter.

Note: Though you can set the value of -pwqdelay, it is a self-tuning parameter. When the database encounters heavy loads, -pwqdelay decreases its value so that the APW writes more often. When the demand on the database lessens, -pwqdelay increases its value so that the APW writes less often. The default value, in milliseconds, for -pwqdelay is 100.

APW buffers scan time — Allows you to dynamically adjust the value of the Page Writer Scan Delay (-pwsdelay) parameter. The default value, in seconds, for -pwsdelay is 1.

APW buffers per scan — Enables you to dynamically adjust the value of the Page Writer Scan (-pwscan) parameter.

APW writes per scan — Enables you to dynamically adjust the value of the Page Writer Maximum Buffers (-pwwmax) parameter.