beautypg.com

Restoring replication after upgrade – Sybase ADAPTIVE 15.0.2 User Manual

Page 90

background image

Post-upgrade tasks

74

Adaptive Server Enterprise

6

Resume the DSI connections that were suspended before the upgrade by
executing the following Replication Server command for each suspended
database:

1> resume connection to dataserver.database

2> go

The replication system is now ready for Adaptive Server 12.5.x, and
applications can resume.

If you installed any Sybase client products, such as Open Client, use the

dsedit

utility to edit your interfaces file and to specify the servers to which you want
to connect.

For more information about establishing client/server connections, see the
Open Client Configuration Guide or Chapter 4, “Installing Sybase PC-Client
Products.”

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.