On Tue, Jul 21, 2009 at 20:53, Charles Wilt<charles.wilt@xxxxxxxxx> wrote:
Both the developer and the DBA are confused by this, their first comments..
"Doesn't DB2 guarantee ACID compliance?"
"In every other db, a single statement like the above is done Atomically."

Yeah, the i is kind of weird when it comes to this. Especially because
there's still lots of code out there that doesn't utilize commitment
control.

But it's not an issue - you can change the default level using
SET OPTION

And yeah - it is extremely irritating if you see people and software
still not running fully transaction aware and without commitment
control, dealing with important production data. It took me quite a
bit of time to get used to the idea that there are still many IT
people stuck in the 80ies.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.