bernhard.willems@gmail.com wrote:
> 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.
>
Would you mind telling us more about the load.
E.g. do the INSERTs all happen at the end of the index (identity column)?
I haven't heard of issues with TYPE 2 indexes before. Maybe opening a
PMR would be in order to get to the bottom of this....

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab