|
|
|
The DB2 Calendar Report provides an extract of key DB2 activity indicators from the DB2 System Activity and the DB2 Data Base Activity files. It presents this information in calendar form, showing the activity indicators for each day of the month. The Calendar 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 SAS CALENDAR procedure. Because of their relative simplicity, the statements for PROC CALENDAR were not placed in a separate source library member. The user is free to develop additional reports using this SAS facility. To activate this report for use in DYDB2MBO or MNDB2MBO, you must set the macro variable CALREP=Y in the #DB2MOBJ member of your unit library prefix.MICS.USER.SOURCE. The system default macro variable values are in sharedprefix.MICS.SOURCE member #DB2MOBJ.
CA DAILY DB2 SUMMARY System Identifier=SYSB DB2 ID=DSN2 September 2005 ------------------------------------------------------------------------------------------------------------------------------- | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------| | | | | | 1 | 2 | 3 | | | | | | | | | | | | | | 20 THREADS | 135 THREADS | 0 THREADS | | | | | | 2 ABORTS | 27 ABORTS | 0 ABORTS | | | | | | 18 BINDS | 135 BINDS | 0 BINDS | | | | | | 10 SECONDS | 16 SECONDS | 12 SECONDS | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------| | 4 | 5 | 6 | 7 | 8 | 9 | 10 | | | | | | | | | | 417 THREADS | 432 THREADS | 1,914 THREADS | 33 THREADS | 2 THREADS | 55 THREADS | 0 THREADS | | 190 ABORTS | 178 ABORTS | 222 ABORTS | 2 ABORTS | 0 ABORTS | 2 ABORTS | 0 ABORTS | | 416 BINDS | 431 BINDS | 1,909 BINDS | 33 BINDS | 1 BINDS | 49 BINDS | 0 BINDS | | 17 SECONDS | 17 SECONDS | 22 SECONDS | 8 SECONDS | 10 SECONDS | 14 SECONDS | 6 SECONDS | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------| | 11 | 12 | 13 | 14 | 15 | 16 | 17 | | | | | | | | | | 0 THREADS | 56 THREADS | 50 THREADS | 95 THREADS | | | | | 0 ABORTS | 5 ABORTS | 8 ABORTS | 23 ABORTS | | | | | 0 BINDS | 51 BINDS | 41 BINDS | 78 BINDS | | | | | 5 SECONDS | 15 SECONDS | 16 SECONDS | 12 SECONDS | | | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------| | 18 | 19 | 20 | 21 | 22 | 23 | 24 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |-----------------+-----------------+-----------------+-----------------+-----------------+-----------------+-----------------| | 25 | 26 | 27 | 28 | 29 | 30 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ------------------------------------------------------------------------------------------------------------------------------- ------------------------------- | | SUM | | THREADS | 3209 | | ABORTS | 659 | | BINDS | 3162 | | TCB TIME | 186.8240118 | -------------------------------
Figure 3-4 DB2 Calendar Report Sample
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |