Progress
Database Administration
Guide and Reference


PROMON Shut Down Database Option

You can use the PROMON utility to stop the database or disconnect any subset of users.

Follow these steps to shut down a database using PROMON:

  1. Enter the following PROMON command:
  2. promon db-name 
    

    When you start the monitor, the Database Monitor main menu appears:

    Progress MONITOR 
    Database: PROGRESS/WRK/sports2000 
    1.  User Control 
    2.  Locking and Waiting Statistics 
    3.  Block Access 
    4.  Record Locking Table 
    5.  Activity 
    6.  Shared Resources 
    7.  Database Status 
    8.  Shut Down Database 
    T.  Transaction Control 
    L.  Resolve Limbo Transactions 
    C.  Coordinator Information 
    M   Modify Defaults 
    Q.  Quit 
    Enter your selection: 
    

  3. Choose option 8, Shut Down Database.
  4. The following figure shows an example of this option’s output:

    Enter your selection:  8 
    Usr    PID      Time of login     Userid  tty             Limbo? 
    1      6358     Dec 14 15:10:52   sue     /dev/ttyp0      no 
    4      7007     Dec 14 15:25:09   mary    /dev/ttyp5      no 
                    1 Disconnect a User 
                    2 Unconditional Shutdown 
                    3 Emergency Shutdown (Kill All) 
                    4 Exit 
    Enter choice> 
    

  5. Choose an option.
  6. If you choose 1 (Disconnect a User), the system prompts you for a user number. Choose 2 (Unconditional Shutdown) to stop all users and shut down the database. If you have multiple remote-user servers, this stops all the servers.


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