Tuesday, March 18, 2025

FIG project queries

##### Service add & LOad Baclancing on Add Service #######

srvctl add service -s wcccdmt.farmersinsurance.com -r wcccdmtx1,wcccdmtx2,wcccdmtx3 -d wcccdmtx -failovermethod BASIC -failovertype SELECT

srvctl start service -s wcccdmt.farmersinsurance.com -d wcccdmtx

srvctl stop service -s wcccdmt.farmersinsurance.com -d wcccdmtx

srvctl status service -s wcccdmt.farmersinsurance.com -d wcccdmtx

srvctl config service -d wcccdmtx

srvctl config service -db wcccdmtx -service wcccdmt.farmersinsurance.com

srvctl modify service -db wcccdmtx -service wcccdmt.farmersinsurance.com -rlbgoal SERVICE_TIME -clbgoal SHORT

srvctl config service -db wcccdmtx -service wcccdmt.farmersinsurance.com

srvctl modify service -db odsprdx -service odsprd.farmersinsurance.com -modifyconfig -preferred odsprdx1,odsprdx2,odsprdx4


https://mikedietrichde.com/2023/05/24/choose-your-desired-time-zone-version-dst-upgrade/

 select value$ "TZ Version" from SYS.PROPS$ where name='DST_PRIMARY_TT_VERSION';


select value$ "TZ Version" from SYS.PROPS$ where name='DST_PRIMARY_TT_VERSION';
select value$ "TZ Version" from SYS.PROPS$ where name='DST_PRIMARY_TT_VERSION';

FIG project queries

##### Service add & LOad Baclancing on Add Service ####### srvctl add service -s wcccdmt.farmersinsurance.com -r wcccdmtx1,wcccdmtx2,wcc...