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.

Upgrade to 64-bit RS 15.7.1 from 32-bit 15.2

3 posts in General Discussion Last posting was on 2012-08-10 21:49:44.0Z
syb_user Posted on 2012-08-03 23:20:26.0Z
Sender: 2780.501c55cf.1804289383@sybase.com
From: syb_user
Newsgroups: sybase.public.rep-server
Subject: Upgrade to 64-bit RS 15.7.1 from 32-bit 15.2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <501c5cba.284d.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 3 Aug 2012 16:20:26 -0700
X-Trace: forums-1-dub 1344036026 172.20.134.41 (3 Aug 2012 16:20:26 -0700)
X-Original-Trace: 3 Aug 2012 16:20:26 -0700, 172.20.134.41
Lines: 105
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9227
Article PK: 870386

Not sure when the scripts mentioned in the "configuration"
document need to be run - is it before the upgrade using
either "repserver" / "rs_init" (or) after the upgrade.

The doc seems to have it as a separate section with no
reference where it needs to be in the sequence of steps
during the upgrade


(TEXT Below)




Migrating Between 32-bit and 64-bit Platforms

Replication Server is available only on 64-bit platforms for
all supported UNIX and Linux operating systems.
Prerequisites

Back up your replication system. The upgrade process
makes changes to the system databases that you cannot roll
back if the upgrade fails. Restore the system databases if
the upgrade fails.
If you plan to install the Replication Server software
in a directory other than an existing Sybase version
directory, verify that the interfaces (sql.ini) file is
accessible.

Task
Note: If you have upgraded to a Replication Server version
available only on 64-bit platforms, you cannot migrate back
to a 32- bit platform. See the Replication Server Release
Bulletin for supported 64-bit platforms.

Stop Replication Agent for all primary databases and
system databases by executing this command on Replication
Server:

suspend log transfer from all

If you are using Adaptive Server as your RSSD, stop
RepAgent for the RSSD:

sp_stop_rep_agent RSSD_name

If you are going to migrate a Replication Server, log in
to each upstream Replication Server and suspend all the
routes to the Replication Server you are migrating:

suspend route to replicate_Replication_Server

Verify that the Replication Server queues have been
drained and that Replication Server has been quiesced:

admin quiesce_check

Retry with admin quiesce_force_rsi if Replication Server
is not yet quiesced.
Warning! You may lose data if you proceed with the
downgrade process without quiescing Replication Server.
Stop Replication Server:
Log in to the Replication Server as the system
administrator:

isql -Usa -Psa_password -Sservername

Enter:

1> shutdown
2> go

If you are using an ERSSD, manually restart it:
Set the LD_LIBRARY_PATH environment variable:

$ export
LD_LIBRARY_PATH=$SYBASE/REP-15_5/ASA12/
lib:$SYBASE/REP-15_5/lib64:$SYBASE/REP-15_5/
lib:$SYBASE/REP-15_5/lib3p64/log4cxx/lib:$SYBASE/

OCS-15_0/lib:$SYBASE/OCS-15_0/lib3p64:$SYBASE/OCS-15_0/
lib3p

Start the ERSSD:

-o $SYBASE/REP-15_5/samp_repserver/SAMPLE_RS.log

$SYBASE/REP-15_5/samp_repserver/dbfile/SAMPLE_RS_ERSSD.db &

See your Replication Server log file for the actual
commands to set LD_LIBRARY_PATH and to start the ERSSD by
searching for “LD_LIBARY_PATH” and “ERSSD start
command” respectively.
Load the migration script file into the ERSSD or RSSD.
For example:
ERSSD – load
$SYBASE/REP-15_5/scripts/rs_migration_asa.sql into the
ERSSD.
RSSD – load
$SYBASE/REP-15_5/scripts/rs_migration_ase.sql into the RSSD.
Start Replication Server from the new Replication Server
executable.

Related concepts
Start or Stop a Replication Server


syb_user Posted on 2012-08-07 16:44:55.0Z
Sender: 64d7.502144d4.1804289383@sybase.com
From: syb_user
Newsgroups: sybase.public.rep-server
Subject: Re: Upgrade to 64-bit RS 15.7.1 from 32-bit 15.2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50214607.64fa.1681692777@sybase.com>
References: <501c5cba.284d.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 7 Aug 2012 09:44:55 -0700
X-Trace: forums-1-dub 1344357895 172.20.134.41 (7 Aug 2012 09:44:55 -0700)
X-Original-Trace: 7 Aug 2012 09:44:55 -0700, 172.20.134.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9228
Article PK: 870388

Re-posting my questions

(1) Do the repserver / rs_init utilities automatically
upgrade earlier 32-bit only versions of RS to the current
64-bit only versions?

(2) Does the script rs_migration_ase.sql (mentioned below in
"Migrating Between 32-bit and 64-bit Platforms") also need
to be run in addition to step 1 and if so, in what sequence?

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35817.1571/doc/html/amu1268727974936.html


syb_user Posted on 2012-08-10 21:49:44.0Z
Sender: 9b5.50257b5a.1804289383@sybase.com
From: syb_user
Newsgroups: sybase.public.rep-server
Subject: Re: Upgrade to 64-bit RS 15.7.1 from 32-bit 15.2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <502581f8.a43.1681692777@sybase.com>
References: <50214607.64fa.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 10 Aug 2012 14:49:44 -0700
X-Trace: forums-1-dub 1344635384 172.20.134.41 (10 Aug 2012 14:49:44 -0700)
X-Original-Trace: 10 Aug 2012 14:49:44 -0700, 172.20.134.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9231
Article PK: 870392

Received the following response from Sybase technical
support

(1) Yes, rs_init will take charge of migration from 32-bit
to 64 bit version automactically when it upgrades the server
from 15.2 to 15.7.1 on Sun solaris platform.

(2) In your case, there is no need to run this script
manually. This migration section is for Linux and Windows
platforms. In RS 15.5, Sybase provides 32-bit and 64-bit
versions for both Linux and Windows for some reasons and
only 64-bit version for all other platforms. The instruction
in this section is for customers who want to switch from
32-bit RS 15.5 to 64-bit version of RS 15.5 on Linux and
Windows. You need step (2) to upgrade with the instruction
in the RS 15.7.1 configuration guide for Unix. The upgrade
requires your server to be quiesced before starting rs_init
because rs_init will purge the queues because the server
will be upgraded to 64-bit version.