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.
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.
Lumart 120000GQG687 Posts
Re: Disconnecting clients from CQ schema repository and user databases2012-11-15T10:34:30ZThis is the accepted answer. This is the accepted answer.You could simply shut down the flexlm license server.
Without a license available, a user cannot login to CQ database.
pdubovitsky 100000N35Y376 Posts
Re: Disconnecting clients from CQ schema repository and user databases2012-11-15T14:00:29ZThis is the accepted answer. This is the accepted answer.
- Lumart 120000GQG6
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 2700024D3764 Posts
Re: Disconnecting clients from CQ schema repository and user databases2012-11-15T16:54:25ZThis is the accepted answer. This is the accepted answer.
- pdubovitsky 100000N35Y
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?