Filter
Top Products
DB2 PM Statistics Report 211
1 LOCATION: USIBMT6BOAPLX DB2 PERFORMANCE MONITOR (V5) PAGE: 2-7
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
LOCKING ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT DATA SHARING LOCKING QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
SUSPENSIONS (ALL) 1.00 0.03 N/C 0.50 GLOBAL CONTENTION RATE (%) 0.00
SUSPENSIONS (LOCK ONLY) 0.00 0.00 N/C 0.00 FALSE CONTENTION RATE (%) 0.00
SUSPENSIONS (LATCH ONLY) 0.00 0.00 N/C 0.00
SUSPENSIONS (OTHER) 1.00 0.03 N/C 0.50 LOCK REQUESTS (P-LOCKS) 0.00 0.00 N/C 0.00
UNLOCK REQUESTS (P-LOCKS) 0.00 0.00 N/C 0.00
TIMEOUTS 0.00 0.00 N/C 0.00 CHANGE REQUESTS (P-LOCKS) 0.00 0.00 N/C 0.00
DEADLOCKS 0.00 0.00 N/C 0.00
SYNCH.XES - LOCK REQUESTS 2044.00 60.23 N/C 1022.00
LOCK REQUESTS 2062.00 60.76 N/C 1031.00 SYNCH.XES - CHANGE REQUESTS 0.00 0.00 N/C 0.00
UNLOCK REQUESTS 2073.00 61.09 N/C 1036.50 SYNCH.XES - UNLOCK REQUESTS 2055.00 60.56 N/C 1027.50
QUERY REQUESTS 0.00 0.00 N/C 0.00 ASYNCH.XES - RESOURCES 0.00 0.00 N/C 0.00
CHANGE REQUESTS 5.00 0.15 N/C 2.50
OTHER REQUESTS 0.00 0.00 N/C 0.00 SUSPENDS - IRLM GLOBAL CONT 0.00 0.00 N/C 0.00
SUSPENDS - XES GLOBAL CONT. 0.00 0.00 N/C 0.00
LOCK ESCALATION (SHARED) 0.00 0.00 N/C 0.00 SUSPENDS - FALSE CONTENTION 0.00 0.00 N/C 0.00
LOCK ESCALATION (EXCLUSIVE) 0.00 0.00 N/C 0.00 INCOMPATIBLE RETAINED LOCK 0.00 0.00 N/C 0.00
DRAIN REQUESTS 0.00 0.00 N/C 0.00 NOTIFY MESSAGES SENT 1.00 0.03 N/C 0.50
DRAIN REQUESTS FAILED 0.00 0.00 N/C 0.00 NOTIFY MESSAGES RECEIVED 0.00 0.00 N/C 0.00
CLAIM REQUESTS 56.00 1.65 N/C 28.00 P-LOCK/NOTIFY EXITS ENGINES 500.00 N/A N/A N/A
CLAIM REQUESTS FAILED 0.00 0.00 N/C 0.00 P-LCK/NFY EX.ENGINE UNAVAIL 0.00 0.00 N/C 0.00
PSET/PART P-LCK NEGOTIATION 0.00 0.00 N/C 0.00
PAGE P-LOCK NEGOTIATION 0.00 0.00 N/C 0.00
OTHER P-LOCK NEGOTIATION 0.00 0.00 N/C 0.00
P-LOCK CHANGE DURING NEG. 0.00 0.00 N/C 0.00
GLOBAL DDF ACTIVITY QUANTITY /MINUTE /THREAD /COMMIT QUERY PARALLELISM QUANTITY /MINUTE /THREAD /COMMIT
--------------------------- -------- ------- ------- ------- --------------------------- -------- ------- ------- -------
DBAT QUEUED-MAXIMUM ACTIVE N/P N/P N/P N/A MAX.DEGREE OF PARALLELISM 5.00 N/A N/A N/A
CONV.DEALLOC-MAX.CONNECTED N/P N/P N/P N/A PARALLEL GROUPS EXECUTED 1.00 0.03 N/C 0.50
INACTIVE DBATS - CURRENTLY N/P N/A N/A N/A RAN AS PLANNED 1.00 0.03 N/C 0.50
INACTIVE DBATS - HWM N/P N/A N/A N/A RAN REDUCED 0.00 0.00 N/C 0.00
ACTIVE DBATS - CURRENTLY N/P N/A N/A N/A SEQUENTIAL-CURSOR 0.00 0.00 N/C 0.00
ACTIVE DBATS - HWM N/P N/A N/A N/A SEQUENTIAL-NO ESA 0.00 0.00 N/C 0.00
TOTAL DBATS - HWM N/P N/A N/A N/A SEQUENTIAL-NO BUFFER 0.00 0.00 N/C 0.00
COLD START CONNECTIONS N/P N/P N/P N/P SEQUENTIAL-ENCLAVE SER. 0.00 0.00 N/C 0.00
WARM START CONNECTIONS N/P N/P N/P N/P ONE DB2 - COORDINATOR = NO 0.00 0.00 N/C 0.00
RESYNCHRONIZATION ATTEMPTED N/P N/P N/P N/P ONE DB2 - ISOLATION LEVEL 0.00 0.00 N/C 0.00
RESYNCHRONIZATION SUCCEEDED N/P N/P N/P N/P MEMBER SKIPPED (%) 0.00