Grouping utility history
When you view utility history in Db2® Admin Tool, you can group it by utility,
job name, date, or user ID. You further investigate one of the grouped items by grouping
a second time. For example, if you group utility history by utility, you can
then select a specific utility, such as COPY, and group that history by date.
Procedure
To group utility history:
- On the DB2 Administration Menu (ADB2) panel, specify option Z, and press Enter.
- On the System Administration (ADB2Z) panel, specify option 2H, and press Enter.
-
On the Display Utility History (ADB2Z2H) panel,
specify one of the following options, and press Enter:
- 5
- Group history by utility
- 5D
- Group history by date
- 5J
- Group history by job name
- 5U
- Group by user ID
- Optional:
On the Utility History Summary by (ADB2Z2H5) panel, use the
Sx (Show by
x) line commands to further filter the data.
For example, if the data is grouped by user ID, you can select one of the listed user IDs and group its data by date (SD), job name (SJ), or utility (SN).
Figure 1. Example of filtering utility history by user ID and then by date - part 1 ADB2Z2H5 DD1A Utility History Summary by Userid Row 1 to 13 of 74 Command ===> Scroll ===> PAGE More: > Commands: REFRESH Line commands: S - Show rows SF - Show failures SD - Show by date SJ - Show by jobname SN - Show by utility ----- All numbers are in milliseconds ------- Sum Avg Sum Avg S Userid Runs Failures CPU time CPU time Elapsed time Elapsed * * * * * * * -- ---------- <-------- <-------- <------------ <------- <------------ <------- ARYTSTA 6 0 1374 229 3183 530 CKZTEST 13 1 372 28 2710 208 SD CSGGCQA 13810 1 2470182 178 8855662 641 CSHAA1 15163 27 658629 43 3096320 204 CSHAA2 170 2 156978 923 146951907 864422 CSHAA4 6 1 0 0 10576776 1762796 CSHAA5 111 1 6113 55 50877 458 CSHAA6 44 0 1080 24 3317 75 CSHAA7 844 0 146036 173 845383 1001 CSHAA8 7153 12 281730 39 1354788 189 CSHAA9 104 0 15508 149 86033 827 CSHAAA 1779 37 187713 105 3562883 2002 CSHAAB 1053 22 111222 105 2043339 1940Note: The Sx line commands that are listed on this panel vary depending on how the data was initially grouped (by utility, job name, date, or user ID).The resulting Utility History Summary by (ADB2Z2H5) panel shows the utility history for the selected user ID grouped by date:
Figure 2. Example of filtering utility history by user ID and then by date - part 2 ADB2Z2H5 DD1A Utility History Summary by Date Row 1 to 9 of 9 Command ===> Scroll ===> PAGE More: > Commands: REFRESH Line commands: S - Show rows SF - Show failures ----- All numbers are in milliseconds ------- Sum Avg Sum Avg S Date Runs Failures CPU time CPU time Elapsed time Elapsed * * * * * * * -- ---------- <-------- <-------- <------------ <------- <------------ <------- 2024-01-11 799 0 297635 372 1038995 1300 2024-01-12 6200 0 946865 152 2881943 464 2024-01-13 26 1 40214 1546 972809 37415 2024-01-18 345 0 34377 99 68707 199 2024-01-19 8 0 350 43 1708 213 2024-01-20 386 0 173402 449 1332413 3451 2024-01-21 5776 0 948360 164 2496339 432 2024-01-25 270 0 28979 107 62748 232 >>ALL 13810 1 2470182 178 8855662 641 ******************************* END OF DB2 DATA ******************************* -
On the Utility History Summary by (ADB2Z2H5) panel, use the S
line command to view rows from SYSIBM.SYSUTILITIES for the selected row
(utility, date, user ID, or job name). Use the SF line commands to view only
those rows SYSIBM.SYSUTILITIES for failed utility jobs.
Tip: Notice that the last row (beginning with
>>ALL) lists the total counts for all proceeding rows.