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

  1. Click Start > Programs > IBM Rational > IBM Rational Lifecycle Solutions Tools > IBM Rational DOORS 9.5 > DOORS Database Server Admin.
  2. Connect to the database server whose connections you want to check.
  3. Click Refresh List to refresh the list of users and locked files.
  4. Click Exit to close the Database Server Admin window.
    Note: You cannot use the Rational DOORS database server administration tool on UNIX machines. If you use a UNIX machine to manage the database server, you must use the command line:
    1. Change your working directory to $Rational DOORSHOME/bin.
    2. To see a list of the users that are currently connected, enter the command:
      dbadmin -data port@DOORSserver [-password password]-userlist
      To see a list of all the locked files, enter the command:
      dbadmin -data port@DOORSserver [-password password]-locklist
      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.

      A list is displayed of all the users who currently have a connection, in the form channel-id:username@computer. The connection made by the dbadmin command has the user name admin, and an asterisk before the user name, instead of a colon.

      For example:

      abc$ dbadmin -data 36677@xyz -userlist
      -I- DBADMIN 6823:ptfrint@def
      -I- DBADMIN 8978*admin@abc 
      abc$ dbadmin -data 36677@ghi -killprocess 6823 

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

Feedback