Matt Huras - Chief Architect, DB2 for Linux, Unix and Windows has shared this great article discussing some of the high-value, core advances in security, availability and performance with the recently announced DB2 11.1 for Linux, UNIX and Windows.
This article is Part 1 of a 2-part Blog series. The article discusses the following
Added by Sajan K on April 28, 2016 at 4:00am — No Comments
In order to analize system performance I tried to discover how time is spent within my database system.
According to the documentation, TOTAL_RQST_TIME=TOTAL_WAIT_TIME + TOTAL_*_PROC_TIME.
By querying the service class table function (MON_GET_SERVICE_CLASS) I'm disappointed by the fact that there is a big difference between total_rqst_time and the sum of all other values.
It seems that with "normal" DML statements these two values are quite…Continue
Added by Alessandro Oppici on April 24, 2016 at 2:58am — No Comments