media/image7.png

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:
proapw db-name

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.