Restoring replication after upgrade – Sybase 15.0.2 User Manual
Page 90
Post-upgrade tasks
76
Adaptive Server Enterprise
Restoring replication after upgrade
Restore the replication functionality:
1
Log in to the RSSD for each replicated primary, and for each replicated
RSSD, and issue:
1> use RSSD_name
2> go
1> rs_zeroltm dataserver, database
2> go
2
Log in to each replicated primary, and replicated RSSD and issue:
1> use database
2> go
1> dbcc settrunc ('ltm', 'valid')
2> go
3
Restart the Replication Server.
4
If the database is also used as a RSSD, resume the Replication Server
connection to the RSSD by issuing the following command to the
Replication Server:
1> sysadmin hibernate_off, 'Replication Server'
2> go
Make sure to specify the same string that was specified during the
'hibernate_on'
command.
5
Log in to the Replication Server, and resume the Log Transfer connection
for each replicated primary and each replicated RSSD:
1> resume log transfer from server.database
2> go
If this is a replicated RSSD, you must log in to the replicate Replication
Server.
6
If you are using Rep Agent, log in to the Adaptive Server and restart the
Rep Agent:
1> use database
2> go
1> sp_start_rep_agent database
2> go
7
If you are using LTM, restart the LTM.