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) : ftp://www.redbooks.ibm.com/redbooks/2012_ITSO_Total_Solution_Event_System_z_Brussels/track_10_DB2_on_zOS_Update/DB02_Distributed_Access_DB2_for_zOS.pdf

Please also take a look at the Robert’s DB2 blog : http://robertsdb2blog.blogspot.com/2013/12/db2-for-zos-want-to-use-high.html

Advertisements