Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Moving Replicate Database Server to a different host and upgrading from ASE 15.0.3 to ASE 15.5

2 posts in General Discussion Last posting was on 2013-01-22 21:25:11.0Z
syb_user Posted on 2013-01-09 16:05:22.0Z
Sender: 5260.50ed94d4.1804289383@sybase.com
From: syb_user
Newsgroups: sybase.public.rep-server
Subject: Moving Replicate Database Server to a different host and upgrading from ASE 15.0.3 to ASE 15.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50ed9542.5282.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Jan 2013 08:05:22 -0800
X-Trace: forums-1-dub 1357747522 172.20.134.41 (9 Jan 2013 08:05:22 -0800)
X-Original-Trace: 9 Jan 2013 08:05:22 -0800, 172.20.134.41
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9291
Article PK: 1158859

Please review the steps below and let me know if i am
missing anything. Thanks for your help
================================

Moving Replicate Database Server to a different host and
upgrading from ASE 15.0.3 to ASE 15.5

Environment: 1-to-1 ASE to ASE bi-directional replication
(though at any given point, only one of them is the primary
and the other is the replicate) using RS 15.6. Both ASEs are
at version 15.0.3

Problem: Hardware warranty expired and consequently need to
move both ASE database servers to new hardware and also
upgrade to 15.5.

Steps:

(A) Move replicate to new hardware/host and upgrade
databases.

(1)Build ASE server with the same name on the new host
(2) Suspend connections to ASE and also DSI connections from
ASE
(3) On the replicate database server, stop rep agent,
disable secondary truncation marker, truncate transaction
log and zero out ltm marker in RSSD
(4) Dump replicate databases
(5) Update interfaces file on replication host and all
affected hosts with new host name (since we are retaining
the same SERVER name)
(6) Load backups from step(4) on the new host with the same
server name and online the replicate databases
(7) Ensure all rep agents for the replicate databases on the
new host have been enabled
(8) Enable secondary truncation marker and restart rep
agents
(9) Resume connections suspended in step(2)

(B) Switch client connections to replicate which is the new
primary

(C) Move new replicate (former primary) to new hardware/host
and upgrade databases (same 9 steps in (A))


syb_user Posted on 2013-01-22 21:25:11.0Z
Sender: 4dd9.50fefdf6.1804289383@sybase.com
From: syb_user
Newsgroups: sybase.public.rep-server
Subject: Re: Moving Replicate Database Server to a different host and upgrading from ASE 15.0.3 to ASE 15.5
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50ff03b7.4fef.1681692777@sybase.com>
References: <50ed9542.5282.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 22 Jan 2013 13:25:11 -0800
X-Trace: forums-1-dub 1358889911 172.20.134.41 (22 Jan 2013 13:25:11 -0800)
X-Original-Trace: 22 Jan 2013 13:25:11 -0800, 172.20.134.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9305
Article PK: 1159242

Any feedback is appreciated ... Mark, let me know if you
have any thoughts on the steps listed