|
|
|
This sample program tests the power of elapsed times captured in DB2 SMF Type 101 to "explain" the total time a transaction is active in DB2. For a single-threaded transaction, you can expect the sum of CPU, wait, and elapsed service times to almost add up to transaction time.
If a transaction takes significantly more or less time than the sum of the services it absorbs, you can use your knowlege of DB2 to identify DB2 applications that have resource consumption characteristics that need to be studied. Consider whether it uses a service that is not captured in CA JARS or in the SMF Type 101 record itself. Also consider whether it is a multi-threaded transaction that absorbs services in parallel.
Note: This sample report requires that the record selection statement be edited or that other user modifications be made to match your environment. Failure to do so may result in a message indicating that no records were selected.
12/30/yy DB2 PROCESSING EXCEPTION REPORT PAGE 1 REPORT ID: EZXT0332 CONNECT CONNECT CONNECT DB2 ELAP/ DB2 ACTIVE DB2 TCB NON TCB WAIT FOR EXTERNAL DATE TIME NAME PROCESS TIME TIME CPU SERVICE ELAPSED 05/07/27 15:59:00 RRSAF 101.06% .001126 .000748 .000000 .000390 .000000 05/07/27 16:01:27 RRSAF 101.02% .001271 .000849 .000000 .000435 .000000 05/07/27 16:03:36 RRSAF 101.04% .001243 .000823 .000000 .000433 .000000 05/07/27 16:05:24 DB2CALL 5564.21% .840942 .182254 .313195 .647447 45.648890 05/07/27 16:05:58 DB2CALL 101.64% .035477 .005434 .000000 .030626 .000000 05/07/27 16:06:20 RRSAF 101.25% .045368 .003649 .000000 .042287 .000000 05/07/27 16:15:11 RRSAF 101.13% .002556 .001182 .000000 .001403 .000000 05/07/27 16:15:41 RRSAF 102.04% .001176 .000794 .000000 .000406 .000000 05/07/27 16:21:06 RRSAF 102.48% .001290 .000837 .000000 .000485 .000000 05/07/27 16:21:34 RRSAF 102.74% .001675 .001225 .000000 .000496 .000000 05/07/27 16:25:26 RRSAF 101.26% .004746 .001310 .000000 .003496 .000000 05/07/27 16:30:26 RRSAF 101.67% .058209 .003004 .000000 .056181 .000000 05/07/27 16:32:06 RRSAF 101.50% .001199 .000799 .000000 .000418 .000000 05/07/27 16:39:18 RRSAF 101.61% .001301 .000823 .000000 .000499 .000000 05/07/27 16:41:24 RRSAF 101.05% .001518 .001006 .000000 .000528 .000000 05/07/27 16:41:44 RRSAF 101.26% .001190 .000841 .000000 .000364 .000000 05/07/27 16:43:27 RRSAF 101.05% .001043 .000705 .000000 .000349 .000000 05/07/27 16:46:22 RRSAF 101.37% .001165 .000785 .000000 .000396 .000000 05/07/27 16:46:29 RRSAF 101.44% .001388 .000897 .000000 .000511 .000000 05/07/27 16:46:49 RRSAF 101.23% .001219 .000835 .000000 .000399 .000000 05/07/27 16:49:26 DB2CALL 19784.80% 5.216258 4.764054 .000000 1,027.262282 .000000 05/07/27 16:55:02 SERVER 102.07% 81.286989 .029338 .052693 80.864810 2.030485 05/07/27 16:59:00 RRSAF 102.16% .001340 .000897 .000000 .000472 .000000 05/07/27 17:01:48 RRSAF 101.47% .003116 .000776 .000000 .002386 .000000 05/07/27 17:02:43 RRSAF 103.89% .001387 .000901 .000000 .000540 .000000 05/07/27 17:08:18 DB2CALL 304.74% 1.054293 .013660 .034991 .335187 2.829114
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |