Kbase P117387: How to stop background writers, APWs or Watchdog when a database is running?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/02/2009 |
|
Status: Verified
GOAL:
How to stop background writer processes?
GOAL:
How to stop Asynchronous Page Writers (APW) processes connected to a database?
GOAL:
How to stop Before Image Writer (BIW) process that is connected to a database?
GOAL:
How to stop After Image Writer (AIW) process that is connected to a database?
GOAL:
How to stop Background Watchdog (WDOG) process that is connected to a database?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Background Writer processes like APWs, BIW, AIW and WDOG processes are like any other Progress client connecting to a database. If you need to stop these processes, you can do so using promon.
To stop or disconnect background page writers do the following:
1. promon dbname (Database name)
2. Select 8. Shut Down Database from the promon menu.
3. All user and background processes connected to a database will be displayed at the top part of the Shut Down screen. Background writers will have a user id of apw, biw, aiw or wdog.
4. Type 1 to select Disconnect a User from the Shut Down menu.
5. You will then be prompted for the usr number you want to disconnect. Enter the user number which is to be disconnected:
6. Enter in the usr id that you want to disconnect from the database.
Example:
If I had the following processes displayed and I wanted to disconnect the BIW, I would enter in 7 at the user number prompt.
usr pid time of login user id tty Limbo?
5 25735 Wed Jul 19 13:46:54 2006 apw no
6 25741 Wed Jul 19 13:46:57 2006 apw no
7 25744 Wed Jul 19 13:47:00 2006 biw no
8 376 Wed Jul 19 13:53:15 2006 wdog no
1 Disconnect a User
2 Unconditional Shutdown
3 Emergency Shutdown (Kill All)
x Exit
Enter choice> 1
Enter the user number which is to be disconnected: 7
The BIW process would be disconnected from the database.