Progress
Database Administration
Guide and Reference
Administrative Functions>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 Progress Software Technical Support.)
Figure A–40 shows a sample Adjust Page Writer Options menu.
Figure A–40: PROMON Adjust Page Writer Options Menu
Choose one of the following options:
NOTE: Though you can set the value of- APW queue check time — Lets you dynamically adjust the value of the Page Writer Queue Delay (-
pwqdelay
) parameter.-pwqdelay
, itis 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 © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |