|
|
|
The DB2 Plan Performance Summary Report provides an extract of the most pertinent summary information from the DB2 Plan Activity File (DB2DSP), which is created from the SMF type 101 record. It summarizes the activity of active DB2 plans. The Plan Performance Summary Report is normally produced as a part of the DAILYRPT and MONTHRPT jobs, which are automatically submitted during the DAILY and MONTHLY runs, respectively. DAILYRPT executes the SAS program found in sharedprefix.MICS.SOURCE(DYDB2MBO), while MONTHRPT executes sharedprefix.MICS.SOURCE(MNDB2MBO). Both of these programs prepare data and then execute the actual report generation program located in sharedprefix.MICS.SOURCE(DB2PLNSM), which produces the Plan Performance Summary Report. The program will produce a separate report for each combination of SYSID and DB2 system. To activate this report for use in DYDB2MBO or MNDB2MBO, you must set the macro variable PLANSUM=Y in the #DB2MOBJ member of your unit library prefix.MICS.USER.SOURCE. The system default report macro variable values are in sharedprefix.MICS.SOURCE member #DB2MOBJ. To create this report directly, ensure the macro variable PLANSUM is set equal to Y in member #DB2MOBJ of your unit library prefix.MICS.USER.SOURCE. Set all other macro variables to N to produce ONLY the DB2 Plan Performance Summary Report. Finally, you must execute the program DYDB2MBO or MNDB2MBO, as is done in the DAILYRPT and MONTHRPT jobs.
CA CA MICS/DB2 DB2 PLAN PERFORMANCE SUMMARY PAGE: 1 RUN DATE: Monday, December 5, 2005 SUBPAGE: 1 ================================================================================================================================ ! ! SYSID:A1A1 ! DB2 SYSTEM: RA1A ! SUMMARY REPORT ! RELEASE: 8.1 ! ================================================================================================================================ AVG AVG AVG AVG TOTAL TOTAL CONNECT TOTAL AVG AVG TOTAL AVG SYNC. SEQ. MAX PG UPDATE DEAD TOTAL TIME- TOTAL PLAN FACILITY COUNT TCB SEC TCB SEC ELAPSED GETPAGE GETPAGE READ PREFETCH LOCKS PAGE LOCK SUSP OUT ABORT -------- -------- ------ ------- ------- ------------ ------- ------- -------- -------- ------ ------ ------ ------ ------ ----- B2RHPIN * ALL * 22 0.42796 0.01945 0:00:00.229 12377 562.591 3.63636 0.31818 0.7727 192.77 0 0 0 0 CSMHR01 * ALL * 11 0.81572 0.07416 0:00:00.417 21748 1977.09 2.27273 0.90909 2 0 0 0 0 0 CSQ5D531 * ALL * 1 0.00438 0.00438 0:00:00.141 20 20 7 2 2 5 0 0 0 0 CSQ5L531 * ALL * 17419 12.4022 0.00071 0:00:00.001 35053 2.01234 0.00034 0 0 0 0 0 0 17268 CSQ5R531 * ALL * 13 0.01062 0.00082 0:00:00.011 43 3.30769 0.53846 0 0.1538 0.0769 0 0 0 6 CSQ5S531 * ALL * 1440 1.00569 0.0007 0:00:00.001 2880 2 0 0 0 0 0 0 0 1440 CSQ5U532 * ALL * 1 0.00141 0.00141 0:00:00.054 3 3 0 0 1 1 0 0 0 0 CSQ5W531 * ALL * 1 0.00597 0.00597 0:00:00.214 32 32 16 0 2 6 0 0 0 0 DB2CPLAN * ALL * 4 0.01076 0.00269 0:00:00.062 16 4 0 0 0 0 0 0 0 0 DISTSERV * ALL * 19903 72.4451 0.00364 0:00:00.020 1017920 51.144 0.06944 0.31051 0.7304 1.663 0 67 0 122 DSNREXX * ALL * 2 0.00159 0.00079 0:00:00.001 0 0 0 0 0 0 0 0 0 0 DSNTEP2 * ALL * 48 10.5186 0.21914 0:00:00.565 515878 10747.5 19.2708 15.5 51.271 295.25 0 0 0 0 DSNUTIL * ALL * 29375 57.2005 0.00195 0:00:00.137 502021 17.0901 0.17185 0.14114 0.4609 4.0112 0 10149 0 3 RBPAPLAN * ALL * 2 0.0097 0.00485 0:00:00.087 62 31 2 0 1 12 0 0 0 0 RDPCPLAN * ALL * 39 0.74327 0.01906 0:00:03.237 8371 214.641 0.30769 0 0.1795 0 0 0 0 0 RDPPPLAN * ALL * 77 0.15962 0.00207 0:00:03.381 1769 22.974 0.62338 0.36364 0.1688 2.8831 0 0 0 0 RDPSPLAN * ALL * 672 1.27106 0.00189 0:00:00.727 18991 28.2604 0.95685 0.12054 0.0402 12.272 0 20 0 0 RQPAPLAN * ALL * 216 0.49825 0.00231 0:00:00.050 23189 107.356 0.47685 2.07407 0.0324 4.7037 0 1 0 0 RUPUPLAN * ALL * 1156 1.52063 0.00132 0:00:22.586 19249 16.6514 0.10813 0.69204 0.019 2.9014 0 0 0 884 SYDBSQL1 * ALL * 6 0.00916 0.00153 0:00:00.009 294 49 0.5 0.66667 0.5 0 0 0 0 0 REPORTING PERIOD Friday, September 3, 2004 6:01:17 TO Friday, September 3, 2004 18:01:16 --------------------------------------------------------------------------------------------------------------------------------
Figure 3-5. DB2 Plan Performance Summary Report Sample
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |