Group-scope reports
Group-scope reports show the instrumentation data aggregated by the OMEGAMON for Db2 Performance Expert identifiers that you specified and by the individual members.
The data is presented by a combination of location and group. Whenever either of these values
changes, a new page is started and the page number is initialized. The following command
produces a group-scope Accounting report shown in Group-scope Accounting report. The
command uses the SHORT layout and the default order of the OMEGAMON for Db2 PE
identifiers, namely plan names within primary authorization IDs.
ACCOUNTING
REPORT
SCOPE(GROUP)
Group-scope Accounting report
Here is an example of a group-scope Accounting report:
- The data is ordered according to the authorization IDs and plans. All primary authorization IDs and plans from the input data are shown. MEMBER is automatically added as the last ORDER identifier.
- The GROUP TOTAL is printed for primary authorization IDs and plans that contain more than one member.
- The TOTAL is printed for primary authorization IDs that contain more than one plan.
GRAND TOTALis printed at the end of each group if there is more than one first-level identifier reported.
LOCATION: DSN420Y OMEGAMON for DB2 Performance Expert (V5R5M0) PAGE: 1-1
GROUP: DSN420Y Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
TO: NOT SPECIFIED
ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/03/15 08:05:17.91
DB2 VERSION: V11 SCOPE: GROUP TO: 12/03/15 10:29:26.02
PRIMAUTH
PLANNAME #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
MEMBER #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
USRT001
DSNTEP41 1 0 0.00 0.00 0.00 0.00 1:09.259093 1:09.083514 211.0K 114.00 47.00
Y42A 0 1 3.00 1.00 1.00 2.00 1:37.745921 1:37.703681 4.00 6508.00 0
USRT001
DSNTEP42 10 5 0.00 0.00 0.00 0.00 20:01.439219 14:10.483534 188.7K 63646.00 1621.10
Y42A 0 5 907.2K 0.90 0.40 2.40 20:33.424823 14:30.612146 823.10 6581.00 0
USRT001
DSNTEP42 2 0 0.00 0.00 0.00 0.00 50.545437 50.372842 181.2K 10.00 13.00
Y42C 0 2 2.00 1.00 1.00 2.00 3:25.952714 3:25.915981 0.00 5676.00 0
USRT001
DSNTEP42 2 0 0.00 0.00 0.00 0.00 53.137971 52.965162 181.2K 10.00 14.50
Y42D 0 2 2.00 1.00 1.00 2.00 3:03.516934 3:03.480655 0.00 5676.00 0
USRT001
DSNTEP42 1 0 0.00 0.00 0.00 0.00 53.216137 53.051699 181.2K 10.00 13.00
Y42E 0 1 2.00 1.00 1.00 2.00 4:20.204918 4:20.170015 0.00 5676.00 0
USRT001
DSNTEP42 2 0 0.00 0.00 0.00 0.00 50.873688 50.702225 181.2K 10.00 13.00
Y42F 0 2 2.00 1.00 1.00 2.00 3:49.127243 3:49.091691 0.00 5676.00 0
*** GROUP TOTAL ***
USRT001
DSNTEP42 17 5 0.00 0.00 0.00 0.00 12:08.042501 8:41.527500 185.6K 37442.94 959.12
0 12 533.6K 0.94 0.65 2.24 13:33.626290 10:00.192243 484.18 6208.35 0
*** TOTAL ***
USRT001
18 5 0.00 0.00 0.00 0.00 11:31.443423 8:16.391723 187.0K 35369.11 908.44
0 13 504.0K 0.94 0.67 2.22 12:53.855158 9:32.276212 457.50 6225.00 0
USRT002
DSNTEP41 1 1 0.00 0.00 0.00 0.00 36.295613 36.185947 51541.00 87.00 66.00
Y42A 0 0 0.00 1.00 0.00 2.00 56.797521 56.780273 11114.00 1790.00 0
USRT002
DSNTEP42 3 1 0.00 0.00 0.00 0.00 2:27.021948 1:40.436879 24810.67 6653.33 78.00
Y42A 0 2 200.2K 0.67 0.33 2.00 2:13.387595 1:24.189014 5253.67 627.00 0
*** TOTAL ***
USRT002
4 2 0.00 0.00 0.00 0.00 1:59.340364 1:24.374146 31493.25 5011.75 75.00
0 2 150.1K 0.75 0.25 2.00 1:54.240077 1:17.336829 6718.75 917.75 0
LOCATION: DSN420Y OMEGAMON for DB2 Performance Expert (V5R5M0) PAGE: 1-2
GROUP: DSN420Y Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
TO: NOT SPECIFIED
ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/03/15 08:05:17.91
DB2 VERSION: V11 SCOPE: GROUP TO: 12/03/15 10:29:26.02
PRIMAUTH
PLANNAME #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
MEMBER #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
*** GRAND TOTAL ***
22 7 0.00 0.00 0.00 0.00 9:47.424685 7:01.479436 158.7K 29849.59 756.91
0 15 439.6K 0.91 0.59 2.18 10:53.925143 8:02.287233 1595.91 5260.05 0
ACCOUNTING REPORT COMPLETE