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.

Replication Server usage recommendation

3 posts in General Discussion Last posting was on 2013-01-22 06:24:26.0Z
"Vojislav Depalov" <vojislav.depalov Posted on 2013-01-21 21:12:10.0Z
From: "Vojislav Depalov" <vojislav.depalov@remove_this_to_reach_me_dba-sybase.com>
Newsgroups: sybase.public.rep-server
Subject: Replication Server usage recommendation
Lines: 741
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50fdaf2a@forums-1-dub>
Date: 21 Jan 2013 13:12:10 -0800
X-Trace: forums-1-dub 1358802730 172.20.134.152 (21 Jan 2013 13:12:10 -0800)
X-Original-Trace: 21 Jan 2013 13:12:10 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9302
Article PK: 1159204

Hello,

as shown in picture, I would like to transfer data from Production to
Reporting, by using Replication Server. Since I am in process of RS learning
and installation preparation, I would have several questions:

1. Is this architecture feasible?

2. Is it possible to install Replication Server on separate machine without
Sybase ASE?

3. Where to put Replication Server working database if there is no Sybase
ASE on Replication Server machine - on Production or Reporting?

4. If Replication Server is installed on separate machine (Replication
Server machine), where will Replication Agent reside, and how it will
communicate with Primary Sybase ASE?

5. Is there something to be installed on Primary (or on Replicate) database
server in order to support this architecture?

6. If I want to set up this environment by using Sybase Central which is
running on Windows machine, where to find Sybase Central plug-in for
Replication Server, if Replication Server installation is for HPUX?

7. All other recommendations and comments are welcomed.

Thank You in advance.

Best regards,
Vojislav Depalov

DataFlowRS.JPG

"Mark A. Parsons" <iron_horse Posted on 2013-01-21 22:55:52.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Replication Server usage recommendation
References: <50fdaf2a@forums-1-dub>
In-Reply-To: <50fdaf2a@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 130112-1, 01/12/2013), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50fdc778$1@forums-1-dub>
Date: 21 Jan 2013 14:55:52 -0800
X-Trace: forums-1-dub 1358808952 172.20.134.152 (21 Jan 2013 14:55:52 -0800)
X-Original-Trace: 21 Jan 2013 14:55:52 -0800, vip152.sybase.com
Lines: 65
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9303
Article PK: 1159205

See comments below ...

On 01/21/2013 14:12, Vojislav Depalov wrote:
> Hello,
>
> as shown in picture, I would like to transfer data from Production to
> Reporting, by using Replication Server. Since I am in process of RS learning
> and installation preparation, I would have several questions:
>
> 1. Is this architecture feasible?

Yes

> 2. Is it possible to install Replication Server on separate machine without
> Sybase ASE?

Yes

a - repserver comes with a runtime copy of the ASA database and is used to implement the embedded RSSD (eRSSD)

b - some repservers come with the equivalent of a 'runtime' license for the ASE dataserver; need to check with your
Sybase sales rep to see if you have this ability

c - you can use any ASE (eg, your Production or Reporting dataserver) in your network environment to host the RSSD; keep
in mind that the repserver communicates a *LOT* with the RSSD so you'll want it to be 'close' network wise (eg, probably
not more than 1-2 ms ping time difference) otherwise you could see some degradation in repserver performance due to
excessive network delays with the RSSD

> 3. Where to put Replication Server working database if there is no Sybase
> ASE on Replication Server machine - on Production or Reporting?

This really depends on your network capabilities and the type of replication setup you plan on using (eg, table-level
replication, warm standby, MSA).

Keep in mind that if the repserver is hosted on a machine other than the Production database machine ... if the
Production database machine goes down then repserver can continue to replicate any transactions it has in its internal
queues.

> 4. If Replication Server is installed on separate machine (Replication
> Server machine), where will Replication Agent reside, and how it will
> communicate with Primary Sybase ASE?

The ASE repagent is actually a thread internal to the ASE dataserver (ie, the repagent code is part of the ASE binary so
there's no need for a standalone repagent binary).

> 5. Is there something to be installed on Primary (or on Replicate) database
> server in order to support this architecture?

The rs_init (OS-level) program is used to add databases (PDB and RDB) to the replication environment. rs_init takes
care of loading all the necessary components into your ASE databases.

Out of the box, repserver replicates INSERT/UPDATE/DELETE statements. If you have a need to manipulate these statements
(eg, ignore DELETEs, turn UPDATEs into 2 INSERTs in order to maintain histories, etc) before they're issued against the
replicate/reporting database then you'll likely need to design some custom function strings ... *you* have to write
these and load them into the repserver.

> 6. If I want to set up this environment by using Sybase Central which is
> running on Windows machine, where to find Sybase Central plug-in for
> Replication Server, if Replication Server installation is for HPUX?

Sorry, I don't use Sybase Central ... so you'll have to wait for someone else to come along with an answer.

Alternatively, look at the rs_init program (comes with the repserver binary installation). rs_init is a standalone
program (ie, doesn't require Sybase Central or any plugins) that allows you perform the initial repserver setup, as well
as adding databases to the replication environment.


"Vojislav Depalov" <vojislav.depalov Posted on 2013-01-22 06:24:26.0Z
From: "Vojislav Depalov" <vojislav.depalov@remove_this_to_reach_me_dba-sybase.com>
Newsgroups: sybase.public.rep-server
References: <50fdaf2a@forums-1-dub> <50fdc778$1@forums-1-dub>
Subject: Re: Replication Server usage recommendation
Lines: 90
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50fe309a$1@forums-1-dub>
Date: 21 Jan 2013 22:24:26 -0800
X-Trace: forums-1-dub 1358835866 172.20.134.152 (21 Jan 2013 22:24:26 -0800)
X-Original-Trace: 21 Jan 2013 22:24:26 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9304
Article PK: 1159211

Mark, thank You very much for detailed response.

Best regards,
Vojislav Depalov

"Mark A. Parsons" <iron_horse@no_spamola.compuserve.com> wrote in message
news:50fdc778$1@forums-1-dub...
> See comments below ...
>
> On 01/21/2013 14:12, Vojislav Depalov wrote:
>> Hello,
>>
>> as shown in picture, I would like to transfer data from Production to
>> Reporting, by using Replication Server. Since I am in process of RS
>> learning
>> and installation preparation, I would have several questions:
>>
>> 1. Is this architecture feasible?
>
> Yes
>
>> 2. Is it possible to install Replication Server on separate machine
>> without
>> Sybase ASE?
>
> Yes
>
> a - repserver comes with a runtime copy of the ASA database and is used to
> implement the embedded RSSD (eRSSD)
>
> b - some repservers come with the equivalent of a 'runtime' license for
> the ASE dataserver; need to check with your Sybase sales rep to see if you
> have this ability
>
> c - you can use any ASE (eg, your Production or Reporting dataserver) in
> your network environment to host the RSSD; keep in mind that the repserver
> communicates a *LOT* with the RSSD so you'll want it to be 'close' network
> wise (eg, probably not more than 1-2 ms ping time difference) otherwise
> you could see some degradation in repserver performance due to excessive
> network delays with the RSSD
>
>> 3. Where to put Replication Server working database if there is no Sybase
>> ASE on Replication Server machine - on Production or Reporting?
>
> This really depends on your network capabilities and the type of
> replication setup you plan on using (eg, table-level replication, warm
> standby, MSA).
>
> Keep in mind that if the repserver is hosted on a machine other than the
> Production database machine ... if the Production database machine goes
> down then repserver can continue to replicate any transactions it has in
> its internal queues.
>
>> 4. If Replication Server is installed on separate machine (Replication
>> Server machine), where will Replication Agent reside, and how it will
>> communicate with Primary Sybase ASE?
>
> The ASE repagent is actually a thread internal to the ASE dataserver (ie,
> the repagent code is part of the ASE binary so there's no need for a
> standalone repagent binary).
>
>> 5. Is there something to be installed on Primary (or on Replicate)
>> database
>> server in order to support this architecture?
>
> The rs_init (OS-level) program is used to add databases (PDB and RDB) to
> the replication environment. rs_init takes care of loading all the
> necessary components into your ASE databases.
>
> Out of the box, repserver replicates INSERT/UPDATE/DELETE statements. If
> you have a need to manipulate these statements (eg, ignore DELETEs, turn
> UPDATEs into 2 INSERTs in order to maintain histories, etc) before they're
> issued against the replicate/reporting database then you'll likely need to
> design some custom function strings ... *you* have to write these and load
> them into the repserver.
>
>> 6. If I want to set up this environment by using Sybase Central which is
>> running on Windows machine, where to find Sybase Central plug-in for
>> Replication Server, if Replication Server installation is for HPUX?
>
> Sorry, I don't use Sybase Central ... so you'll have to wait for someone
> else to come along with an answer.
>
> Alternatively, look at the rs_init program (comes with the repserver
> binary installation). rs_init is a standalone program (ie, doesn't
> require Sybase Central or any plugins) that allows you perform the initial
> repserver setup, as well as adding databases to the replication
> environment.