Examples of TOP processing
These examples show some applications of the TOP subcommand option in Accounting reports and traces.
Top-10 plans in Accounting report
To produce a short Accounting report with a list of the top-10 plans that spent the longest time in an application, specify:
⋮
GLOBAL
INCLUDE (LOCATION (USIBMSNEWY11))
EXCLUDE (CONNTYPE (CICS))
ACCOUNTING
REPORT
ORDER (PLANNAME)
TOP
⋮
Accounting report - TOP listing - example
The following example shows the last page of an Accounting report. It presents a list of the 10 plans that had the highest value for elapsed time in the application. The TOP list also shows the page on which the report entries can be found.
LOCATION: USIBMNEWY11 IBM 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: PLANNAME INTERVAL FROM: 07/14/15 18:47:13.28
DB2 VERSION: V10 SCOPE: MEMBER TO: 07/14/15 19:55:28.69
ELAPSED TIME SPENT IN APPLICATION TOP NUMBER REQUESTED: 10
PLANNAME VALUE PAGE
---- -------------------------------------------------------- --------------- ----------
1 PVLDD4C3 13:36.924222 1-1
2 PVLDD4B3 11:25.333551 1-1
3 PVLDD4D1 10:19.115316 1-1
4 PVLDD4A4 9:18.056476 1-1
5 DSNBIND 8:50.415594 1-1
6 DSNTEP31 8:14.506780 1-1
7 PVLDD4D6 5:23.338584 1-1
8 PVLDD4A5 4:06.067683 1-1
9 PVLDD4C4 3:10.939686 1-1
10 PVLDD4D2 2:34.389670 1-1
Accounting REPORT COMPLETE
Top-5 Getpages in Accounting trace
⋮
ACCOUNTING
TRACE
TOP (5 GETPAGES)
⋮
Accounting trace - TOP listing - example
The following example shows the last page of an Accounting trace. The TOP list on the last page of the trace consists of the five entries that had the highest number of Getpage requests. Each entry consists of TIMESTAMP, PRIMAUTH, and PLANNAME information, the value of the number of Getpage requests, and the page number where the trace entry can be found.
LOCATION: STLEC1 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 7-1
GROUP: N/P Accounting TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: V51A ACTUAL FROM: 08/25/15 22:02:59.55
DB2 VERSION: V10 PAGE DATE: 08/25/15
GETPAGE REQUESTS TOP NUMBER REQUESTED: 5
TIMESTAMP
PRIMAUTH
PLANNAME VALUE PAGE
---- -------------------------------------------------------- --------------- ----------
03/10/15 20:04:20.248358
SYSADM
1 PVLDD4B3 6232 1-1
03/10/15 20:06:02.809223
SYSADM
2 PVLDD4C3 2422 1-1
03/10/15 20:05:27.859210
SYSADM
3 PVLDD4D1 675 1-1
03/10/15 19:55:02.046545
SYSADM
4 PVLDD4D2 584 1-1
03/10/15 20:05:17.508593
SYSADM
5 DSNBIND 446 1-1
Accounting TRACE COMPLETE
TOP lists of available fields in Accounting report
You can generate, for example, Accounting reports that show TOP lists for all fields available for use with the TOP subcommand option, as shown in the following command:
⋮
ACCOUNTING
REPORT
TOP (*)
⋮
Top-3 default field in Accounting trace
To produce a filtered trace that shows only the top-3 entries for the default TOP field, namely ELAPSED TIME IN APPLICATION, use the following command:
⋮
Accounting
TRACE
TOP (3 ONLY)
⋮
Accounting trace - TOP ONLY list - example
The following example shows an Accounting trace with a TOP ONLY list.
LOCATION: STLEC1 IBM OMEGAMON FOR DB2 PERFORMANCE
EXPERT (V5R5M0) PAGE: 7-1
GROUP: N/P Accounting TRACE - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: N/P TO: NOT SPECIFIED
SUBSYSTEM: V51A ACTUAL FROM: 08/25/15 22:02:59.55
DB2 VERSION: V10 PAGE DATE: 08/25/15
ELAPSED TIME SPENT IN APPLICATION TOP NUMBER REQUESTED: 3
PRIMAUTH CORRNAME CONNECT ACCT TIMESTAMP COMMITS OPENS UPDATES INSERTS EL. TIME(CL1) EL. TIME(CL2) GETPAGES SYN.READ LOCK SUS
PLANNAME CORRNMBR THR.TYPE TERM. CONDITION SELECTS FETCHES DELETES PREPARE TCB TIME(CL1) TCB TIME(CL2) BUF.UPDT TOT.PREF LOCKOUTS
-------- -------- -------- --------------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
ALAN ALAN DB2CALL 06:10:27.947430 1 0 0 0 7.875259 7.866377 20 0 1
RXSQL 'BLANK' ALLIED NORM DEALLOC 0 0 1 0 0.023011 0.017931 6 1 0
ALAN ALAN DB2CALL 06:09:06.509263 1 0 0 0 4.175839 4.167954 20 0 1
RXSQL 'BLANK' ALLIED NORM DEALLOC 0 0 1 0 0.020973 0.016198 6 1 0
ALAN ALAN DB2CALL 06:07:59.399773 1 0 0 1 2.698825 2.689779 15 0 1
RXSQL 'BLANK' ALLIED NORM DEALLOC 0 0 0 0 0.017036 0.012228 2 0 0
Accounting TRACE COMPLETE