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.
