Try OpenEdge Now
skip to main content
Configuration
Configuring OpenEdge Databases : Viewing the various database configuration properties : Database configuration properties : Background writers database configuration properties
 
Background writers database configuration properties
Table 5. Background writers database configuration properties
Property
Description
Watchdog process
Start the Watchdog process automatically when the database starts.
The check box is selected by default.
Asynchronous page writers
The number of Asynchronous Page Writer (APW) processes to start.
A database can have between zero and nine APWs running simultaneously. The optimal number is dependent on your application and environment.
To start, use one page writer for each disk where the database resides. If this is insufficient, add more.
For an application that performs many updates, start one APW for each disk containing your database, and add one additional APW. Applications that perform fewer changes to a database require fewer APWs. If an application performs no updates, no page writers are required.
The default value is 1.
Before image process
Start a Before-imaging process automatically when the database starts.
The check box is selected by default.
Before image stall
Send a message to the log file when the recovery log threshold is reached, preventing emergency shutdown. (For details about the -bistall startup parameter, see OpenEdge Data Management: Database Administration.)
The check box is cleared by default.
Before image buffers
The number of before-image buffers to use.
This property is useful only when running the before-image writer (BIW). The BIW continually writes the filled before-image buffers to disk, making the buffers available to other client and server processes. Without a BIW writing the buffers, any gain from increasing the number of buffers is negligible.
The default value is 5.
Before image threshold
The maximum size to which BI files can grow as a percentage of the largest possible recovery log file. (For details about the -bithold startup parameter, see OpenEdge Data Management: Database Administration.)
The default value is 3.
Before image delay writes
A positive value that you specify to delay OpenEdge from synchronously writing out to disk the last before-image (BI) file records at the end of each transaction.
On UNIX systems using shared memory, the value also specifies the interval at which the broker process wakes up to make sure all BI file changes have been written to disk.
The default value is 3.
Before image cluster age
The number of seconds before OpenEdge reuses a before-image cluster.
The default value is 60.
Group delay
The number of milliseconds a transaction waits before committing.
After image process
Start an After-imaging process automatically when the database starts.
The check box is cleared by default.
After image stall
Suspend database activity if all the after-image (AI) files are filled.
By default, if all the AI files are filled and the database cannot switch to an empty one, the database shuts down. With AI stall, you can suspend database activity, back up the full after-image file, and mark it as empty.
The check box is cleared by default.
After image buffers
The number of after-image buffers to use.
This parameter is useful only when running the after-image writer (AIW) process because the AIW writes the filled after-image buffers to disk, making the buffers available to other client and server processes.
The default value is 5.