Progress
Database Administration
Guide and Reference


PROSHUT Command

To shut down a Progress database server with the PROSHUT command, enter one of the following:

proshut db-name [ -b | -by | -bn | -H host-name | -S service-name 
                                      -F | -Gw  

db-name

Specifies the database the server is running against.

-b

Indicates a batch shutdown will be performed. When no client is connected, the database automatically shuts down. When one or more clients are connected, PROSHUT prompts the user to enter “yes” to perform an unconditional batch shutdown and to disconnect all active users; or “no” to perform a batch shutdown only if there are no active users. The -b parameter combines the functionality of the -by or -bn parameters.

-by

Directs the broker to perform an unconditional batch shutdown and to disconnect all active users.

-bn

Directs the broker to perform a batch shutdown only if there are no active users.

-H host-name

Specifies the machine where the database server runs. You must specify the host name if you issue the shutdown command from a machine other than the host.

-S service-name

Specifies the database server or broker process service name. A TCP network requires the -S parameter.

-F

Forces an emergency shutdown. To use this parameter, you must run PROSHUT on the machine where the server resides, and on UNIX systems. This parameter is not applicable for remote shutdowns or DataServer shutdowns.

CAUTION: Using -by with -F causes an emergency shutdown.

-Gw

For DataServers, specifies the DataServer broker to shut down.

For complete PROSHUT syntax, see the "PROSHUT Command" section in Startup and Shutdown Commands."

When you enter the PROSHUT command without the -by, -bn, or -F parameters, the PROSHUT menu appears:

                          1 Disconnect a User 
                          2 Unconditional Shutdown 
                          3 Emergency Shutdown (Kill All) 
                          x Exit 

Table 5–1 lists the PROSHUT menu options and their actions.

Table 5–1: PROSHUT Menu Options 
Option
Action
1
Prompts you for the number of the user you want to disconnect.
2
Stops all users and shuts down the database. If you have a shared-memory system with multiple users, Progress stops all servers. To stop a specific server process, use the appropriate operating system command.
3
Prompts you to confirm your choice. If you cancel the choice, you cancel the shutdown. If you confirm the choice, PROSHUT waits for five seconds before taking any action, then displays the following message:
Emergency shutdown initiated...
PROSHUT marks the database for abnormal shutdown and signals all processes to exit. After 10 more seconds, PROSHUT kills all remaining processes connected to the database, and deletes shared-memory segments and semaphores. The database is in a crashed state. Progress performs normal crash recovery when you restart the database and backs out any active transactions.
This option is available only if the database is on the same machine where you are logged in.
x
Cancels the shutdown without taking any action.

If you want to execute the shutdown command noninteractively and avoid the PROSHUT menu, issue the PROSHUT command using either of the parameters described in Table 5–2.

Table 5–2: PROSHUT Parameters 
Parameter
Action
Kill Users (-by)
Unconditional batch shutdown; kills all active users.
Proceed If No Users (-bn)
Batch shutdown only if there are no active users.

In a TCP/IP network, when using the shutdown command from a machine other than the host, you must use the Host Name (-H) and Service Name (-S) parameters. The Host Name is the machine where the database server is running. The Service Name is the name of the database server or broker process, as defined in the /etc/services file on UNIX. For example, the following command shuts down the sports database from a remote machine in a BSD UNIX network:

proshut sports -H host-name -S sports-broker -by 


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