PROAIW command

Starts the after-image writer (AIW) process.

Syntax

proaiw db-name

Parameters

db-name

Specifies the database where you want to start the AIW process.

The AIW improves performance by writing notes to the after-imaging file. For more information on the AIW, see Managing Performance.

Notes

To stop the AIW, disconnect it by using the PROSHUT command. You can start and stop the AIW at any time without shutting down the database.

The AIW counts as one user. You might have to increment the value of the Number of Users (-n) parameter to allow for the AIW. However, the AIW does not count as a licensed user.

You can increase the number of buffers in the after-image buffer pool by using the After-image Buffers (-aibufs) parameter. Increasing the number of buffers when running an AIW increases the availability of empty buffers to client and server processes. Increasing the After-image Buffers parameter has no effect if the AIW is not running.

After-image writers are only available on Enterprise systems.