Starting an APW
- Last Updated: March 12, 2022
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation

An asynchronous page writer (APW) is an optional background process that continually writes unlocked, modified database buffers to disk. An APW enhances database performance because it:
- Ensures that a steady supply of empty database buffers is available so OpenEdge RDBMS can use them when needed.
- Reduces the number of database buffers that OpenEdge RDBMS must examine before writing an unlocked, modified database buffer to disk.
- Reduces the overhead associated with checkpointing because fewer modified database buffers have to be written to disk at every checkpoint.
You can start one or more APWs. As a best practice, after you start up a database, you should start at least one APW.
The command to start an APW for a running database is:
|
Repeat this command for each APW instance you want to start.
Note:
- The APW is available only with the OpenEdge Enterprise RDBMS license.
- Applications that perform fewer updates to a database require fewer APWs.
- Applications that are read-only do not require any APW.