<bernhard.willems@gmail.com> wrote in message
news:1136234451.195730.224920@o13g2000cwo.googlegr oups.com...
> Thanks for the tip and suggestions.
> I'll try the high percent free value, but the load is not possible. The
> application (not ours) just works this way.
> I hope one of the options will work, cause else I must say DB2 is not
> build for high transaction volumes we are doing and that would be very
> sad.
> I read about the benefits from type-2 indexes, but there seems to be a
> big drawback because it reduce the efficiency of the index big time in
> our situation.
>

DB2 has done very well in benchmarks with high transaction volumes, so it is
built for such workloads. In fact, DB2 holds the record for the highest tpmC
in the TPC-C benchmark.
http://www.tpc.org/tpcc/results/tpcc_perf_results.asp