Progress
Database Administration
Guide and Reference
PROAPW Command
Starts an asynchronous page writer (APW). APWs improve database performance by performing overhead operations in the background. For more information on APWs, see Managing Performance."
SYNTAX
db-name
Specifies the database where you want to start an APW.
NOTES
- To stop an APW, disconnect it by using the PROSHUT command. You can start and stop APWs at any time without shutting down the database.
- Each APW counts as a user. You might have to increase the value of the Number of Users (-
n
) parameter to allow for APWs. However, APWs do not count as licensed users.- The optimal number depends on your application and environment. To start, use one page writer for each disk where the database resides. If data gathered from PROMON indicates that this is insufficient, add more. For more information on PROMON see the "PROMON Utility" section in Database Administration Utilities."
- 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.
- Asynchronous page writers are only available on Enterprise systems.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |