scripts/LJCOPY/gold_import/ccbmdm_gold_updates.sql

--/se GOLD3 CCB Environment Variables Update
-- Date: 18-05-2017
-- Author: Jagdip
-- Navigation key: Menu -> Admin Menu -> 'N' -> 'Navigation Key'
UPDATE CCBADM.CI_MD_NAV SET URL_OVRD='http://gold3.ccb.energy.coop.local/ccb/cm/CCBGOLD.gif' WHERE NAVIGATION_KEY='CM_logoImage';
-- Menu -> Admin Menu -> 'F' -> 'Feature Configuration' -> 
UPDATE CCBADM.CI_WFM_OPT SET WFM_OPT_VAL='http://gold3.mdm.energy.coop.local/mdm/cis.jsp' WHERE WFM_NAME='CM_GENSYSCFG';
-- Menu -> Admin Menu -> 'M' -> 'Master Configuration' -> Click on 'Migration Assistant Configuration' (pencil)
UPDATE CCBADM.F1_MST_CONFIG SET MST_CONFIG_DATA='<configuration><exportDirectory>/u01/ouaf/ouafoutput/CCBGOLD3/CCB240_THORCFG/cma/export</exportDirectory><importDirectory>/u01/ouaf/ouafoutput/CCBGOLD3/CCB240_THORCFG/cma/import</importDirectory><fileExtension>txt</fileExtension></configuration>' WHERE BUS_OBJ_CD='F1-MigrationAssistantConfig';
-- Menu -> Admin Menu -> 'X' -> 'XAI JNDI server'
UPDATE CCBADM.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6601' WHERE XAI_JNDI_SVR_ID = 'CI_MDM_JNDI';
UPDATE CCBADM.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.140:6600' WHERE XAI_JNDI_SVR_ID = 'MDM_JMS';
UPDATE CCBADM.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6603' WHERE XAI_JNDI_SVR_ID = 'CCB_AFMS';
UPDATE CCBADM.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6603' WHERE XAI_JNDI_SVR_ID = 'AFMS'; 
UPDATE CCBADM.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.139:6600' WHERE XAI_JNDI_SVR_ID = 'CCB_JMS';
-- UPDATE XAI SENDER URLs
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/' WHERE XAI_SENDER_ID = 'AIAORDER' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra/' WHERE XAI_SENDER_ID = 'C1-OUTCALLQY' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra/' WHERE XAI_SENDER_ID = 'C1-OUTJOBQRY' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra/' WHERE XAI_SENDER_ID = 'C1-PLANOUTQY' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra/' WHERE XAI_SENDER_ID = 'CI_USAGEDTLS' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra/' WHERE XAI_SENDER_ID = 'CI_USAGEOVRV' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.140:6600/mdm' WHERE XAI_SENDER_ID = 'CM-RETCONPER' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.140:6600/mdm' WHERE XAI_SENDER_ID = 'CM-RETCONSMP' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.140:6600/mdm' WHERE XAI_SENDER_ID = 'CM-RETUSAGE' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra' WHERE XAI_SENDER_ID = 'CM_MDMHILOW' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra' WHERE XAI_SENDER_ID = 'CM_RAUSGEREQ' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra/' WHERE XAI_SENDER_ID = 'TSTNMSQSNDR' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra' WHERE XAI_SENDER_ID = 'WX-RateAnlys' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra' WHERE XAI_SENDER_ID = 'WX-UsageDtls' AND SENDER_CTXT_FLG='HTU1';
UPDATE CCBADM.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6601/soa-infra' WHERE XAI_SENDER_ID = 'WX-UsageOvrv' AND SENDER_CTXT_FLG='HTU1';
-- Navigation key: Menu -> Admin Menu -> 'N' -> 'Navigation Key'
UPDATE MDMADM.CI_MD_NAV SET URL_OVRD='http://gold3.mdm.energy.coop.local/mdm/cm/MDMGOLD.gif' WHERE NAVIGATION_KEY='CM_logoImage';
-- Menu -> Admin Menu -> 'F' -> 'Feature Configuration' -> 
UPDATE MDMADM.CI_WFM_OPT SET WFM_OPT_VAL='http://gold3.ccb.energy.coop.local/ccb/loginPage.jsp' WHERE WFM_NAME='CM-GENSYSCFG';
-- Menu -> Admin Menu -> 'M' -> 'Master Configuration' -> Click on 'Migration Assistant Configuration' (pencil)
UPDATE MDMADM.F1_MST_CONFIG SET MST_CONFIG_DATA='<configuration><exportDirectory>/u01/ouaf/ouafoutput/MDMGOLD3/CCB240_THORCFG/cma/export</exportDirectory><importDirectory>/u01/ouaf/ouafoutput/MDMGOLD3/CCB240_THORCFG/cma/import</importDirectory><fileExtension>txt</fileExtension></configuration>' WHERE BUS_OBJ_CD='F1-MigrationAssistantConfig';
-- Menu -> Admin Menu -> Master Configuration -> Generic BI Configuration -> File Path needs to be updated to reflect the environment.
UPDATE MDMADM.F1_MST_CONFIG SET MST_CONFIG_DATA='<description>Master Configuration for BI</description><generalMasterConfiguration><filePath>/u01/ouaf/ouafoutput/MDMGOLD3/D1ExtractFiles</filePath><characterEncoding>UTF-8</characterEncoding></generalMasterConfiguration>' WHERE BUS_OBJ_CD='F1-BIGeneralMasterConfig';
-- Menu -> Admin Menu -> 'X' -> 'XAI JNDI server'
UPDATE MDMADM.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.140:6600' WHERE XAI_JNDI_SVR_ID = 'CCB_JMS';
UPDATE MDMADM.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6601' WHERE XAI_JNDI_SVR_ID = 'CCB_JNDI';
UPDATE MDMADM.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6603' WHERE XAI_JNDI_SVR_ID = 'SGG_JNDI';