Reductions in synchronous log writes

Db2 11 improves performance and stability by reducing the occurrence of synchronous log writes during index structure modification operations in data sharing environments.

Previously, performance problems might result during insert and delete processing for group buffer pool dependent (GBP-dependent) indexes in data sharing environments. Synchronous log writes for the same operation might cause performance degradation.

Now, the number of synchronous log writes for both insert and delete processing is reduced, which improves transaction and batch response times.