I am planning to change the CQ data code page in our multisited environment. To perform this, as a first step, I need to prevent the users to connect to the database without shutting down the database.
Is there any way to disconnect the clients from CQ repository and user databases?
This topic has been locked.
3 replies Latest Post - 2012-11-15T16:54:25Z by thalapathi
Pinned topic Disconnecting clients from CQ schema repository and user databases
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-15T16:54:25Z at 2012-11-15T16:54:25Z by thalapathi
Lumart 120000GQG687 Posts
pdubovitsky 100000N35Y376 PostsACCEPTED ANSWER
Re: Disconnecting clients from CQ schema repository and user databases2012-11-15T14:00:29Z in response to LumartShutting down the license server might not be the best option. First, the server might host other tool licenses. Second, depending on version, clients might be allowed to proceed with a grace period when license server is not available.
Locking user database might be a better option. In order to lock the database, set "db_locked" field to "1" in the dbglobal table. You can add meaningful message to the users in the "db_locked_info" field. In this case, all login attempts will be denied.
In order to unlock the database, set "db_locked" to "0" and clear "db_locked_info" field.
thalapathi 2700024D3762 PostsACCEPTED ANSWER
Re: Disconnecting clients from CQ schema repository and user databases2012-11-15T16:54:25Z in response to pdubovitskyHi Pavel/Lumart,
Thanks for your reply. I need to change the code page on the schema repo. How it's possible to change the codepage of the schema repo after locking the database.
Is it possible to run codepageutil after shutting down the flexlm server?