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.

M-Business Anywhere installed on the SD Card as opposed to the device

3 posts in General Discussion Last posting was on 2009-03-20 08:31:15.0Z
Shao Chan Posted on 2009-03-19 16:00:00.0Z
Reply-To: "Shao Chan" <noreply@noreply.com>
From: "Shao Chan" <noreply@noreply.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: M-Business Anywhere installed on the SD Card as opposed to the device
Lines: 41
Organization: Civica
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.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c26c00@forums-1-dub>
Date: 19 Mar 2009 08:00:00 -0800
X-Trace: forums-1-dub 1237478400 10.22.241.152 (19 Mar 2009 08:00:00 -0800)
X-Original-Trace: 19 Mar 2009 08:00:00 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1350
Article PK: 9384

SQL Anywhere 9.0.2.latest.e.b.f about to be upgraded to 11.0.1.latest.e.b.f.

Hi all,

We currently have an application which runs on an M-Biz client and makes use
of Mobilink and the Ultralite database.

At the moment, we install on the device for 2 main reasons:
1) Performance. We assume that the device is faster than the SD Card.
2) Reliability. In general, we have heard in the past that SD Card writes
were unreliable.

Now, our application wants to make greater use of the M-Biz functionality.
We wish to allow our customers to setup documents on the handheld and we
will train them in creating channels so that they can access them.

The problem I have is that the device is quite limited in size and so an
external SD Card might be better.

1) Does this mean that the M-Biz client has to be installed on the SD Card
so that by default all synchronised items are on the SD Card to make use of
its capacity?

As far as I know, the answer to 1) is that it has to be installed on the SD
Card. Therefore, this will mean as far as I am aware, that our application
will also be synchronised down to the SD Card and that the database we
create will then be on the SD Card.

I assume we can try to change our code so that rather than create the
database relative to dbMgr.directory, we can try to just hard code the
directory somewhere else?

Can anyone recommend any approachs forward so that our database application
stays on the device but the M-Biz channel information stays on the SD card
and also any pitfalls if we succeed in doing this.

Cheers,

Shao


Jeff Albion [Sybase iAnywhere] Posted on 2009-03-19 21:02:16.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.mbusinessanywhere.general
Subject: Re: M-Business Anywhere installed on the SD Card as opposed to the device
References: <49c26c00@forums-1-dub>
In-Reply-To: <49c26c00@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: <49c2b2d8$1@forums-1-dub>
Date: 19 Mar 2009 13:02:16 -0800
X-Trace: forums-1-dub 1237496536 10.22.241.152 (19 Mar 2009 13:02:16 -0800)
X-Original-Trace: 19 Mar 2009 13:02:16 -0800, vip152.sybase.com
Lines: 69
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1351
Article PK: 17963

Shao,

Shao Chan wrote:
> Now, our application wants to make greater use of the M-Biz functionality.
> We wish to allow our customers to setup documents on the handheld and we
> will train them in creating channels so that they can access them.
>
> The problem I have is that the device is quite limited in size and so an
> external SD Card might be better.
>
> 1) Does this mean that the M-Biz client has to be installed on the SD Card
> so that by default all synchronised items are on the SD Card to make use of
> its capacity?

By default, if you're just using the default channel sync, all (binary)
data will get dumped into \AvantGo\Pods. The location of \AvantGo will
determine where exactly that is.

> As far as I know, the answer to 1) is that it has to be installed on the SD
> Card. Therefore, this will mean as far as I am aware, that our application
> will also be synchronised down to the SD Card and that the database we
> create will then be on the SD Card.

Yes, my understanding is the same.

> I assume we can try to change our code so that rather than create the
> database relative to dbMgr.directory, we can try to just hard code the
> directory somewhere else?

I'm not sure if we (or Microsoft) restricts this ability in any way. I
haven't tried it myself, but I would assume we'd be able to do this.

> Can anyone recommend any approachs forward so that our database application
> stays on the device but the M-Biz channel information stays on the SD card
> and also any pitfalls if we succeed in doing this.

If you can't move the UltraLite database via code and you're forced to
store it on the SD card, the standard "you'll need to talk to your
device/SD card vendor" advice comes in here. WM devices have a number of
assorted issues concerning the I/O subsystem:

1. What does the device / memory card vendor guarantee about I/O
write-through? If you reset the device, are all outstanding writes
guaranteed to make it out to the SD card before it resets?

2. What does the device do when "mounting" and "unmounting" the SD card
(i.e. upon a device restart/shutdown)? What's the timeout configuration
concerning that?

3. Turn page checksums on if they aren't already. Corruptions may be
minimized if we can detect corrupted pages in the database "sooner"
rather than "later" after further damage has been done.

---

Please let us know if the database creation in an alternate location
works out for you.

Cheers,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/


Shao Chan Posted on 2009-03-20 08:31:15.0Z
From: "Shao Chan" <NoSpam@NoSpam.com>
Newsgroups: ianywhere.public.mbusinessanywhere.general
References: <49c26c00@forums-1-dub> <49c2b2d8$1@forums-1-dub>
Subject: Re: M-Business Anywhere installed on the SD Card as opposed to the device
Lines: 90
Organization: Civica
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.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c35453$1@forums-1-dub>
Date: 20 Mar 2009 00:31:15 -0800
X-Trace: forums-1-dub 1237537875 10.22.241.152 (20 Mar 2009 00:31:15 -0800)
X-Original-Trace: 20 Mar 2009 00:31:15 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.mbusinessanywhere.general:1352
Article PK: 9386

Hi Jeff,

Thanks for the feedback. I never thought about the unmounting of the SD
card causing problems.

Also, some of our customers use TomTom which uses up the slot and so that
might not be a reliable way forwards with all our customers.

I'll try to find out more and will post back.

Thanks.

Shao

"Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com> wrote in
message news:49c2b2d8$1@forums-1-dub...
> Shao,
>
> Shao Chan wrote:
>> Now, our application wants to make greater use of the M-Biz
>> functionality. We wish to allow our customers to setup documents on the
>> handheld and we will train them in creating channels so that they can
>> access them.
>>
>> The problem I have is that the device is quite limited in size and so an
>> external SD Card might be better.
>>
>> 1) Does this mean that the M-Biz client has to be installed on the SD
>> Card so that by default all synchronised items are on the SD Card to make
>> use of its capacity?
>
> By default, if you're just using the default channel sync, all (binary)
> data will get dumped into \AvantGo\Pods. The location of \AvantGo will
> determine where exactly that is.
>
>> As far as I know, the answer to 1) is that it has to be installed on the
>> SD Card. Therefore, this will mean as far as I am aware, that our
>> application will also be synchronised down to the SD Card and that the
>> database we create will then be on the SD Card.
>
> Yes, my understanding is the same.
>
>> I assume we can try to change our code so that rather than create the
>> database relative to dbMgr.directory, we can try to just hard code the
>> directory somewhere else?
>
> I'm not sure if we (or Microsoft) restricts this ability in any way. I
> haven't tried it myself, but I would assume we'd be able to do this.
>
>> Can anyone recommend any approachs forward so that our database
>> application stays on the device but the M-Biz channel information stays
>> on the SD card and also any pitfalls if we succeed in doing this.
>
> If you can't move the UltraLite database via code and you're forced to
> store it on the SD card, the standard "you'll need to talk to your
> device/SD card vendor" advice comes in here. WM devices have a number of
> assorted issues concerning the I/O subsystem:
>
> 1. What does the device / memory card vendor guarantee about I/O
> write-through? If you reset the device, are all outstanding writes
> guaranteed to make it out to the SD card before it resets?
>
> 2. What does the device do when "mounting" and "unmounting" the SD card
> (i.e. upon a device restart/shutdown)? What's the timeout configuration
> concerning that?
>
> 3. Turn page checksums on if they aren't already. Corruptions may be
> minimized if we can detect corrupted pages in the database "sooner" rather
> than "later" after further damage has been done.
>
> ---
>
> Please let us know if the database creation in an alternate location works
> out for you.
>
> Cheers,
>
> --
> Jeff Albion, Sybase iAnywhere
>
> iAnywhere Developer Community :
> http://www.sybase.com/developer/library/sql-anywhere-techcorner
> iAnywhere Documentation :
> http://www.ianywhere.com/developer/product_manuals
> SQL Anywhere Patches and EBFs :
> http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
> Report a Bug/Open a Case : http://case-express.sybase.com/cx/