Kbase P8019: Getting error 2623 during database schema change when users are connected
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/08/2005 |
|
Status: Verified
SYMPTOM(s):
Getting error 2623 during database schema change
Database in use by <user> on <tty>. Wait or choose CANCEL to stop. (2623)
CAUSE:
The database is used in multi user mode and there are users accessing data
FIX:
Disconnect all users from the database before modifying the database schema
To list all users connected, perform a
PROSHUT -C list
This will list of the users connected to the database. The list is printed out to the screen without any page breaks.
To disconnect all users, preform a
PROSHUT -C disconnect usernum
This allows you to initiate a disconnect for the specified user. This is similar to option 1 of the PROSHUT menu.