Ordering by correlation ID: ORDER (CORRNAME)
You can also identify the task by using correlation data:
ACCOUNTING
REPORT
ORDER (CORRNAME)
Note: In a distributed environment reports should be ordered by REQLOC
or CONNTYPE. If REQLOC or CONNTYPE are not used in the ORDER subcommand
option of REPORT, the Accounting portion of all threads (including
DBATs) where the combination of OMEGAMON for Db2
Performance Expert identifiers
is the same is reported as one entry.
Accounting report - ordered by correlation ID
The following example shows an Accounting report ordered by correlation ID.
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: CORRNAME 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
CORRNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
RECOVER0 10 2 0.00 0.00 0.00 0.00 3:05.083686 N/P 625.50 19.40 0.10
0 87 0.00 0.00 0.00 0.00 1.899589 N/P 315.10 7.60 0
RUNPRG16 2 34 25.50 0.00 0.00 1.00 1:54:00.564496 N/P 1459.50 93.00 82.00
0 1 0.00 0.00 0.00 0.00 6.607316 N/P 77.00 54.50 32
RUNPRG4 2 7 1.00 0.00 0.00 0.00 12:22.510536 N/P 44.00 9.50 0.00
0 16 0.00 0.00 0.00 0.00 0.759452 N/P 0.00 0.00 0
RUNPRG8 2 159 1.50 0.00 81.00 0.00 1:54:45.002759 N/P 2589.00 284.50 207.50
0 4 170.00 1.50 0.50 0.00 8.915043 N/P 362.50 121.00 156
RUNUTL10 2 0 0.00 0.00 0.00 0.00 1:43.715927 N/P 38.00 0.50 1.00
0 12 0.00 0.00 0.00 0.00 0.081900 N/P 17.00 0.50 0
RUNUTL11 2 0 0.00 0.00 0.00 0.00 1:57.605935 N/P 62.50 0.50 1.00
0 12 0.00 0.00 0.00 0.00 0.136053 N/P 15.00 4.00 0
RUNUTL12 3 0 0.00 0.00 0.00 0.00 56.117967 N/P 231.33 15.67 2.00
0 17 25.33 1.00 1.00 1.00 0.407292 N/P 8.00 7.33 0
RUNUTL13 2 0 0.00 0.00 0.00 0.00 39.324115 N/P 63.50 6.50 1.00
0 12 0.00 0.00 0.00 0.00 0.140269 N/P 15.50 3.00 0
SYSADM 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
*** 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