Ordering by connection ID: ORDER (CONNECT)
You can order the report by the connection ID using the subcommand option ORDER (CONNECT).
Here is a sample of how to specify the command:
ACCOUNTING
REPORT
ORDER (CONNECT)
Accounting report - ordered by connection ID
The following example shows a report with ordering by connection ID.
Three connection IDs are reported: information for connection ID BATCH is reported on the first two lines followed by information for connections DB2CALL and UTILITY.
GRAND
TOTAL is printed at the end of the report. It shows the aggregated
values for all three connection IDs.
LOCATION: DSNCAT OMEGAMON for DB2 Performance Expert (V5R5M0) PAGE: 1-1
GROUP: DSNCAT Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: SSDQ TO: NOT SPECIFIED
SUBSYSTEM: SSDQ ORDER: CONNECT INTERVAL FROM: 07/14/15 18:47:13.28
DB2 VERSION: V11 SCOPE: MEMBER TO: 07/14/15 19:55:28.69
#OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
CONNECT #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
BATCH 7 200 8.00 0.00 23.14 0.29 1:09:01.525990 N/P 1253.14 117.14 83.14
0 22 59.43 0.86 0.57 0.43 4.698535 N/P 126.71 52.57 188
DB2CALL 10 10 0.00 0.00 0.00 0.00 1:06.989512 N/P 23.00 0.20 3.00
0 0 1.00 1.00 0.00 1.00 0.041995 N/P 0.00 0.00 10
UTILITY 18 2 0.00 0.00 0.00 0.00 2:18.108687 N/P 371.67 11.67 0.56
0 139 0.00 0.00 0.00 0.00 1.144894 N/P 181.22 5.33 0
*** GRAND TOTAL ***
35 212 1.60 0.00 4.63 0.06 15:18.472383 N/P 448.34 29.49 17.77
0 161 12.17 0.46 0.11 0.37 1.540508 N/P 118.54 13.26 198
Accounting REPORT COMPLETE