Question & Answer
Question
How can a user see what connections are still active on a particular Sybase SQL Anywhere 8 database which is associated with IBM® Rational® TestManager (TM)?
Answer
Here are the steps to check which users are still connected to a given database:
Note: Sybase SQL Anywhere was a supported database with Rational TestManager versions 2003.06.15 and earlier.
- Open Sybase Central
(Start > Programs > Rational Software > SQL Anywhere 8 > Sybase Central). - Select Tools > Connect (or click the F11 key).
- For User type DBA and for Password type SQL.
- Click the Database tab, press the Find button and select the service you want to check.
- Under Database file, browse out to the desired tds.db (Note: there is a tds.db file in the project's TestUsersAndGroups folder, the TestDatastore folder and the TestDatastore\DefaultTestScriptDataastore folder).
- Uncheck both Start database automatically and Stop database after last disconnect.
- Click OK.
- If you see a gray cylinder with your project name on it, click the plus (You may need to go through steps 3-7 again if there is a red X on the cylinder).
- Click on the Connected Users folder. You should see everyone connected to the database, including yourself as the DBA.
- Select Tools > Disconnect (or click F12) to disconnect.
[{"Product":{"code":"SSSHVH","label":"Rational TestManager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Datastore","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00;2003.06.10;2003.06.12;2003.06.13;2003.06.14;2003.06.15;7.0.0.3;7.0.1.2;7.0.0.4;7.0.1.3;7.0.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSHDX","label":"Rational Robot"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Datastore","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2003.06.00;2003.06.10;2003.06.12;2003.06.13;2003.06.14;2003.06.15","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
More support for:
Rational TestManager
Software version:
2003.06.00, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15, 7.0.0.3, 7.0.1.2, 7.0.0.4, 7.0.1.3, 7.0.2
Operating system(s):
Windows
Document number:
341365
Modified date:
16 June 2018
UID
swg21212216