Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Adjust Page Writer Options

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

> Figure 19–51 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

> Figure 19–51: PROMON Adjust Page Writer Options menu

> Choose one of the following options:

> - APW queue check time — Lets you 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 — Lets you 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 — Lets you dynamically adjust the value of the Page Writer Scan (-`pwscan`) parameter.

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

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095