Filter
Top Products
© Copyright IBM Corp. 1999 205
Appendix D. DB2 PM Statistics Report
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-1
GROUP: BOAG STATISTICS REPORT - LONG REQUESTED FROM: 02/12/99 15:06:03.00
MEMBER: NB22 TO: 02/12/99 15:44:05.00
SUBSYSTEM: NB22 INTERVAL FROM: 02/12/99 15:09:49.64
DB2 VERSION: V5 SCOPE: MEMBER TO: 02/12/99 15:43:45.80
---- HIGHLIGHTS ----------------------------------------------------------------------------------------------------
INTERVAL START : 02/12/99 15:09:49.64 SAMPLING START: 02/12/99 15:09:49.64 TOTAL THREADS : 0.00
INTERVAL END : 02/12/99 15:43:45.80 SAMPLING END : 02/12/99 15:43:45.80 TOTAL COMMITS : 2.00
INTERVAL ELAPSED: 33:56.157107 OUTAGE ELAPSED: 0.000000 DATA SHARING MEMBER: N/A
SQL DML QUANTITY /MINUTE /THREAD /COMMIT SQL DCL QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
SELECT 0.00 0.00 N/C 0.00 LOCK TABLE 0.00 0.00 N/C 0.00
INSERT 0.00 0.00 N/C 0.00 GRANT 0.00 0.00 N/C 0.00
UPDATE 0.00 0.00 N/C 0.00 REVOKE 0.00 0.00 N/C 0.00
DELETE 0.00 0.00 N/C 0.00 SET HOST VARIABLE 0.00 0.00 N/C 0.00
SET CURRENT SQLID 0.00 0.00 N/C 0.00
PREPARE 0.00 0.00 N/C 0.00 SET CURRENT DEGREE 0.00 0.00 N/C 0.00
DESCRIBE 0.00 0.00 N/C 0.00 SET CURRENT RULES 0.00 0.00 N/C 0.00
DESCRIBE TABLE 0.00 0.00 N/C 0.00
OPEN 0.00 0.00 N/C 0.00 CONNECT TYPE 1 0.00 0.00 N/C 0.00
CLOSE 1.00 0.03 N/C 0.50 CONNECT TYPE 2 1.00 0.03 N/C 0.50
FETCH 101.00 2.98 N/C 50.50 RELEASE 0.00 0.00 N/C 0.00
SET CONNECTION 0.00 0.00 N/C 0.00
TOTAL 102.00 3.01 N/C 51.00 ASSOCIATE LOCATORS 0.00 0.00 N/C 0.00
ALLOCATE CURSOR 0.00 0.00 N/C 0.00
TOTAL 1.00 0.03 N/C 0.50