Inicio Explorar Ayuda
Registro Iniciar sesión
neal
/
scripts
1
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Árbol: 32e3985109
Ramas Etiquetas
scripts
/
LJCOPY
/
env_updates
/
UAT4_MDM_EV_update.sql

UAT4_MDM_EV_update.sql 1.9 KB
Histórico Raw

12345678910111213141516171819202122 
  1. -- Phase UAT4_MDM Environment Variables Update
    2. 

  2. -- Date: 23-07-2019
    3. 

  3. -- Author: Pooja
    4. 

  4. 

  5. -- Navigation key: Menu -> Admin Menu -> 'N' -> 'Navigation Key'
    6. 

  6. UPDATE mdmadm.CI_MD_NAV SET URL_OVRD='http://uat4.mdm.energy.coop.local/mdm/cm/MDMUAT4.gif' WHERE NAVIGATION_KEY='CM_logoImage';
    7. 

  7. 

  8. -- Menu -> Admin Menu -> 'F' -> 'Feature Configuration' -> 
    9. 

  9. UPDATE mdmadm.CI_WFM_OPT SET WFM_OPT_VAL='http://uat4.ccb.energy.coop.local/ccb/loginPage.jsp' WHERE WFM_NAME='CM-GENSYSCFG';
    10. 

  10. 

  11. -- Menu -> Admin Menu -> 'M' -> 'Master Configuration' -> Click on 'Migration Assistant Configuration' (pencil)
    12. 

  12. UPDATE mdmadm.F1_MST_CONFIG SET MST_CONFIG_DATA='<configuration><exportDirectory>/u02/ouaf/ouafoutput/MDMUAT4/CCB240_THORCFG/cma/export</exportDirectory><importDirectory>/u02/ouaf/ouafoutput/MDMUAT4/CCB240_THORCFG/cma/import</importDirectory><fileExtension>txt</fileExtension></configuration>' WHERE BUS_OBJ_CD='F1-MigrationAssistantConfig';
    13. 

  13. 

  14. -- Menu -> Admin Menu -> Master Configuration -> Generic BI Configuration -> File Path needs to be updated to reflect the environment.
    15. 

  15. UPDATE mdmadm.F1_MST_CONFIG SET MST_CONFIG_DATA='<description>Master Configuration for BI</description><generalMasterConfiguration><filePath>/u01/ouaf/ouafoutput/MDMUAT4/D1ExtractFiles</filePath><characterEncoding>UTF-8</characterEncoding></generalMasterConfiguration>' WHERE BUS_OBJ_CD='F1-BIGeneralMasterConfig';
    16. 

  16. 

  17. -- Menu -> Admin Menu -> 'X' -> 'XAI JNDI server'
    18. 

  18. UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.139:7950' WHERE XAI_JNDI_SVR_ID = 'CCB_JMS';		
    19. 

  19. UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:7951' WHERE XAI_JNDI_SVR_ID = 'CCB_JNDI';		
    20. 

  20. UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:7953' WHERE XAI_JNDI_SVR_ID = 'SGG_JNDI';
    21. 

  21. UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:7972' WHERE XAI_JNDI_SVR_ID = 'DM_BOL_JNDI';
    22. 

  22. UPDATE mdmadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.140:7950' WHERE XAI_JNDI_SVR_ID = 'MDM_JMS';		
    23.