Recently I found a great new feature in DB2 V10 in order to increase the performance and to decrease the CPU Utilization. The feature is called High-Performance DBAT.

In order to activate this feature, you have first to take a look at the MAXDBAT and CONDBAT values which can cause issues if they are set too low. Next you have to do a Rebind Package with the bind option RELEASE(DEALLOCATE).

Please take a look at the following IBM RedBook (first chapter) :

Please also take a look at the Robert’s DB2 blog :