18 lines
1.6 KiB
SQL
18 lines
1.6 KiB
SQL
--监控优化
|
|
UPDATE CAPSOFTROUTE SET SIGNURL='192.168.64.14' WHERE BANKCODE='CMBC' AND FRSPRNO='001';
|
|
UPDATE CAPSOFTROUTE SET SIGNURL='192.168.64.15' WHERE BANKCODE='CMBC' AND FRSPRNO='002';
|
|
UPDATE CAPSOFTROUTE SET SIGNURL='192.168.64.115' WHERE BANKCODE='CMBC' AND FRSPRNO='003';
|
|
UPDATE CAPSOFTROUTE SET SIGNURL='192.168.64.116' WHERE BANKCODE='CMBC' AND FRSPRNO='004';
|
|
commit;
|
|
|
|
--打开64.115前置机开关
|
|
UPDATE CAPSOFTROUTE SET FTSSTS='S' WHERE BANKCODE='CMBC' AND FRSPRNO='003';
|
|
commit;
|
|
|
|
--新增前置机节点
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL, TM_SMP)
|
|
values ('CMBC', '005', null, null, 'url=http://192.168.64.178:8080/weblogic/servlets/EService/CSM/E2B/E2BSignServlet&&method=POST&&charSet=GB2312&&timeout=30&&contentType=contentType', 'clientId=2009105532&&userId=2009105532008&&userPswd=9pk2ms&&language=chs&&appId=nsbdes&&appVer=201&&TAC_NO=0258014170000361', 'S', null, 'CMBC_CHECK_HEART', 'S', '192.168.64.178', '20140417162001');
|
|
|
|
insert into CAPSOFTROUTE (BANKCODE, FRSPRNO, OBJSVR, HTXNCD, HEADPARAM, BODYPARAM, ORTSTS, HBOBJSVR, HBTXNCD, FTSSTS, SIGNURL, TM_SMP)
|
|
values ('CMBC', '006', null, null, 'url=http://192.168.64.179:8080/weblogic/servlets/EService/CSM/E2B/E2BSignServlet&&method=POST&&charSet=GB2312&&timeout=30&&contentType=contentType', 'clientId=2009105532&&userId=2009105532007&&userPswd=9pk2ms&&language=chs&&appId=nsbdes&&appVer=201&&TAC_NO=0258014170000361', 'S', null, 'CMBC_CHECK_HEART', 'S', '192.168.64.179', '20140417162007');
|
|
commit; |