describe cust_svc_prof;
select PARAM_NM from cust_svc_prof where CLAP_ID='test2';
update cust_svc_prof set PARAM_VAL=0 where PARAM_NM='CHANGE_DEV_FLAG' and CLAP_ID='test2';
update cust_svc_prof set PARAM_VAL=1 where PARAM_NM='ICDP' and CLAP_ID='test2';


cvs co -r SNS-R3_0-60 sns
cvs co -r UTL-R3_0-60  utl
cvs co -r CSE-R3_0-60 cse
cvs co -r INTERFACE-R3_0 interface
export CVSROOT="/home/newstep/ARES"
cvs co -r CSN-R3_0 csn



cvsrel -debug mag -mag MSC-MAG-R1_33-28  -utl MSC-UTL-R1_33-28  med -med MSC-MED-R1_33-28


 update sip_connector set LOCAL_ORIG_SERVICE_PORT=5070 where MNSS_CONFIG_ID=31;
 update sip_connector set LOCAL_TERM_SERVICE_PORT=5070 where MNSS_CONFIG_ID=31;
 update sip_connector set LOG_LEVEL='INFO' where MNSS_CONFIG_ID=31;
 update sip_connector set STACK_LOG_LEVEL='TRACE(4)' where MNSS_CONFIG_ID=31;
 update sip_connector set STACK_LOG_FILE='/tmp/rvstack.log' where MNSS_CONFIG_ID=31;


INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_CALLS_MAX',              '124000');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_SIMULTANEOUS_REGISTRATIONS','10');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_GENERAL_LINGER',         '32000');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_CANCEL_NO_RESPONSE',     '32000');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_PROVISIONAL_TIMER',      '180000');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_GENERAL_REQ_TIMEOUT',    '320000');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_TRANSACTIONS',           '124000');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_GENERAL_REQ_TIMEOUT',    '320000');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_THREADS',                '5');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_PQUEUE_SIZE',            '0');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_NUM_READ_BUF',           '10000');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_MSG_POOL_NUM_PAGES',     '0');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_MSG_POOL_PAGE_SIZE',     '0');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_GENERAL_POOL_NUM_PAGES', '0');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_GENERAL_POOL_PAGE_SIZE', '0');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_MAX_MSG_SIZE', '0');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_MAX_HDR_SIZE', '0');
INSERT INTO INIT_PARAM (NM, VALUE) VALUES ('SIP_ENHANCED_DNS_ENABLED', 'FALSE');

delete from init_param where nm like 'SIP%';




ps -fu tkramar |grep -v ps
