Página Principal Explorar Ajuda
Registe-se Iniciar Sessão
neal
/
scripts
1
0
Fork 0
Ficheiros Problemas 0 Pull Requests 0 Wiki
Árvore: 32e3985109
Ramos Etiquetas
scripts
/
LJCOPY
/
env_updates
/
SIT3_CCB_EV_update.sql

SIT3_CCB_EV_update.sql 6.9 KB
Histórico Em bruto

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 
  1. -- Phase SIT3_CCB Environment Variables Update
    2. 

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

  3. -- Author: Pooja/Joe
    4. 

  4. 

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

  6. UPDATE ccbadm.CI_MD_NAV SET URL_OVRD='http://sit3.ccb.energy.coop.local/ccb/cm/CCBSIT3.gif' WHERE NAVIGATION_KEY='CM_logoImage';
    7. 

  7. 

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

  9. UPDATE ccbadm.CI_WFM_OPT SET WFM_OPT_VAL='http://sit3.mdm.energy.coop.local/mdm/cis.jsp' WHERE WFM_NAME='CM_GENSYSCFG';
    10. 

  10. 

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

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

  13. 

  14. -- Menu -> Admin Menu -> 'X' -> 'XAI JNDI server'
    15. 

  15. UPDATE ccbadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6751' WHERE XAI_JNDI_SVR_ID = 'CI_MDM_JNDI';	-- SOA
    16. 

  16. UPDATE ccbadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.140:6750' WHERE XAI_JNDI_SVR_ID = 'MDM_JMS';		-- MDM
    17. 

  17. UPDATE ccbadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6753' WHERE XAI_JNDI_SVR_ID = 'CCB_AFMS';		-- OSB
    18. 

  18. UPDATE ccbadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6753' WHERE XAI_JNDI_SVR_ID = 'AFMS';		-- OSB 
    19. 

  19. UPDATE ccbadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.139:6750' WHERE XAI_JNDI_SVR_ID = 'CCB_JMS';		-- CCB
    20. 

  20. UPDATE ccbadm.CI_XAI_JNDI_SVR SET PROVIDER_URL = 't3://10.170.3.142:6772' WHERE XAI_JNDI_SVR_ID = 'CM_BOL_JNDI';	-- CCB
    21. 

  21. 

  22. -- UPDATE XAI SENDER URLs
    23. 

  23. 

  24. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/' WHERE XAI_SENDER_ID = 'AIAORDER' AND SENDER_CTXT_FLG='HTU1';
    25. 

  25. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra/' WHERE XAI_SENDER_ID = 'C1-OUTCALLQY' AND SENDER_CTXT_FLG='HTU1';
    26. 

  26. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra/' WHERE XAI_SENDER_ID = 'C1-OUTJOBQRY' AND SENDER_CTXT_FLG='HTU1';
    27. 

  27. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra/' WHERE XAI_SENDER_ID = 'C1-PLANOUTQY' AND SENDER_CTXT_FLG='HTU1';
    28. 

  28. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra/' WHERE XAI_SENDER_ID = 'CI_USAGEDTLS' AND SENDER_CTXT_FLG='HTU1';
    29. 

  29. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra/' WHERE XAI_SENDER_ID = 'CI_USAGEOVRV' AND SENDER_CTXT_FLG='HTU1';
    30. 

  30. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.140:6750/mdm' WHERE XAI_SENDER_ID = 'CM-RETCONPER' AND SENDER_CTXT_FLG='HTU1';
    31. 

  31. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.140:6750/mdm' WHERE XAI_SENDER_ID = 'CM-RETCONSMP' AND SENDER_CTXT_FLG='HTU1';
    32. 

  32. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.140:6750/mdm' WHERE XAI_SENDER_ID = 'CM-RETUSAGE' AND SENDER_CTXT_FLG='HTU1';
    33. 

  33. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra' WHERE XAI_SENDER_ID = 'CM_MDMHILOW' AND SENDER_CTXT_FLG='HTU1';
    34. 

  34. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra' WHERE XAI_SENDER_ID = 'CM_RAUSGEREQ' AND SENDER_CTXT_FLG='HTU1';
    35. 

  35. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra/' WHERE XAI_SENDER_ID = 'TSTNMSQSNDR' AND SENDER_CTXT_FLG='HTU1';
    36. 

  36. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra' WHERE XAI_SENDER_ID = 'WX-RateAnlys' AND SENDER_CTXT_FLG='HTU1';
    37. 

  37. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra' WHERE XAI_SENDER_ID = 'WX-UsageDtls' AND SENDER_CTXT_FLG='HTU1';
    38. 

  38. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'http://10.170.3.142:6751/soa-infra' WHERE XAI_SENDER_ID = 'WX-UsageOvrv' AND SENDER_CTXT_FLG='HTU1';
    39. 

  39. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = '10.170.210.114' WHERE XAI_SENDER_ID = 'CI_EMAIL_RT' AND SENDER_CTXT_FLG='SMHO';
    40. 

  40. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = '10.170.210.114' WHERE XAI_SENDER_ID = 'CI_RTEMAIL' AND SENDER_CTXT_FLG='SMHO';
    41. 

  41. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = '10.170.210.114' WHERE XAI_SENDER_ID = 'REALTMEMAIL' AND SENDER_CTXT_FLG='SMHO';
    42. 

  42. UPDATE ccbadm.CI_XAI_SNDR_CTX SET F1_CTXT_VAL_LONG = 'https://sandbox.firstcapitalcashflow.co.uk/api.asmx' WHERE XAI_SENDER_ID = 'CM-FIRSTCAP' AND SENDER_CTXT_FLG='HTU1';
    43. 

  43. 

  44. -- UPDATE FIRSTCAP Feature Config
    45. 

  45. 

  46. UPDATE ccbadm.CI_WFM_OPT SET WFM_OPT_VAL='295363' WHERE WFM_NAME='CM_MVPRC'AND EXT_OPT_TYPE = 'CLSN';
    47. 

  47. UPDATE ccbadm.CI_WFM_OPT SET WFM_OPT_VAL='K9r4nJas' WHERE WFM_NAME='CM_MVPRC' AND EXT_OPT_TYPE = 'SHPW';
    48. 

  48.  
    49. 

  49. -- UPDATE SHERLOCK Feature Config
    50. 

  50. 

  51. UPDATE ccbadm.CI_WFM_OPT SET WFM_OPT_VAL='7c4dc05b0d10c5a085b6422ef' WHERE WFM_NAME='CM_CMPLTMGMT'AND EXT_OPT_TYPE = 'APIK';
    52. 

  52. UPDATE ccbadm.CI_WFM_OPT SET WFM_OPT_VAL='https://uat.icasework.com' WHERE WFM_NAME='CM_CMPLTMGMT'AND EXT_OPT_TYPE = 'BURL';
    53. 

  53. UPDATE ccbadm.CI_WFM_OPT SET WFM_OPT_VAL='e78f2ac558c93a88cabdf48f' WHERE WFM_NAME='CM_CMPLTMGMT'AND EXT_OPT_TYPE = 'SCRK';
    54. 

  54. 

  55. -- UPDATE BATCH CONTROL FOR CMLTWELC 
    56. 

  56. 

  57. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTWELC'AND BATCH_PARM_NAME = 'filePath';
    58. 

  58. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTGEN'AND BATCH_PARM_NAME = 'filePath';
    59. 

  59. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTCOLL'AND BATCH_PARM_NAME = 'filePath';
    60. 

  60. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTWOFF'AND BATCH_PARM_NAME = 'filePath';
    61. 

  61. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTGENP'AND BATCH_PARM_NAME = 'filePath';
    62. 

  62. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTLOSS'AND BATCH_PARM_NAME = 'filePath';
    63. 

  63. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTGN2P'AND BATCH_PARM_NAME = 'filePath';
    64. 

  64. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTGEN2'AND BATCH_PARM_NAME = 'filePath';
    65. 

  65. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTIQT'AND BATCH_PARM_NAME = 'filePath';
    66. 

  66. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTCPR'AND BATCH_PARM_NAME = 'filePath';
    67. 

  67. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='CMLTDD'AND BATCH_PARM_NAME = 'filePath';
    68. 

  68. UPDATE ccbadm.CI_BATCH_CTRL_P SET BATCH_PARM_VAL='/u01/ouaf/ouafoutput/CCBSIT3/LETTERS/' WHERE BATCH_CD='LTRPRT'AND BATCH_PARM_NAME = 'FILE-PATH';
    69.