Question
ING Bank NV
NL
Last activity: 19 Mar 2024 6:08 EDT
Check Default Rules and Data owner from the Pega
Hi Pega ,
This is a question format.
We are having split schema design, meaning we have 2 rules owner and 1 data schema owner in our database.
While upgrading pega, we migrate the active rules owner to cloned rules owner and then switch over the application by updating catalina.properties to point to the new rules owner schema,
For data owner schema, it will always be same as we have configured in catalina.props file .
We would like to know if there is any table in the database which we can select * to show us the active rules owner and data owner information without checking the details from catalina.props file. ?
Maantic Technologies Pvt Ltd
US
Yes, you can use the following query to get the active rules owner and data owner information:
select * from pr_system_config where config_type = 'prconfig.database.connection'
The `active_rules_owner` column will show the active rules owner and the `active_data_owner` column will show the active data owner.
Hope it helps.
Thank You
Megha
ING Bank NV
NL
@Megha007 Thanks Megha,
pega is running on oracle database, and we couldnt locate the table mentioned in our database.
SELECT owner,segment_name, segment_type, bytes/1024/1024/1024 GB FROM dba_segments WHERE segment_type = 'TABLE' AND segment_name IN ('PR_SYSTEM_CONFIG');
--- no rows selected .