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.

about robust of ASA

6 posts in General Discussion Last posting was on 2005-10-18 14:56:11.0Z
Sunshine Posted on 2005-10-18 01:54:33.0Z
Reply-To: "Sunshine" <lijinhui@gmail.com>
From: "Sunshine" <lijinhui@gmail.com>
Newsgroups: ianywhere.public.general
Subject: about robust of ASA
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: jhli-mobile.sybase.com
X-Original-NNTP-Posting-Host: jhli-mobile.sybase.com
Message-ID: <435455d9@forums-1-dub>
Date: 17 Oct 2005 18:54:33 -0700
X-Trace: forums-1-dub 1129600473 158.77.123.177 (17 Oct 2005 18:54:33 -0700)
X-Original-Trace: 17 Oct 2005 18:54:33 -0700, jhli-mobile.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4862
Article PK: 31461

Application's running environment is very bad. Power cutting off often
arises suddenly.
Previous I use the file system rather than RDBMS to store data and submit to
consolidated database in order not to lose datas.
Now I want to use ASA and Mobilink to transfer data.
Could ASA be suitable for it?


Breck Carter [TeamSybase] Posted on 2005-10-18 07:55:33.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: about robust of ASA
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <gr99l1tvvpu8rf3n9ffp05msjugrq4egqk@4ax.com>
References: <435455d9@forums-1-dub>
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: 18 Oct 2005 00:55:33 -0700
X-Trace: forums-1-dub 1129622133 64.7.134.118 (18 Oct 2005 00:55:33 -0700)
X-Original-Trace: 18 Oct 2005 00:55:33 -0700, bcarter.sentex.ca
Lines: 38
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4864
Article PK: 8580

In addition to what Greg said... MobiLink handles the upload and
download stages as separate database transactions so if communication
is cut off, either the upload or download will be rolled back.

One of the main reasons folks use "databases" instead of "file
systems" is to prevent data corruption in the case of system failure.

There is a lot of material in the ASA Help file about this topic, a
whole chapter called "Backup and Data Recovery".

Also, there is long chapter called "Protecting" in my book; it
contains a detailed description of the automatic recovery process that
Greg talked about. It really is quite cool: you can pull the plug on
the server and it will recovery automatically on restart... I did that
once, instead of pulling the plug for my laptop at the end of the day,
I pulled the plug on a whole *rack* of test servers, lots of screaming
developers, but it was all OK when the machines rebooted. The head IT
guy did not get mad at me, he admitted he did it twice, on
*production* :)

Breck

On 17 Oct 2005 18:54:33 -0700, "Sunshine" <lijinhui@gmail.com> wrote:

>Application's running environment is very bad. Power cutting off often
>arises suddenly.
>Previous I use the file system rather than RDBMS to store data and submit to
>consolidated database in order not to lose datas.
>Now I want to use ASA and Mobilink to transfer data.
>Could ASA be suitable for it?
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


David Fishburn Posted on 2005-10-18 13:23:20.0Z
Newsgroups: ianywhere.public.general
Subject: Re: about robust of ASA
From: David Fishburn <fishburn_spam@off.ianywhere.com>
References: <435455d9@forums-1-dub> <gr99l1tvvpu8rf3n9ffp05msjugrq4egqk@4ax.com>
Organization: iAnywhere Solutions
Message-ID: <Xns96F35ED60D2F0fishburnsybasecom@127.0.0.1>
User-Agent: Xnews/06.08.25 Hamster/2.0.6.0
NNTP-Posting-Host: fishburn-t30.sybase.com
X-Original-NNTP-Posting-Host: fishburn-t30.sybase.com
Date: 18 Oct 2005 06:23:20 -0700
X-Trace: forums-1-dub 1129641800 10.25.98.140 (18 Oct 2005 06:23:20 -0700)
X-Original-Trace: 18 Oct 2005 06:23:20 -0700, fishburn-t30.sybase.com
Lines: 31
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4865
Article PK: 17450

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
news:gr99l1tvvpu8rf3n9ffp05msjugrq4egqk@4ax.com of
ianywhere.public.general:

BC> I pulled the plug on a whole *rack* of test servers, lots of
screaming
BC> developers ...

Remind me not to invite you over ...

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList


Breck Carter [TeamSybase] Posted on 2005-10-18 14:36:03.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: about robust of ASA
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <9q1al1dsv54dspjnbenfbskk5ovgse6l84@4ax.com>
References: <435455d9@forums-1-dub> <gr99l1tvvpu8rf3n9ffp05msjugrq4egqk@4ax.com> <Xns96F35ED60D2F0fishburnsybasecom@127.0.0.1>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 18 Oct 2005 07:32:20 -0700, bcarter.sentex.ca
Lines: 23
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Oct 2005 07:32:21 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Oct 2005 07:36:03 -0700
X-Trace: forums-1-dub 1129646163 10.22.108.75 (18 Oct 2005 07:36:03 -0700)
X-Original-Trace: 18 Oct 2005 07:36:03 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4866
Article PK: 8581

On 18 Oct 2005 06:23:20 -0700, David Fishburn

<fishburn_spam@off.ianywhere.com> wrote:

>"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
>news:gr99l1tvvpu8rf3n9ffp05msjugrq4egqk@4ax.com of
>ianywhere.public.general:
>
>BC> I pulled the plug on a whole *rack* of test servers, lots of
>screaming
>BC> developers ...
>
>Remind me not to invite you over ...

But I'm coming over *anyway*, next Monday afternoon... :)

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


"Rob Waywell" <rwaywell Posted on 2005-10-18 14:56:11.0Z
From: "Rob Waywell" <rwaywell@no_spam.ianywhere.com>
Newsgroups: ianywhere.public.general
References: <435455d9@forums-1-dub> <gr99l1tvvpu8rf3n9ffp05msjugrq4egqk@4ax.com> <Xns96F35ED60D2F0fishburnsybasecom@127.0.0.1> <9q1al1dsv54dspjnbenfbskk5ovgse6l84@4ax.com>
Subject: Re: about robust of ASA
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: rwaywell-xp.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp.sybase.com
Message-ID: <43550d0b$1@forums-1-dub>
Date: 18 Oct 2005 07:56:11 -0700
X-Trace: forums-1-dub 1129647371 10.25.98.159 (18 Oct 2005 07:56:11 -0700)
X-Original-Trace: 18 Oct 2005 07:56:11 -0700, rwaywell-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4867
Article PK: 8582

Can you make it Tuesday? I have more time for social beverages that day ;-)

--
-----------------------------------------------
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

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
message news:9q1al1dsv54dspjnbenfbskk5ovgse6l84@4ax.com...
> On 18 Oct 2005 06:23:20 -0700, David Fishburn
> <fishburn_spam@off.ianywhere.com> wrote:
>
>>"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> wrote in
>>news:gr99l1tvvpu8rf3n9ffp05msjugrq4egqk@4ax.com of
>>ianywhere.public.general:
>>
>>BC> I pulled the plug on a whole *rack* of test servers, lots of
>>screaming
>>BC> developers ...
>>
>>Remind me not to invite you over ...
>
> But I'm coming over *anyway*, next Monday afternoon... :)
>
> Breck
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Greg Fenton Posted on 2005-10-18 04:33:24.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: about robust of ASA
References: <435455d9@forums-1-dub>
In-Reply-To: <435455d9@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <43547a35$1@forums-2-dub>
X-Original-Trace: 17 Oct 2005 21:29:41 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 37
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Oct 2005 21:29:43 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Oct 2005 21:33:24 -0700
X-Trace: forums-1-dub 1129610004 10.22.108.75 (17 Oct 2005 21:33:24 -0700)
X-Original-Trace: 17 Oct 2005 21:33:24 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!forums-2-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4863
Article PK: 31462


Sunshine wrote:
> Application's running environment is very bad. Power cutting off often
> arises suddenly.
> ...
> Could ASA be suitable for it?

Though running on a machine that is not stable is a bad idea for just
about any application where you want to ensure data integrity, ASA is
designed to handle system failures such as power outages. ASA logs all
transactions to the transaction log as they are received and only from
time to time does it update the .db file (when a CHECKPOINT occurs).
Should ASA go down before a checkpoint happens, when it starts up it
recognizes the situation and automatically recovers any committed
transactions by re-applying the statements from the transaction log.

So indeed ASA is a good candidate for overall data integrity. However
to better your odds of no data loss, you need to develop a proper backup
and recovery strategy (documented well in the SQLAnywhere Studio
documentation) and I would recommend also looking to what you can do
about avoiding sudden system failures (for example, purchase a universal
power supply (UPS) as many are now available for < $100 USD).

By the way, questions about SQLAnywhere are best posted to the newsgroup:

sybase.public.sqlanywhere.general

This is where the majority of the ASA user community hangs out.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/