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.

Mobilink Reset

13 posts in General Discussion Last posting was on 2007-11-15 13:59:26.0Z
Herman Miller Posted on 2007-10-29 16:51:28.0Z
Sender: 2cd5.47261c99.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Mobilink Reset
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47261da0.2cec.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Oct 2007 09:51:28 -0700
X-Trace: forums-1-dub 1193680288 10.22.241.41 (29 Oct 2007 09:51:28 -0700)
X-Original-Trace: 29 Oct 2007 09:51:28 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6495
Article PK: 3113

We have several centers uploaded data to a consolidated db
with no data downloading, if the data in the consolidated
was to go off, what is the easiest way to resync without
rebuilding the data at the center and erasing this same data
from the consolidated database?


Herman Miller Posted on 2007-10-31 10:20:21.0Z
Sender: 5ec2.47286480.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink Reset
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <472864f5.5ec8.1681692777@sybase.com>
References: <47261da0.2cec.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Oct 2007 03:20:21 -0700
X-Trace: forums-1-dub 1193829621 10.22.241.41 (31 Oct 2007 03:20:21 -0700)
X-Original-Trace: 31 Oct 2007 03:20:21 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6502
Article PK: 4786

From what I have read the only way to do this is by
rebuilding the database and resetting the subscription.
Because mobilink keeps track of the last offset from the
transaction log, isn't there a way to just reset the offset
to zero?

> We have several centers uploaded data to a consolidated db
> with no data downloading, if the data in the consolidated
> was to go off, what is the easiest way to resync without
> rebuilding the data at the center and erasing this same
> data from the consolidated database?


Rob Waywell Posted on 2007-10-31 13:18:21.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <47261da0.2cec.1681692777@sybase.com> <472864f5.5ec8.1681692777@sybase.com>
Subject: Re: Mobilink Reset
Lines: 51
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: <47288ead$1@forums-1-dub>
Date: 31 Oct 2007 06:18:21 -0700
X-Trace: forums-1-dub 1193840301 10.25.98.235 (31 Oct 2007 06:18:21 -0700)
X-Original-Trace: 31 Oct 2007 06:18:21 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6504
Article PK: 3117

Herman,
Can you clarify what you are considering when you describe " if the data
in the consolidated
was to go off"?

Are you picturing a situation in which the consolidated database has
become corrupt and needs to be restored from a backup? Or are you picturing
a situation where the synchronization is failing for some reason?

In order to discuss the best backup and recovery approach, we need to
properly understand the scenario that you are preparing for.

I can see that you are making good progress ramping up with MobiLink. A
number of our customer's have found it worthwhile to engage our Professional
Services folks to help 'jumpstart' their projects. If you are interested in
having some hands-on assistance with the architecture, design, or
implementation of your MobiLink project, I'd be happy to discuss the ways in
which we can assist.

--
-----------------------------------------------
Robert Waywell
Technical Services Manager
Sybase iAnywhere

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

<Herman Miller> wrote in message news:472864f5.5ec8.1681692777@sybase.com...
> From what I have read the only way to do this is by
> rebuilding the database and resetting the subscription.
> Because mobilink keeps track of the last offset from the
> transaction log, isn't there a way to just reset the offset
> to zero?
>
>
>> We have several centers uploaded data to a consolidated db
>> with no data downloading, if the data in the consolidated
>> was to go off, what is the easiest way to resync without
>> rebuilding the data at the center and erasing this same
>> data from the consolidated database?


Herman Miller Posted on 2007-10-31 16:32:07.0Z
Sender: 6992.4728bb2f.1804289383@sybase.com
From: Herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink Reset
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4728bc17.69a2.1681692777@sybase.com>
References: <47288ead$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 31 Oct 2007 09:32:07 -0700
X-Trace: forums-1-dub 1193851927 10.22.241.41 (31 Oct 2007 09:32:07 -0700)
X-Original-Trace: 31 Oct 2007 09:32:07 -0700, 10.22.241.41
Lines: 64
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6505
Article PK: 4788

Currently we have Mobilink working in Upload mode only to
the consolidated database. I am picturing a situation where
the consolidated data does not match the remote database. At
this point I would need to restore the consolidated database
with the remote data. I looking for easiest way to do this
without rebuilding the remote database.

> Herman,
> Can you clarify what you are considering when you
> describe " if the data in the consolidated
> was to go off"?
>
> Are you picturing a situation in which the
> consolidated database has become corrupt and needs to be
> restored from a backup? Or are you picturing a situation
> where the synchronization is failing for some reason?
>
> In order to discuss the best backup and recovery
> approach, we need to properly understand the scenario
> that you are preparing for.
>
> I can see that you are making good progress ramping up
> with MobiLink. A number of our customer's have found it
> worthwhile to engage our Professional Services folks to
> help 'jumpstart' their projects. If you are interested in
> having some hands-on assistance with the architecture,
> design, or implementation of your MobiLink project, I'd
> be happy to discuss the ways in which we can assist.
>
> --
> -----------------------------------------------
> Robert Waywell
> Technical Services Manager
> Sybase iAnywhere
>
> 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
>
> <Herman Miller> wrote in message
> > news:472864f5.5ec8.1681692777@sybase.com... From what I
> > have read the only way to do this is by rebuilding the
> > database and resetting the subscription. Because
> > mobilink keeps track of the last offset from the
> transaction log, isn't there a way to just reset the
> > offset to zero?
> >
> >
> >> We have several centers uploaded data to a consolidated
> db >> with no data downloading, if the data in the
> consolidated >> was to go off, what is the easiest way to
> resync without >> rebuilding the data at the center and
> erasing this same >> data from the consolidated database?
>
>


Kory Hodgson <khodgson Posted on 2007-11-01 12:11:37.0Z
From: Kory Hodgson <khodgson@nospam_sybase.com>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink Reset
References: <47288ead$1@forums-1-dub> <4728bc17.69a2.1681692777@sybase.com>
In-Reply-To: <4728bc17.69a2.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: khodgson-pc.sybase.com
X-Original-NNTP-Posting-Host: khodgson-pc.sybase.com
Message-ID: <4729d089$1@forums-1-dub>
Date: 1 Nov 2007 05:11:37 -0700
X-Trace: forums-1-dub 1193922697 10.25.98.119 (1 Nov 2007 05:11:37 -0700)
X-Original-Trace: 1 Nov 2007 05:11:37 -0700, khodgson-pc.sybase.com
Lines: 91
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6510
Article PK: 4790

Herman,

I am slightly confused - it seems like you are saying that the scenario
you are considering is the consolidated database and the remote become
"out of sync" and then you want to restore the consolidate from the remote?

I am wondering if you can discuss your topology here a bit, is there
only one remote? Otherwise restoring the consolidated from the remote
when their is an upload only synchronization model would miss all the
data from other remotes.

It sounds like that you are trying to plan for a scenario where our
synchronization technology fails. From your concerns it seems like it
the only reason a situation like you are describing could occur would be
from an error in synchronization, in which case you would need to
determine the cause of this error and then proceed with the
synchronization after this has been corrected, or through some sort of
corruption in which case I think the best solution here is to implement
a good backup and recovery plan.

Here is a good whitepaper discussing backup and recovery:
http://www.ianywhere.com/whitepapers/SA_backup.html

Kory Hodgson
Sybase iAnywhere

Herman Miller wrote:
> Currently we have Mobilink working in Upload mode only to
> the consolidated database. I am picturing a situation where
> the consolidated data does not match the remote database. At
> this point I would need to restore the consolidated database
> with the remote data. I looking for easiest way to do this
> without rebuilding the remote database.
>
>
>> Herman,
>> Can you clarify what you are considering when you
>> describe " if the data in the consolidated
>> was to go off"?
>>
>> Are you picturing a situation in which the
>> consolidated database has become corrupt and needs to be
>> restored from a backup? Or are you picturing a situation
>> where the synchronization is failing for some reason?
>>
>> In order to discuss the best backup and recovery
>> approach, we need to properly understand the scenario
>> that you are preparing for.
>>
>> I can see that you are making good progress ramping up
>> with MobiLink. A number of our customer's have found it
>> worthwhile to engage our Professional Services folks to
>> help 'jumpstart' their projects. If you are interested in
>> having some hands-on assistance with the architecture,
>> design, or implementation of your MobiLink project, I'd
>> be happy to discuss the ways in which we can assist.
>>
>> --
>> -----------------------------------------------
>> Robert Waywell
>> Technical Services Manager
>> Sybase iAnywhere
>>
>> 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
>>
>> <Herman Miller> wrote in message
>>> news:472864f5.5ec8.1681692777@sybase.com... From what I
>>> have read the only way to do this is by rebuilding the
>>> database and resetting the subscription. Because
>>> mobilink keeps track of the last offset from the
>> transaction log, isn't there a way to just reset the
>>> offset to zero?
>>>
>>>
>>>> We have several centers uploaded data to a consolidated
>> db >> with no data downloading, if the data in the
>> consolidated >> was to go off, what is the easiest way to
>> resync without >> rebuilding the data at the center and
>> erasing this same >> data from the consolidated database?
>>
>>


Herman Miller Posted on 2007-11-01 12:43:39.0Z
Sender: 5b8.4729d406.1804289383@sybase.com
From: herman Miller
Newsgroups: ianywhere.public.general
Subject: Re: Mobilink Reset
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4729d80b.624.1681692777@sybase.com>
References: <4729d089$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 1 Nov 2007 05:43:39 -0700
X-Trace: forums-1-dub 1193924619 10.22.241.41 (1 Nov 2007 05:43:39 -0700)
X-Original-Trace: 1 Nov 2007 05:43:39 -0700, 10.22.241.41
Lines: 108
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6516
Article PK: 4794

Let me re-explain. I know we are talking Mobilink but I have
to mention DbRemote because we use that also. In the
DbRemote environment, there are times when the data at the
remote sites doesn't match the data at the consolidated
site. In this case we need to resync the data and recreate
the relationship.
If we run into the same situation with Mobilink, is there a
resync procedure other than rebuilding the database at the
remote site?

> Herman,
>
> I am slightly confused - it seems like you are saying that
> the scenario you are considering is the consolidated
> database and the remote become "out of sync" and then you
> want to restore the consolidate from the remote?
>
> I am wondering if you can discuss your topology here a bit
> , is there only one remote? Otherwise restoring the
> consolidated from the remote when their is an upload only
> synchronization model would miss all the data from other
> remotes.
>
> It sounds like that you are trying to plan for a scenario
> where our synchronization technology fails. From your
> concerns it seems like it the only reason a situation
> like you are describing could occur would be from an
> error in synchronization, in which case you would need to
> determine the cause of this error and then proceed with
> the synchronization after this has been corrected, or
> through some sort of corruption in which case I think the
> best solution here is to implement a good backup and
> recovery plan.
>
> Here is a good whitepaper discussing backup and recovery:
> http://www.ianywhere.com/whitepapers/SA_backup.html
>
> Kory Hodgson
> Sybase iAnywhere
>
>
> Herman Miller wrote:
> > Currently we have Mobilink working in Upload mode only
> > to the consolidated database. I am picturing a situation
> > where the consolidated data does not match the remote
> > database. At this point I would need to restore the
> > consolidated database with the remote data. I looking
> > for easiest way to do this without rebuilding the remote
> > database.
> >
> >> Herman,
> >> Can you clarify what you are considering when you
> >> describe " if the data in the consolidated
> >> was to go off"?
> >>
> >> Are you picturing a situation in which the
> >> consolidated database has become corrupt and needs to
> be >> restored from a backup? Or are you picturing a
> situation >> where the synchronization is failing for some
> reason? >>
> >> In order to discuss the best backup and recovery
> >> approach, we need to properly understand the scenario
> >> that you are preparing for.
> >>
> >> I can see that you are making good progress ramping
> up >> with MobiLink. A number of our customer's have
> found it >> worthwhile to engage our Professional
> Services folks to >> help 'jumpstart' their projects. If
> you are interested in >> having some hands-on assistance
> with the architecture, >> design, or implementation of
> your MobiLink project, I'd >> be happy to discuss the ways
> in which we can assist. >>
> >> --
> >> -----------------------------------------------
> >> Robert Waywell
> >> Technical Services Manager
> >> Sybase iAnywhere
> >>
> >> 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
> >>
> >> <Herman Miller> wrote in message
> >>> news:472864f5.5ec8.1681692777@sybase.com... From what
> I >>> have read the only way to do this is by rebuilding
> the >>> database and resetting the subscription. Because
> >>> mobilink keeps track of the last offset from the
> >> transaction log, isn't there a way to just reset the
> >>> offset to zero?
> >>>
> >>>
> >>>> We have several centers uploaded data to a
> consolidated >> db >> with no data downloading, if the
> data in the >> consolidated >> was to go off, what is the
> easiest way to >> resync without >> rebuilding the data at
> the center and >> erasing this same >> data from the
> consolidated database? >>
> >>