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 Manage 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.