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.

Windows Shutdown Question

2 posts in General Discussion Last posting was on 2004-08-27 20:00:51.0Z
Emad Attia Posted on 2004-08-27 17:28:12.0Z
From: "Emad Attia" <emad@fpacesoftware.com>
Newsgroups: ianywhere.public.general
Subject: Windows Shutdown Question
Lines: 21
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 216.123.208.8
X-Original-NNTP-Posting-Host: 216.123.208.8
Message-ID: <412f6f2c$1@forums-1-dub>
Date: 27 Aug 2004 10:28:12 -0700
X-Trace: forums-1-dub 1093627692 216.123.208.8 (27 Aug 2004 10:28:12 -0700)
X-Original-Trace: 27 Aug 2004 10:28:12 -0700, 216.123.208.8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3447
Article PK: 7353

Hi there,
My question may sound bizarre but it is kind of important for the
environment that we are deploying ASA in.

1 - What is the behaviour of ASA if MS Windows was shutdown
(Start->Shutdown) while it is processing a large transaction? Is the
transaction aborted? Does the DB get corrupted in any way?
2 - What is the behaviour of ASA if the computer (PC) was shutdown
forcefully while it is processing a large transaction? Is the transaction
aborted? Does the DB get corrupted in any way?
3 - Are the behaviours in 1 and 2 above deterministic?

We are trying to test the above situations but we wanted to make sure of no.
3 above. Any suggestions for techniques that will be helpful in preventing
corruption of the DB will be greatly appreciated as well.

Thanks
Emad Attia


Jason Hinsperger (iAnywhere) Posted on 2004-08-27 20:00:51.0Z
From: "Jason Hinsperger \(iAnywhere\)" <NOjason_hinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <412f6f2c$1@forums-1-dub>
Subject: Re: Windows Shutdown Question
Lines: 45
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: vpn-concord-071.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-071.sybase.com
Message-ID: <412f92f3@forums-1-dub>
Date: 27 Aug 2004 13:00:51 -0700
X-Trace: forums-1-dub 1093636851 158.159.8.71 (27 Aug 2004 13:00:51 -0700)
X-Original-Trace: 27 Aug 2004 13:00:51 -0700, vpn-concord-071.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3449
Article PK: 7356

ASA is designed to handle hard and soft reboots of the machine and guarantee
data integrity.
If you shutdown the server abnormally (by shutting down the machine for
example), and uncommitted transactions will be rolled back the next time the
server is started. Any committed transactions will not be lost, unless of
course you experience file system corruption.

--
Jason Hinsperger
Product Manager
iAnywhere Solutions
************************************************************
For the latest downloads technotes, whitepapers, webcasts and other
developer
resources, go to: http://www.ianywhere.com/developer/
************************************************************

"Emad Attia" <emad@fpacesoftware.com> wrote in message
news:412f6f2c$1@forums-1-dub...
> Hi there,
> My question may sound bizarre but it is kind of important for the
> environment that we are deploying ASA in.
>
> 1 - What is the behaviour of ASA if MS Windows was shutdown
> (Start->Shutdown) while it is processing a large transaction? Is the
> transaction aborted? Does the DB get corrupted in any way?
> 2 - What is the behaviour of ASA if the computer (PC) was shutdown
> forcefully while it is processing a large transaction? Is the transaction
> aborted? Does the DB get corrupted in any way?
> 3 - Are the behaviours in 1 and 2 above deterministic?
>
> We are trying to test the above situations but we wanted to make sure of
no.
> 3 above. Any suggestions for techniques that will be helpful in preventing
> corruption of the DB will be greatly appreciated as well.
>
> Thanks
> Emad Attia
>
>
>