How to kill a user in Progress

If you need to kill a user connected to a Progress database (because locking issues for example), you can get a list and then kill a user with the proshut command:

myserver:/myprogressdb:> proshut mydb -C list

usr pid time of login user id tty Limbo?

165 20352 Tue Jun 21 08:35:32 2009 SOMEUSER w1c3xpr3 no

 
myserver:/myprogressdb:> proshut mydb -C disconnect 165

User 165 disconnect initiated. (6796)

You can also disconnect users and shutdown databases with the promon menu, selecting the option 8:

myserver:/myprogressdb:> promon mydb.db

    PROGRESS MONITOR Version 9

    Database: /myprogressdb/mydb

    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.  Transactions Control
    L.  Resolve Limbo Transactions
    C.  Coordinator Information

    M.  Modify Defaults
    Q.  Quit

    Enter your selection: 8
usr    pid    time of login           user id     tty                  Limbo?
 11  24122 Sat May 21 10:23:29 2009   biw                              no
 12  24247 Sat May 21 10:23:30 2009   wdog                             no
 13  14898 Wed Jun 29 08:25:08 2009   MYUSER0001  /dev/pts/1           no
100  18648 Tue Jun 28 11:30:09 2009   MYUSER0002  w1c3xpr3             no
104  15128 Fri Jun 24 11:51:34 2009   MYUSER0003  w1c3xpr4             no
106  13556 Fri Jun 24 11:52:02 2009   MYUSER0004  w1c3xpr4             no
115  20344 Tue Jun 21 13:30:10 2009   MYUSER0003  w1c3xpr4             no
122  16948 Tue Jun 28 10:18:10 2009   MYUSER0005  w1c3xpr3             no
131  11128 Tue Jun 28 09:09:33 2009   MYUSER0006  w1c3xpr3             no
138  13252 Tue Jun 28 09:45:05 2009   MYUSER0007  w1c3xpr3             no
139   9828 Tue Jun 28 09:00:06 2009   MYUSER0008  w1c3xpr4             no
146  11708 Tue Jun 28 08:51:51 2009   MYUSER0009  w1c3xpr3             no
150  10640 Tue Jun 28 08:48:59 2009   MYUSER0010  w1c3xpr3             no
151  15464 Tue Jun 28 08:48:44 2009   MYUSER0001  w1c3xpr4             no

RETURN - show remaining, Q - quit:
usr    pid    time of login           user id     tty                  Limbo?
190  10708 Wed Jun 29 07:21:35 2009   MYUSER0011  w1c3xpr4             no

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

   Enter choice>

If there is a lot of users you can see all pressing RETURN, and after showing all users you can choose to shutdown the database (option 2), or kill some user with his usr number (option 1).