Skip to Content

here’s my notes:

before:

ASE1(rssd) –> PRS1 –> PRS2 –> ASE2(rssd)

after:

ASE1(rssd) –> T_PRS1 –> T_PRS2 –> ASE2(rssd)

IDserver: PRS1

1.shutdown RS

2.ASE keep runnig

3.edit interfaces file

4.edit file name RUN_PRS1, RUN_PRS2 and servername inside.

5.edit file name PRD1.cfg, PRS2.cfg

6.edit system table informaion store in PRS1’s rssd

backup rssd: dump database PRS1_RSSD to “/sybasedata/rs/PRS1rssd.dmp”

begin tran

update rs_config set charvalue=”T_PRS1″ where optionname=”oserver”

update rs_config set charvalue=”T_PRS1″ where optionname=”id_server”

commit

begin tran

update rs_idnames  set name1=”T_PRS1″ where name1=”PRS1″

update rs_idnames  set name1=”T_PRS2″ where name1=”PRS2″

commit

begin tran

update rs_sites set name=”T_PRS1″ where name=”PRS1″

update rs_sites set name=”T_PRS2″ where name=”PRS2″

commit

edit repagent‘s RS name.

sp_help_rep_agent pubs2

sp_stop_rep_agent pubs2

sp_config_rep_agent pubs2,’disable’

sp_config_rep_agent pubs2,’enable’,T_PRS1,sa,sapassword

sp_start_rep_agent pubs2

7.edit system table informaion store in PRS2’s rssd

dump database PRS2_RSSD to “/sybasedata/rs/PRS2rssd.dmp”

begin tran

update rs_config set charvalue=”T_PRS2″ where optionname=”oserver”

update rs_config set charvalue=”T_PRS1″ where optionname=”id_server”

commit

begin tran

update rs_sites set name=”T_PRS1″ where name=”PRS1″

update rs_sites set name=”T_PRS2″ where name=”PRS2″

commit

sp_help_rep_agent pubs2

sp_stop_rep_agent pubs2

sp_config_rep_agent pubs2,’disable’

sp_config_rep_agent pubs2,’enable’,T_PRS2,sa,sapassword

sp_start_rep_agent pubs2

8.start both rs and replicate OK.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply