Distributed Database for OLTP?

[Evan Smith]

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

[Blair Adamache]

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