Member-scope reports
Member-scope reports present the activity of a data sharing group by member.
The activity shown for each member consists of the originating query activity and any parallel activity, including any parallel activity that is performed on other members.
The data in member-scope reports is presented by a combination of location, group, subsystem, and member. Whenever one of these values changes, a new page is started and the page number is initialized. The following command produces a member-scope Accounting report shown in Member-scope Accounting report. The command uses the SHORT layout and the default order of the OMEGAMON XE for DB2 PE identifiers, namely plan name within primary authorization ID.
ACCOUNTING
REPORT
Member-scope Accounting report
The following example shows a member-scope Accounting short report resulting from the default order of the OMEGAMON for Db2 Performance Expert identifiers:
- The data is ordered according to the authorization IDs and plans. All primary authorization IDs and plans from the input data are shown.
- The TOTAL is printed for primary authorization IDs that contain more than one plan.
GRAND TOTALis printed at the end of each member if there is more than one first-level identifier reported.
LOCATION: DSN420Y OMEGAMON XE for DB2 Performance Expert (V5R4M0) PAGE: 1-1
GROUP: DSN420Y Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: Y42A TO: NOT SPECIFIED
SUBSYSTEM: Y42A ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/03/15 08:05:17.91
DB2 VERSION: V11 SCOPE: MEMBER TO: 12/03/15 10:29:26.02
PRIMAUTH #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
PLANNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
USRT001 1 0 0.00 0.00 0.00 0.00 1:09.259093 1:09.083514 211.0K 114.00 47.00
DSNTEP41 0 1 3.00 1.00 1.00 2.00 1:37.745921 1:37.703681 4.00 6508.00 0
USRT001 10 5 0.00 0.00 0.00 0.00 20:01.439219 14:10.483534 188.7K 63646.00 1621.10
DSNTEP42 0 5 907.2K 0.90 0.40 2.40 20:33.424823 14:30.612146 823.10 6581.00 0
*** TOTAL ***
USRT001 11 5 0.00 0.00 0.00 0.00 18:18.513753 12:59.447169 190.7K 57870.36 1478.00
0 6 824.7K 0.91 0.45 2.36 18:50.181286 13:20.347740 748.64 6574.36 0
USRT002 1 1 0.00 0.00 0.00 0.00 36.295613 36.185947 51541.00 87.00 66.00
DSNTEP41 0 0 0.00 1.00 0.00 2.00 56.797521 56.780273 11114.00 1790.00 0
USRT002 3 1 0.00 0.00 0.00 0.00 2:27.021948 1:40.436879 24810.67 6653.33 78.00
DSNTEP42 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
*** GRAND TOTAL ***
15 7 0.00 0.00 0.00 0.00 13:57.400849 9:54.094363 148.3K 43774.73 1103.87
0 8 644.8K 0.87 0.40 2.27 14:19.263630 10:07.544830 2340.67 5065.93 0
LOCATION: DSN420Y OMEGAMON XE for DB2 Performance Expert (V5R4M0) PAGE: 2-1
GROUP: DSN420Y Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: Y42C TO: NOT SPECIFIED
SUBSYSTEM: Y42C ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/03/15 08:07:02.90
DB2 VERSION: V11 SCOPE: MEMBER TO: 12/03/15 08:08:47.43
PRIMAUTH #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
PLANNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
USRT001 2 0 0.00 0.00 0.00 0.00 50.545437 50.372842 181.2K 10.00 13.00
DSNTEP42 0 2 2.00 1.00 1.00 2.00 3:25.952714 3:25.915981 0.00 5676.00 0
LOCATION: DSN420Y OMEGAMON XE for DB2 Performance Expert (V5R4M0) PAGE: 3-1
GROUP: DSN420Y Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: Y42D TO: NOT SPECIFIED
SUBSYSTEM: Y42D ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/03/15 08:10:34.27
DB2 VERSION: V11 SCOPE: MEMBER TO: 12/03/15 08:12:20.87
PRIMAUTH #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
PLANNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
USRT001 2 0 0.00 0.00 0.00 0.00 53.137971 52.965162 181.2K 10.00 14.50
DSNTEP42 0 2 2.00 1.00 1.00 2.00 3:03.516934 3:03.480655 0.00 5676.00 0
LOCATION: DSN420Y OMEGAMON XE for DB2 Performance Expert (V5R4M0) PAGE: 4-1
GROUP: DSN420Y Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: Y42E TO: NOT SPECIFIED
SUBSYSTEM: Y42E ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/03/15 08:14:07.67
DB2 VERSION: V11 SCOPE: MEMBER TO: 12/03/15 08:14:07.67
PRIMAUTH #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
PLANNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
USRT001 1 0 0.00 0.00 0.00 0.00 53.216137 53.051699 181.2K 10.00 13.00
DSNTEP42 0 1 2.00 1.00 1.00 2.00 4:20.204918 4:20.170015 0.00 5676.00 0
LOCATION: DSN420Y OMEGAMON XE for DB2 Performance Expert (V5R4M0) PAGE: 5-1
GROUP: DSN420Y Accounting REPORT - SHORT REQUESTED FROM: NOT SPECIFIED
MEMBER: Y42F TO: NOT SPECIFIED
SUBSYSTEM: Y42F ORDER: PRIMAUTH-PLANNAME INTERVAL FROM: 12/03/15 08:15:52.82
DB2 VERSION: V11 SCOPE: MEMBER TO: 12/03/15 08:17:36.85
PRIMAUTH #OCCURS #ROLLBK SELECTS INSERTS UPDATES DELETES CLASS1 EL.TIME CLASS2 EL.TIME GETPAGES SYN.READ LOCK SUS
PLANNAME #DISTRS #COMMIT FETCHES OPENS CLOSES PREPARE CLASS1 CPUTIME CLASS2 CPUTIME BUF.UPDT TOT.PREF #LOCKOUT
---------------------------------- ------- ------- ------- ------- ------- ------- -------------- -------------- -------- -------- --------
USRT001 2 0 0.00 0.00 0.00 0.00 50.873688 50.702225 181.2K 10.00 13.00
DSNTEP42 0 2 2.00 1.00 1.00 2.00 3:49.127243 3:49.091691 0.00 5676.00 0
ACCOUNTING REPORT COMPLETE