Example of ordering by interval: ORDER (INTERVAL)
This example shows a short Accounting report that is ordered by interval.
To produce a report that presents DB2 activity by time intervals, the input data first needs to be reduced to the intervals that you want to use in reporting.
The following command was used to generate the sample report in Accounting report - ordered by interval.
ACCOUNTING
REDUCE
INTERVAL (5)
REPORT
ORDER (INTERVAL)
In this command the data is reduced to 5-minute intervals. The report is ordered by this interval. An entry is produced that shows the activity during every 5-minute interval.
Accounting report - ordered by interval
The following example shows an Accounting report that is ordered by interval. Reports ordered by INTERVAL, with or without another identifier, are especially useful in trend analysis. For example, you can reduce and save your data by specifying INTERVAL(1440) to produce reports that show the day-by-day activity of your DB2 subsystem.
LOCATION: DSNCAT OMEGAMON XE for DB2 Performance Expert (V5R4M0) PAGE: 1-1
GROUP: DSNCAT Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SSDQ TO: NOT SPECIFIED
SUBSYSTEM: SSDQ ORDER: INTERVAL INTERVAL FROM: 07/14/15 18:47:13.28
DB2 VERSION: V11 SCOPE: MEMBER TO: 07/14/15 20:55:28.69
#OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
INTERVAL #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
05/10 19:50 - 05/10 19:55 1 1 3.00 0.00 0.00 0.00 5:23.338584 N/P 51.00 20.00 1.00
0 3 0.00 0.00 0.00 0.00 0.087963 N/P 0.00 0.00 0
05/10 19:55 - 05/10 20:00 6 8 11.00 0.67 0.00 0.00 2:29.264737 N/P 231.00 17.67 22.00
0 36 0.00 0.00 0.00 0.00 4.134166 N/P 0.67 1.00 0
05/10 20:00 - 05/10 20:05 1 1 2.00 0.00 0.00 0.00 12:20.702202 N/P 6232.00 299.00 23.00
0 0 5.00 5.00 5.00 0.00 7.753375 N/P 2931.00 8.00 1
05/10 20:05 - 05/10 20:10 7 10 2.57 0.00 0.00 0.00 10:01.005681 N/P 552.57 26.00 21.43
0 6 0.00 0.00 0.00 0.14 2.235738 N/P 192.86 0.29 5
*** GRAND TOTAL ***
15 20 5.93 0.27 0.00 0.00 6:51.111265 N/P 769.13 40.47 20.40
0 45 0.33 0.33 0.33 0.07 3.219767 N/P 285.67 1.07 6
ACCOUNTING REPORT COMPLETE