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.

ws replicate db with # owners

4 posts in General Discussion Last posting was on 2012-03-05 03:53:06.0Z
Isabella Posted on 2012-02-14 16:44:33.0Z
From: Isabella <isabella.ghiurea@nrc-cnrc.gc.ca>
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: ws replicate db with # owners
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f3a8f71@forums-1-dub>
Date: 14 Feb 2012 08:44:33 -0800
X-Trace: forums-1-dub 1329237873 10.22.241.152 (14 Feb 2012 08:44:33 -0800)
X-Original-Trace: 14 Feb 2012 08:44:33 -0800, vip152.sybase.com
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9147
Article PK: 870310

Hi Gurus,
I would like to know if will work to cfg a warm standby db (
sp_setreplicate with same objects name but a set of different owners for
each set of objects, I do not indent to create table replication
definition ? Would this work with Rep server 15.5 ?
Thank you
Isabella


"Mark A. Parsons" <iron_horse Posted on 2012-02-15 00:17:34.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.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: ws replicate db with # owners
References: <4f3a8f71@forums-1-dub>
In-Reply-To: <4f3a8f71@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f3af99e@forums-1-dub>
Date: 14 Feb 2012 16:17:34 -0800
X-Trace: forums-1-dub 1329265054 10.22.241.152 (14 Feb 2012 16:17:34 -0800)
X-Original-Trace: 14 Feb 2012 16:17:34 -0800, vip152.sybase.com
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9148
Article PK: 870311

Yes, WS should take care of insuring records get replicated to the correct table based on owner.table.

No repdefs are needed.

If you do add repdefs you typically want to do it for all tables named <table_name>, ie, leave off the owner. [It is
possible to add the owner to the repdef but then you have to mark table for rep on and with owner on.]

On the other hand ... try it and see what happens.

On 02/14/2012 09:44, Isabella wrote:
> Hi Gurus,
> I would like to know if will work to cfg a warm standby db ( sp_setreplicate with same objects name but a set of
> different owners for each set of objects, I do not indent to create table replication definition ? Would this work with
> Rep server 15.5 ?
> Thank you
> Isabella


Isabella Posted on 2012-02-15 16:08:39.0Z
From: Isabella <isabella.ghiurea@nrc-cnrc.gc.ca>
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: ws replicate db with # owners
References: <4f3a8f71@forums-1-dub> <4f3af99e@forums-1-dub>
In-Reply-To: <4f3af99e@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f3bd887@forums-1-dub>
Date: 15 Feb 2012 08:08:39 -0800
X-Trace: forums-1-dub 1329322119 10.22.241.152 (15 Feb 2012 08:08:39 -0800)
X-Original-Trace: 15 Feb 2012 08:08:39 -0800, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9149
Article PK: 870312

Thank you Mark.
I need to know if would be sufficient to have rep user account alias
to dbo only , no to non-dbo account ?
I assume next I will have to be sure non-dbo user grants full
privileges to rep maint account. Would this be settings bee enough ?
Isabella

Mark A. Parsons wrote:
> Yes, WS should take care of insuring records get replicated to the
> correct table based on owner.table.
>
> No repdefs are needed.
>
> If you do add repdefs you typically want to do it for all tables named
> <table_name>, ie, leave off the owner. [It is possible to add the owner
> to the repdef but then you have to mark table for rep on and with owner
> on.]
>
> On the other hand ... try it and see what happens.
>
> On 02/14/2012 09:44, Isabella wrote:
>> Hi Gurus,
>> I would like to know if will work to cfg a warm standby db (
>> sp_setreplicate with same objects name but a set of
>> different owners for each set of objects, I do not indent to create
>> table replication definition ? Would this work with
>> Rep server 15.5 ?
>> Thank you
>> Isabella


Jeff Tallman [Sybase] Posted on 2012-03-05 03:53:06.0Z
From: "Jeff Tallman [Sybase]" <jeff.tallman@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: ws replicate db with # owners
References: <4f3a8f71@forums-1-dub> <4f3af99e@forums-1-dub> <4f3bd887@forums-1-dub>
In-Reply-To: <4f3bd887@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f5438a2@forums-1-dub>
Date: 4 Mar 2012 19:53:06 -0800
X-Trace: forums-1-dub 1330919586 10.22.241.152 (4 Mar 2012 19:53:06 -0800)
X-Original-Trace: 4 Mar 2012 19:53:06 -0800, vip152.sybase.com
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9175
Article PK: 870338

A lot of corrections are necessary to these answers:

1) Do not call sp_setreplicate....it is deprecated. Use sp_setreptable
instead..... or sp_reptostandby.

2) If you have 2 or more tables with the same name but different owners,
you will have to ensure the owner mode is on (which is default I think
of sp_reptostandby). I prefer not to make guesses and simply would use
sp_setreptable <tablename>, 'true','owner_on'.... You can autogenerate
this with a simple query against sysobjects where type='U' and name not
like rs_% .....no real typing required.

3) While you don't need repdefs for WS/MSA - it is highly recommended if
performance is a consideration UNLESS you are running ASE 15.7 and RS
15.7 and are using the new feature in which the RepAgent puts the pkey
info in the LTL stream. Otherwise, performance will suffer on updates
and deletes as RS will construct where clauses with all the
columns/values and ASE will have to process every one of them -
including that 500 character comment field.

On 2/15/2012 11:08 AM, Isabella wrote:
> Thank you Mark.
> I need to know if would be sufficient to have rep user account alias to
> dbo only , no to non-dbo account ?
> I assume next I will have to be sure non-dbo user grants full privileges
> to rep maint account. Would this be settings bee enough ?
> Isabella
>
> Mark A. Parsons wrote:
>> Yes, WS should take care of insuring records get replicated to the
>> correct table based on owner.table.
>>
>> No repdefs are needed.
>>
>> If you do add repdefs you typically want to do it for all tables named
>> <table_name>, ie, leave off the owner. [It is possible to add the
>> owner to the repdef but then you have to mark table for rep on and
>> with owner on.]
>>
>> On the other hand ... try it and see what happens.
>>
>> On 02/14/2012 09:44, Isabella wrote:
>>> Hi Gurus,
>>> I would like to know if will work to cfg a warm standby db (
>>> sp_setreplicate with same objects name but a set of
>>> different owners for each set of objects, I do not indent to create
>>> table replication definition ? Would this work with
>>> Rep server 15.5 ?
>>> Thank you
>>> Isabella