SEO

#1 (**permalink**) 02-26-2008, 04:40 PM

Years ago I worked on a system which I believe was one of the first
instances of EEE being used in an OLTP environment. It was fraught
with lots of gotchas, but overall was made to work. This was in the
version 5 days. I have only used EEE for DSS since that time.

Now that EEE has been replaced by ESE in version 8, I am wondering how
many advances have been made for its use as an OLTP database. I
browsed the IBM sites with their sales info, etc., but am looking more
for DBA's perspective on viability of a distributed database as a
scalable platform in a highly transactional environment. I'd
appreciate hearing both success and horror stories alike.

Thanks in advance,
Evan

#2 (**permalink**) 02-26-2008, 04:40 PM

Many of the restrictions that existed on EEE have been lifted on ESE
with clusters. ALl of these are supported:
- you can update the partition key
- sequences and identity are supported (as of v8 Fixpak 2)
- replication capture and apply are supported

Note that both DB2 and Oracle have published TPC-C benchmarks on
clusteretd systems, although some will argue that TPC-C is not a good
test of OLTP when it comes to clustering.

Evan Smith wrote:
> Years ago I worked on a system which I believe was one of the first
> instances of EEE being used in an OLTP environment. It was fraught
> with lots of gotchas, but overall was made to work. This was in the
> version 5 days. I have only used EEE for DSS since that time.
>
> Now that EEE has been replaced by ESE in version 8, I am wondering how
> many advances have been made for its use as an OLTP database. I
> browsed the IBM sites with their sales info, etc., but am looking more
> for DBA's perspective on viability of a distributed database as a
> scalable platform in a highly transactional environment. I'd
> appreciate hearing both success and horror stories alike.
>
> Thanks in advance,
> Evan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Distributed Database for OLTP?