I need to change the code page on the schema repository and sync it to multiple sites. I am interested to prevent the users logging to CQ during this change.
Is it possible to run installutil codepageutil, installutil setdbcodepage, multiutil sync jobs after shutting down the flexlm server?
Is there any way for the DBA's to limit the no of concurrent users connecting to the Clearquest database?
This topic has been locked.
2 replies Latest Post - 2013-01-23T00:33:05Z by pdubovitsky
Pinned topic Limiting users to connect to Clearquest database
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-23T00:33:05Z at 2013-01-23T00:33:05Z by pdubovitsky
Leesa_Hicks 1200009HC4269 PostsACCEPTED ANSWER
Re: Limiting users to connect to Clearquest database2013-01-22T19:40:26Z in response to thalapathiI don't know what backend database you are using, but we take our SQL Server CQ databases offline for users by changing the dbowner password, then taking the database offline and back online. Then we back up the databases that will be modified prior to making any changes, of course.
Then you can update any needed db connection(s) and the user database connection password to access the databases to perform the necessary maintenance. Users are locked out. Then do the procedure again to reset the dbowner password back to the production password.