Outline spec of what we are currently working on...
Make the cluster setup as "production like" as possible and to be able to walk clients through the various features of this.
Be able to easily adjust the workload profile to have different mixes of short read, update, insert workload and longer ad-hoc queries to be similar to a clients's real workload.
Base the demo workload on a well known benchmark for OLTP systems (TPCC).
Using the Technology explorer front end.
Demonstrate workload balancing scenarios:
Client affinity for ad-hoc queries
Mixture of the above
Demonstrate failover scenarios and demonstrate continuous availability:
Member fail, various reasons
Standby CF fail, various reasons
Multiple failures, various reasons
Reproduce failover scenario and demonstrate minimal downtime:
Main CF fails
Monitoring information on Db2 on members , Show graphically second by second:
OPM dashboard is a useful overview on an aggregate (minute by minute) basis.
Workload/throughput information. Show graphically second by second:
Transactions per member for read, Non-read (insert, update, delete)
Overall throughput of transactions.
Automate the setup and tear down as far as possible.
Document the setup and running of the demo so that we can reproduce and also so that others can.