Checking which users are connected to the database server
Use the Rational®
DOORS® database server administration tool on Windows machines to check which users are connected to database servers on
either Windows or Linux systems. The Rational
DOORS client only makes a connection to the server when it
needs to read data from disk or write data to disk. It closes the connection as soon as the data
transfer is completed.
Procedure
What to do next
If there are unwanted user connections or file locks, you can remove them.
On Windows machines, you can use the Database Server Administration tool. To disconnect a user connection, select it and click Disconnect User. To unlock a file, select it and click Unlock File.
On Linux machines, you must use the command line.
- To disconnect a user, type the
command:
dbadmin -data port@DOORSserver [-password password] -killprocess channel_identifier
- To unlock a file, type the command:
dbadmin -data port@DOORSserver [-password password] -unlock channel_identifier
Replace:
- port with the port that the database server is using.
- DOORSserver with the name of the computer the database server is running on.
- password with the password for the database server. If the database server does not have a password, omit the -password switch.
- channel_identifier with the channel identifier that is displayed by the -locklist switch.
Note: Only disconnect users and unlock files that are no longer being accessed. Disconnecting users who are currently connected, or unlocking files that are currently being accessed could corrupt your database.