Progress
Database Administration
Guide and Reference


Starting and Stopping an APW

A database can have between zero and nine APWs running simultaneously. The optimal number is highly 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, plus one additional APW. Applications that perform fewer changes to a database require fewer APWs.

NOTE: If you perform no updates, no page writers are required.

To start an APW process, use Progress Explorer or enter the following command on the local machine:

proapw db-name  

Each APW counts as a process connected to a database and uses resources associated with a user. You might have to increase the value of the Number of Users (-n) parameter to allow for APWs. However, APWs are not counted as licensed users.

Stop an APW by disconnecting the process with the PROSHUT command.

For detailed information on the PROAPW and PROSHUT commands, see Startup and Shutdown Commands."


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095