Progress
Database Administration
Guide and Reference


PROSHUT Command

Shuts down the Progress database server and individual processes. Before you shut down the broker, have all application users quit their Progress sessions. If necessary, you can disconnect users by using the PROSHUT command’s Disconnect a User or Unconditional Shutdown parameters.

SYNTAX

Operating System
Syntax
UNIX
Windows
proshut db-name[-b
                                    | -by
                                    | -bn
                                    | -C list
                                    | -C disconnect usernum
                                    | -F
                                    | -Gw
                                    | -H host-name
                                    | -S service-name
                                    | -cpinternal codepage
                                    | -cpstream codepage
                                    ] ...

db-name

Specifies the database the server is running against.

-b

Directs PROSHUT to perform a batch shutdown. 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 PROSHUT to perform an unconditional batch shutdown and to disconnect all active users. Note that PROSHUT does not give users any notice before disconnecting them.

-bn

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

-C list

Lists all of the users connected to the database. The list is printed out to the screen without any page breaks.

-C disconnect usernum

Allows you to initiate a disconnect for the specified user. This is similar to option 1 of the PROSHUT menu.

-F

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

-Gw

For DataServers, specifies the DataServer broker to shut down.

-H host-name

Specifies the machine where the database server runs. If issuing the shutdown command from a remote machine, specify the host name.

-S service-name

Specifies the database server or broker process. If issuing the shutdown command from a remote machine, specify the service name.

-cpinternal codepage

An internationalization startup parameter that identifies the code page used in memory.

-cpstream codepage

An internationalization startup parameter that identifies the code page used for stream I/O.

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

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

The following table lists the menu options and their actions:

Option
Action
1
Prompts you for the number of the user you want to disconnect.
2
Disconnects all users and shuts down the database.
3
Prompts you to confirm your choice. If you cancel the choice, you cancel the shutdown. If you confirm the choice, PROSHUT displays the following message:
Emergency shutdown initiated...
PROSHUT marks the database for abnormal shutdown, kills all remaining processes connected to the database, and deletes shared-memory segments and semaphores. The database is in a crashed state. PROSHUT performs normal crash recovery when you restart the database and backs out any active transactions.
x
Cancels the shutdown without taking any action.

EXAMPLES


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