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.

DBRemote

10 posts in General Discussion Last posting was on 2007-10-23 13:30:35.0Z
Herman Miller Posted on 2007-10-18 18:55:41.0Z
Sender: 1356.4717aae4.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: DBRemote
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4717ac2d.1370.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Oct 2007 11:55:41 -0700
X-Trace: forums-1-dub 1192733741 10.22.241.41 (18 Oct 2007 11:55:41 -0700)
X-Original-Trace: 18 Oct 2007 11:55:41 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6433
Article PK: 2889

How does DBRemote know which records to read from
transaction log to send to consolidated?


Breck Carter [Team iAnywhere] Posted on 2007-10-19 11:33:26.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: DBRemote
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <u55hh358u3ssot19o8pv4td92cou0ju7ju@4ax.com>
References: <4717ac2d.1370.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 19 Oct 2007 04:33:26 -0700
X-Trace: forums-1-dub 1192793606 64.7.134.118 (19 Oct 2007 04:33:26 -0700)
X-Original-Trace: 19 Oct 2007 04:33:26 -0700, bcarter.sentex.ca
Lines: 25
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6436
Article PK: 2898

On the remote database, there is a "publication" which names the
tables and columns that are available for replication, and a
"subscription" which names the "subscriber" (the consolidated
database" which "subscribes to" (receives) the data that is defined in
the publication. A subscription is a mapping between subscriber user
id and publication.

Dbremote uses this information to find the changes (inserts updates
deletes) made to the data which match the subscription, in the
transaction log of the remote database, and sends it to the
consolidated.

Breck

On 18 Oct 2007 11:55:41 -0700, Herman Miller wrote:

>How does DBRemote know which records to read from
>transaction log to send to consolidated?

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Herman Miller Posted on 2007-10-19 12:54:58.0Z
Sender: 2893.4718a89a.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: DBRemote
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4718a922.289e.1681692777@sybase.com>
References: <u55hh358u3ssot19o8pv4td92cou0ju7ju@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Oct 2007 05:54:58 -0700
X-Trace: forums-1-dub 1192798498 10.22.241.41 (19 Oct 2007 05:54:58 -0700)
X-Original-Trace: 19 Oct 2007 05:54:58 -0700, 10.22.241.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6438
Article PK: 4752

What would cause the Publisher to stop picking up changes
from the tranaction log to send the subscriber?

> On the remote database, there is a "publication" which
> names the tables and columns that are available for
> replication, and a "subscription" which names the
> "subscriber" (the consolidated database" which "subscribes
> to" (receives) the data that is defined in the
> publication. A subscription is a mapping between
> subscriber user id and publication.
>
> Dbremote uses this information to find the changes
> (inserts updates deletes) made to the data which match the
> subscription, in the transaction log of the remote
> database, and sends it to the consolidated.
>
> Breck
>
> On 18 Oct 2007 11:55:41 -0700, Herman Miller wrote:
>
> >How does DBRemote know which records to read from
> >transaction log to send to consolidated?
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
>
http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Breck Carter [Team iAnywhere] Posted on 2007-10-19 13:06:39.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: DBRemote
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <tpahh3t9228k4iita86b91ifj9ebvaqcgq@4ax.com>
References: <u55hh358u3ssot19o8pv4td92cou0ju7ju@4ax.com> <4718a922.289e.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 19 Oct 2007 06:06:39 -0700
X-Trace: forums-1-dub 1192799199 64.7.134.118 (19 Oct 2007 06:06:39 -0700)
X-Original-Trace: 19 Oct 2007 06:06:39 -0700, bcarter.sentex.ca
Lines: 47
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6439
Article PK: 4754

All I can think of is (a) no changes are being made to rows that are
included in the publication, or (b) the subscription was dropped.

Has anyone been making changes via passthrough?

Breck

On 19 Oct 2007 05:54:58 -0700, Herman Miller wrote:

>What would cause the Publisher to stop picking up changes
>from the tranaction log to send the subscriber?
>
>> On the remote database, there is a "publication" which
>> names the tables and columns that are available for
>> replication, and a "subscription" which names the
>> "subscriber" (the consolidated database" which "subscribes
>> to" (receives) the data that is defined in the
>> publication. A subscription is a mapping between
>> subscriber user id and publication.
>>
>> Dbremote uses this information to find the changes
>> (inserts updates deletes) made to the data which match the
>> subscription, in the transaction log of the remote
>> database, and sends it to the consolidated.
>>
>> Breck
>>
>> On 18 Oct 2007 11:55:41 -0700, Herman Miller wrote:
>>
>> >How does DBRemote know which records to read from
>> >transaction log to send to consolidated?
>>
>> --
>> Breck Carter [Team iAnywhere]
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com
>> The book:
>>
>http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>> breck.carter@risingroad.com

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Rob Waywell Posted on 2007-10-19 13:21:29.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <u55hh358u3ssot19o8pv4td92cou0ju7ju@4ax.com> <4718a922.289e.1681692777@sybase.com> <tpahh3t9228k4iita86b91ifj9ebvaqcgq@4ax.com>
Subject: Re: DBRemote
Lines: 91
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <4718af59$1@forums-1-dub>
Date: 19 Oct 2007 06:21:29 -0700
X-Trace: forums-1-dub 1192800089 10.25.98.235 (19 Oct 2007 06:21:29 -0700)
X-Original-Trace: 19 Oct 2007 06:21:29 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6441
Article PK: 4756

I'll add:

c) changes have been made but not committed

A good next step would be to have the remote user explicitly make a change
and commit the operation. Then run dbremote with the -v -o remote_output.txt
switches added.

It would also be good to remind us which versions of SQL Anywhere and
DBRemote you are using.

Please note - The newsgroups provide a great interactive user community that
is often a very valuable resource to assist with problem solving. The
newsgroups are not, however, a formal technical support channel and do not
provide case tracking nor response time commitments. Since this appears to
be an urgent issue I would recommend opening a case with Technical Support.
Options for contacting Technical Support are provided at:

http://www.ianywhere.com/support/contact/contact_support.html

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:tpahh3t9228k4iita86b91ifj9ebvaqcgq@4ax.com...
> All I can think of is (a) no changes are being made to rows that are
> included in the publication, or (b) the subscription was dropped.
>
> Has anyone been making changes via passthrough?
>
> Breck
>
> On 19 Oct 2007 05:54:58 -0700, Herman Miller wrote:
>
>>What would cause the Publisher to stop picking up changes
>>from the tranaction log to send the subscriber?
>>
>>> On the remote database, there is a "publication" which
>>> names the tables and columns that are available for
>>> replication, and a "subscription" which names the
>>> "subscriber" (the consolidated database" which "subscribes
>>> to" (receives) the data that is defined in the
>>> publication. A subscription is a mapping between
>>> subscriber user id and publication.
>>>
>>> Dbremote uses this information to find the changes
>>> (inserts updates deletes) made to the data which match the
>>> subscription, in the transaction log of the remote
>>> database, and sends it to the consolidated.
>>>
>>> Breck
>>>
>>> On 18 Oct 2007 11:55:41 -0700, Herman Miller wrote:
>>>
>>> >How does DBRemote know which records to read from
>>> >transaction log to send to consolidated?
>>>
>>> --
>>> Breck Carter [Team iAnywhere]
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> www.risingroad.com
>>> The book:
>>>
>>http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
>>> breck.carter@risingroad.com
>
> --
> Breck Carter [Team iAnywhere]
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
> The book:
> http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> breck.carter@risingroad.com


Herman Miller Posted on 2007-10-19 13:32:48.0Z
Sender: 296c.4718b18c.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: DBRemote
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4718b200.2976.1681692777@sybase.com>
References: <4718af59$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Oct 2007 06:32:48 -0700
X-Trace: forums-1-dub 1192800768 10.22.241.41 (19 Oct 2007 06:32:48 -0700)
X-Original-Trace: 19 Oct 2007 06:32:48 -0700, 10.22.241.41
Lines: 102
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6445
Article PK: 4758

Version 9

> I'll add:
>
> c) changes have been made but not committed
>
> A good next step would be to have the remote user
> explicitly make a change and commit the operation. Then
> run dbremote with the -v -o remote_output.txt switches
> added.
>
> It would also be good to remind us which versions of SQL
> Anywhere and DBRemote you are using.
>
> Please note - The newsgroups provide a great interactive
> user community that is often a very valuable resource to
> assist with problem solving. The newsgroups are not,
> however, a formal technical support channel and do not
> provide case tracking nor response time commitments. Since
> this appears to be an urgent issue I would recommend
> opening a case with Technical Support. Options for
> contacting Technical Support are provided at:
>
>
http://www.ianywhere.com/support/contact/contact_support.html
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> "Breck Carter [Team iAnywhere]"
> <NOSPAM__bcarter@risingroad.com> wrote in message
> > news:tpahh3t9228k4iita86b91ifj9ebvaqcgq@4ax.com... All I
> can think of is (a) no changes are being made to rows that
> > are included in the publication, or (b) the subscription
> was dropped. >
> > Has anyone been making changes via passthrough?
> >
> > Breck
> >
> > On 19 Oct 2007 05:54:58 -0700, Herman Miller wrote:
> >
> >>What would cause the Publisher to stop picking up
> changes >>from the tranaction log to send the subscriber?
> >>
> >>> On the remote database, there is a "publication" which
> >>> names the tables and columns that are available for
> >>> replication, and a "subscription" which names the
> >>> "subscriber" (the consolidated database" which
> "subscribes >>> to" (receives) the data that is defined in
> the >>> publication. A subscription is a mapping between
> >>> subscriber user id and publication.
> >>>
> >>> Dbremote uses this information to find the changes
> >>> (inserts updates deletes) made to the data which match
> the >>> subscription, in the transaction log of the remote
> >>> database, and sends it to the consolidated.
> >>>
> >>> Breck
> >>>
> >>> On 18 Oct 2007 11:55:41 -0700, Herman Miller wrote:
> >>>
> >>> >How does DBRemote know which records to read from
> >>> >transaction log to send to consolidated?
> >>>
> >>> --
> >>> Breck Carter [Team iAnywhere]
> >>> RisingRoad SQL Anywhere and MobiLink Professional
> Services >>> www.risingroad.com
> >>> The book:
> >>>
> >>http://www.risingroad.com/SQL_Anywhere_Studio_9_Develope
> rs_Guide.html >>> breck.carter@risingroad.com
> >
> > --
> > Breck Carter [Team iAnywhere]
> > RisingRoad SQL Anywhere and MobiLink Professional
> > Services www.risingroad.com
> > The book:
> >
>
http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> > breck.carter@risingroad.com
>
>


Herman Miller Posted on 2007-10-19 13:34:21.0Z
Sender: 296c.4718b18c.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: DBRemote
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4718b25d.297d.1681692777@sybase.com>
References: <4718af59$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Oct 2007 06:34:21 -0700
X-Trace: forums-1-dub 1192800861 10.22.241.41 (19 Oct 2007 06:34:21 -0700)
X-Original-Trace: 19 Oct 2007 06:34:21 -0700, 10.22.241.41
Lines: 103
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6447
Article PK: 4759

If either the publisher or subscriber is dropped and
recreated on onside only. Does anything need to be done to
relink the 2?

> I'll add:
>
> c) changes have been made but not committed
>
> A good next step would be to have the remote user
> explicitly make a change and commit the operation. Then
> run dbremote with the -v -o remote_output.txt switches
> added.
>
> It would also be good to remind us which versions of SQL
> Anywhere and DBRemote you are using.
>
> Please note - The newsgroups provide a great interactive
> user community that is often a very valuable resource to
> assist with problem solving. The newsgroups are not,
> however, a formal technical support channel and do not
> provide case tracking nor response time commitments. Since
> this appears to be an urgent issue I would recommend
> opening a case with Technical Support. Options for
> contacting Technical Support are provided at:
>
>
http://www.ianywhere.com/support/contact/contact_support.html
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> "Breck Carter [Team iAnywhere]"
> <NOSPAM__bcarter@risingroad.com> wrote in message
> > news:tpahh3t9228k4iita86b91ifj9ebvaqcgq@4ax.com... All I
> can think of is (a) no changes are being made to rows that
> > are included in the publication, or (b) the subscription
> was dropped. >
> > Has anyone been making changes via passthrough?
> >
> > Breck
> >
> > On 19 Oct 2007 05:54:58 -0700, Herman Miller wrote:
> >
> >>What would cause the Publisher to stop picking up
> changes >>from the tranaction log to send the subscriber?
> >>
> >>> On the remote database, there is a "publication" which
> >>> names the tables and columns that are available for
> >>> replication, and a "subscription" which names the
> >>> "subscriber" (the consolidated database" which
> "subscribes >>> to" (receives) the data that is defined in
> the >>> publication. A subscription is a mapping between
> >>> subscriber user id and publication.
> >>>
> >>> Dbremote uses this information to find the changes
> >>> (inserts updates deletes) made to the data which match
> the >>> subscription, in the transaction log of the remote
> >>> database, and sends it to the consolidated.
> >>>
> >>> Breck
> >>>
> >>> On 18 Oct 2007 11:55:41 -0700, Herman Miller wrote:
> >>>
> >>> >How does DBRemote know which records to read from
> >>> >transaction log to send to consolidated?
> >>>
> >>> --
> >>> Breck Carter [Team iAnywhere]
> >>> RisingRoad SQL Anywhere and MobiLink Professional
> Services >>> www.risingroad.com
> >>> The book:
> >>>
> >>http://www.risingroad.com/SQL_Anywhere_Studio_9_Develope
> rs_Guide.html >>> breck.carter@risingroad.com
> >
> > --
> > Breck Carter [Team iAnywhere]
> > RisingRoad SQL Anywhere and MobiLink Professional
> > Services www.risingroad.com
> > The book:
> >
>
http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
> > breck.carter@risingroad.com
>
>