Member-scope reports and traces
OMEGAMON for Db2 Performance Expert can process all members of a data sharing group at the same time and produce reports and traces that show the Statistics data on a per-member basis.
Such member-scope reports and traces are like those produced in non-data sharing environments. Reports and traces are produced on a per-subsystem basis.
The following extracts from a long Statistics report demonstrates
the concept of member-scope reporting.
- The data sharing group DBN1 consists of two members, SN13 and SN14.
- The statistics are presented separately for each member (note
the
MEMBERfield in the page heading). - The non-data sharing counters (such as the CPU TIMES block) as well as the data sharing counters (such as the Group Buffer Pools Activity block ) are presented. To keep the figure compact only selected Statistics data is shown.
- The default Statistics interval is assumed, which means that the data is presented for the entire period the statistics are available.
- There is no aggregated statistics data for the entire group.
Long Statistics report for member SN13 of group DBN1
The following example shows a partial member-scope long Statistics report for member SN13 of group DBN1.
LOCATION: PMODBN1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 2-1
GROUP: DBN1 STATISTICS REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SN13 TO: NOT SPECIFIED
SUBSYSTEM: SN13 INTERVAL FROM: 03/27/15 21:53:27.65
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/28/15 07:53:27.65
---- HIGHLIGHTS ----------------------------------------------------------------------------------------------------
INTERVAL START : 03/27/15 21:53:27.65 SAMPLING START: 03/27/15 21:53:27.65 TOTAL THREADS : 187.00
INTERVAL END : 03/28/15 07:53:27.65 SAMPLING END : 03/28/15 07:53:27.65 TOTAL COMMITS : 47.00
INTERVAL ELAPSED: 9:59:59.999970 OUTAGE ELAPSED: 0.000000 DATA SHARING MEMBER: N/A
SQL DML QUANTITY /SECOND /THREAD /COMMIT SQL DCL QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
SELECT 56.00 0.00 0.30 1.19 LOCK TABLE 0.00 0.00 0.00 0.00
INSERT 0.00 0.00 0.00 0.00 GRANT 0.00 0.00 0.00 0.00
NUMBER OF ROWS 0.00 0.00 0.00 0.00 REVOKE 0.00 0.00 0.00 0.00
UPDATE 0.00 0.00 0.00 0.00 SET HOST VARIABLE 2.00 0.00 0.01 0.04
NUMBER OF ROWS 0.00 0.00 0.00 0.00 SET CURRENT SQLID 0.00 0.00 0.00 0.00
MERGE 0.00 0.00 0.00 0.00 SET CURRENT DEGREE 0.00 0.00 0.00 0.00
DELETE 0.00 0.00 0.00 0.00 SET CURRENT RULES 0.00 0.00 0.00 0.00
NUMBER OF ROWS 0.00 0.00 0.00 0.00 SET CURRENT PATH 0.00 0.00 0.00 0.00
SET CURRENT PRECISION 0.00 0.00 0.00 0.00
PREPARE 42.00 0.00 0.22 0.89
DESCRIBE 25.00 0.00 0.13 0.53 CONNECT TYPE 1 8.00 0.00 0.04 0.17
DESCRIBE TABLE 0.00 0.00 0.00 0.00 CONNECT TYPE 2 1.00 0.00 0.01 0.02
OPEN 18.00 0.00 0.10 0.38 RELEASE 0.00 0.00 0.00 0.00
CLOSE 18.00 0.00 0.10 0.38 SET CONNECTION 0.00 0.00 0.00 0.00
FETCH 26363.00 0.73 140.98 560.91
NUMBER OF ROWS 26358.00 0.73 140.95 560.81 ASSOCIATE LOCATORS 0.00 0.00 0.00 0.00
ALLOCATE CURSOR 0.00 0.00 0.00 0.00
TOTAL DML 26522.00 0.74 141.83 564.30
HOLD LOCATOR 0.00 0.00 0.00 0.00
FREE LOCATOR 0.00 0.00 0.00 0.00
TOTAL 11.00 0.00 0.06 0.23
STORED PROCEDURES QUANTITY /SECOND /THREAD /COMMIT TRIGGERS QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
CALL STATEMENT EXECUTED 0.00 0.00 0.00 0.00 STATEMENT TRIGGER ACTIVATED 0.00 0.00 0.00 0.00
PROCEDURE ABENDED 0.00 0.00 0.00 0.00 ROW TRIGGER ACTIVATED 0.00 0.00 0.00 0.00
CALL STATEMENT TIMED OUT 0.00 0.00 0.00 0.00 SQL ERROR OCCURRED 0.00 0.00 0.00 0.00
CALL STATEMENT REJECTED 0.00 0.00 0.00 0.00
USER DEFINED FUNCTIONS QUANTITY /SECOND /THREAD /COMMIT ROW ID QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
EXECUTED 0.00 0.00 0.00 0.00 DIRECT ACCESS 0.00 0.00 0.00 0.00
ABENDED 0.00 0.00 0.00 0.00 INDEX USED 0.00 0.00 0.00 0.00
TIMED OUT 0.00 0.00 0.00 0.00 TABLE SPACE SCAN USED 0.00 0.00 0.00 0.00
REJECTED 0.00 0.00 0.00 0.00
USE CURRENTLY COMMITTED QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- -------
INSERT ROWS SKIPPED N/A N/A N/A N/A
DELETE ROWS ACCESSED N/A N/A N/A N/A
UPDATE ROWS ACCESSED N/A N/A N/A N/A
Long Statistics report for member SN14 of group DBN1
The following example shows a partial member-scope long Statistics report for member SN14 of group DBN1.
LOCATION: PMODBN1 OMEGAMON XE FOR DB2 PERFORMANCE EXPERT (V5R4M0) PAGE: 3-1
GROUP: DBN1 STATISTICS REPORT - LONG REQUESTED FROM: NOT SPECIFIED
MEMBER: SN14 TO: NOT SPECIFIED
SUBSYSTEM: SN14 INTERVAL FROM: 03/27/15 22:06:15.94
DB2 VERSION: V10 SCOPE: MEMBER TO: 03/28/15 07:36:15.94
---- HIGHLIGHTS ----------------------------------------------------------------------------------------------------
INTERVAL START : 03/27/15 22:06:15.94 SAMPLING START: 03/27/15 22:06:15.94 TOTAL THREADS : 293.00
INTERVAL END : 03/28/15 07:36:15.94 SAMPLING END : 03/28/15 07:36:15.94 TOTAL COMMITS : 2434.00
INTERVAL ELAPSED: 9:30:00.000098 OUTAGE ELAPSED: 0.000000 DATA SHARING MEMBER: N/A
SQL DML QUANTITY /SECOND /THREAD /COMMIT SQL DCL QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
SELECT 14.00 0.00 0.05 0.01 LOCK TABLE 0.00 0.00 0.00 0.00
INSERT 0.00 0.00 0.00 0.00 GRANT 0.00 0.00 0.00 0.00
NUMBER OF ROWS 0.00 0.00 0.00 0.00 REVOKE 0.00 0.00 0.00 0.00
UPDATE 1422.00 0.04 4.85 0.58 SET HOST VARIABLE 4.00 0.00 0.01 0.00
NUMBER OF ROWS 0.00 0.00 0.00 0.00 SET CURRENT SQLID 2.00 0.00 0.01 0.00
MERGE 0.00 0.00 0.00 0.00 SET CURRENT DEGREE 0.00 0.00 0.00 0.00
DELETE 0.00 0.00 0.00 0.00 SET CURRENT RULES 0.00 0.00 0.00 0.00
NUMBER OF ROWS 0.00 0.00 0.00 0.00 SET CURRENT PATH 0.00 0.00 0.00 0.00
SET CURRENT PRECISION 0.00 0.00 0.00 0.00
PREPARE 2266.00 0.07 7.73 0.93
DESCRIBE 7.00 0.00 0.02 0.00 CONNECT TYPE 1 0.00 0.00 0.00 0.00
DESCRIBE TABLE 0.00 0.00 0.00 0.00 CONNECT TYPE 2 0.00 0.00 0.00 0.00
OPEN 1435.00 0.04 4.90 0.59 RELEASE 0.00 0.00 0.00 0.00
CLOSE 13.00 0.00 0.04 0.01 SET CONNECTION 0.00 0.00 0.00 0.00
FETCH 14604.00 0.43 49.84 6.00
NUMBER OF ROWS 13175.00 0.39 44.97 5.41 ASSOCIATE LOCATORS 0.00 0.00 0.00 0.00
ALLOCATE CURSOR 0.00 0.00 0.00 0.00
TOTAL DML 19761.00 0.58 67.44 8.12
HOLD LOCATOR 0.00 0.00 0.00 0.00
FREE LOCATOR 0.00 0.00 0.00 0.00
TOTAL 6.00 0.00 0.02 0.00
STORED PROCEDURES QUANTITY /SECOND /THREAD /COMMIT TRIGGERS QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
CALL STATEMENT EXECUTED 0.00 0.00 0.00 0.00 STATEMENT TRIGGER ACTIVATED 0.00 0.00 0.00 0.00
PROCEDURE ABENDED 0.00 0.00 0.00 0.00 ROW TRIGGER ACTIVATED 0.00 0.00 0.00 0.00
CALL STATEMENT TIMED OUT 0.00 0.00 0.00 0.00 SQL ERROR OCCURRED 0.00 0.00 0.00 0.00
CALL STATEMENT REJECTED 0.00 0.00 0.00 0.00
USER DEFINED FUNCTIONS QUANTITY /SECOND /THREAD /COMMIT ROW ID QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
EXECUTED 0.00 0.00 0.00 0.00 DIRECT ACCESS 0.00 0.00 0.00 0.00
ABENDED 0.00 0.00 0.00 0.00 INDEX USED 0.00 0.00 0.00 0.00
TIMED OUT 0.00 0.00 0.00 0.00 TABLE SPACE SCAN USED 0.00 0.00 0.00 0.00
REJECTED 0.00 0.00 0.00 0.00
USE CURRENTLY COMMITTED QUANTITY /SECOND /THREAD /COMMIT
--------------------------- -------- ------- ------- -------
INSERT ROWS SKIPPED N/A N/A N/A N/A
DELETE ROWS ACCESSED N/A N/A N/A N/A
UPDATE ROWS ACCESSED N/A N/A N/A N/A