Hi guys ,

Couple of questions on stable queues, which may sound stupid but please
correct me if i'm wrong somewhere.

1. is outbound and inbound queues share the same partition (raw device)
or there has to be seperate device(partition) for outbound and inbound
queues ?

2. Are the count of stable queues depend upon the number of databases
marked for replication. For Eg there are 2 databases marked for
replication on same ASE server . Are we need to have seperate inbound
and outbound queue each for 2 databases ?

3. Is it true that if there are two replication server involved(PRS and
RRS) in a replication system then the "primary replication
server("PRS) will contain only inbound stable queue (but not "outbound
stable queues" ) and Replicate replication server (RRS) contain only
outbound queues (but not "inbound stable queues")

Any help is highly appreciated.
Thanks

Hello Su,

1 - My experience is on 12.0 and below, but as of those releases I
believe that outbound and inbound queues shared stable queue devices
.... I do not know if the newer releases allow device specific stable
queue placement.

2 - There is no relationship between the number of stable queues and
the number of databases participating in replication in a replication
domain.

3 - Any "type" of replication server always has both types of stable
queues. Remember, "inbound" and "outbound" refer to the direction of
data flow RELATIVE to the RS ... "inbound" means incoming data to the
replication server, and "outbound" refers to data leaving the RS either
for another RS (via a "route") or for a database server ...

Hope that helps,

Sara ...

su wrote:
> Hi guys ,
>
> Couple of questions on stable queues, which may sound stupid but please
> correct me if i'm wrong somewhere.
>
> 1. is outbound and inbound queues share the same partition (raw device)
> or there has to be seperate device(partition) for outbound and inbound
> queues ?
>
> 2. Are the count of stable queues depend upon the number of databases
> marked for replication. For Eg there are 2 databases marked for
> replication on same ASE server . Are we need to have seperate inbound
> and outbound queue each for 2 databases ?
>
> 3. Is it true that if there are two replication server involved(PRS and
> RRS) in a replication system then the "primary replication
> server("PRS) will contain only inbound stable queue (but not "outbound
> stable queues" ) and Replicate replication server (RRS) contain only
> outbound queues (but not "inbound stable queues")
>
> Any help is highly appreciated.
> Thanks