Release 10.1A: OpenEdge Data Management:
Database Administration

> ## PROMON shut down database option

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

> | To shut down a database using PROMON:

> 1. Enter the following PROMON command:

>     promon db-name

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

>       OpenEdge MONITOR Version 10
>       Database: usr1/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
>     R&D.  Advanced Options
>       T.  Transaction Control
>       L.  Resolve Limbo Transactions
>       C.  Coordinator Information
>       M.  Modify Defaults
>       Q.  Quit
>       Enter your selection:

> 2. Choose option 8, Shut Down Database.

> 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>

> 3. Choose an option.

> 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095