Wise-GUYTM Database Snapshot for PERFDB

HTML Prepared: Tue Nov 13 11:22:35 EST 2001
Server: dgiaix02, Node: 3
Snapshot Number: 95 Wise-GUY(TM) temporary license expires on TR 20011231
Approximate Interval: 120 seconds

System Utilization at a Glance

 
 
Database
Connections
SORTHEAP
Used (4K Pages)
CPU
Busy
 
Paging
VM
Used
Active
Sorts
Current 3 0 69 % 0 521 MB 0
Average 3 0 40 % 0 506 MB 0
Max 3 0 100 % 7 521 MB0

Transaction Composition Analysis

I/O, Sorts, Locks, Cache Activity, SQL
Resource
Type
Count
Per Transaction
Average
Response Time (ms)
Extended Cost
(Count x Avg ms)
Percent
Time Cost
BP Phys Reads 0 0 0 0 %
BP Phys Writes 0 0 0 0 %
Direct Reads 0 0 0 0 %
Direct Writes 0 0 0 0 %
PKG Cache Inserts 0 0 0 0 %
Sorts 0 0 0 0 %
Lock Waits 0 0 0 0 %
Total Time/TX
0 ms
Selects 0
Rows Selected 0 Avg Rows Selected Per Select 0
Hash Joins 0
DML Statements 0 INS/TX: 0 UPD/TX: 0 DEL/TX: 0

Locks

 
Timeouts
 
Deadlocks
Share
Escalations
Exclusive
Escalations
Lock
Waits
Average
Time
Lock List
in Use
Lock List
High Water
0 0 0 0 0 0 ms 1 1

Sorts

 
Count
Average
Time
Currently
Active
Overflow
Count
Overflow
Percent
Piped
Requested
Piped
Accepted
Accepted
Percent
0 0 ms 0 0 0 0 0 100

Hash Joins

 
Count
Hash
Loops
Small
Overflows
Big
Overflows
Hash
Satisfied
Hash
Looped
Small
Overflows
Big
Overflows
0 0 0 0 100 % 0 % 0 % 0 %

Bufferpool I/O

Overall Average Read Time: 0 ms
Overall Average Write Time: 0 ms
Random Read (Sync): 0 %
Asynchronous Write: 0 %
Index Hit Ratio: 100 %
Overall Hit Ratio: 100 %

  Logical Physical Asynchronous
Data Reads 0 0 0
Data Writes   0 0
Index Reads 0 0  
Index Writes   0 0

Critical Caches

  Lookups Inserts Hit % Overflows Heap
Full
High
Water
Package Cache 260 8 97 0 N/A 39 4K
Application Sections 1024 9 100 N/A N/A N/A
Catalog Cache 0 0 100 0 0 N/A

Note: Package Cache Overflows and High Water only available for DB2 UDB V6.1 and higher

Log Space

Maximum Primary Log Space Used 1 MB 0 %
Average Statements per Transaction 0 DML 4 ALL

Extended Log Space Statistics for DB2 UDB V6+

Application ID Holding Oldest Transaction: 0
Log Space Available to Database (4K Pages): 2987
Log Space in use by the Database (4K Pages): 0, 0 %

SQL Activity

SQL Types

Commits Rollbacks Dynamic
SQL
Static
SQL
Select
SQL
DML
SQL
Binds &
Preps
DDL
263 0 1024 263 256 0 0 0

Rows

Selected Deleted Updated Inserted
255 0 0 0

Direct I/O

Access
Type
Actual
Count
Number
Requests
Average Sectors
per Request
Average
Time (ms)
Direct Reads 0 0 0 0
Direct Writes 0 0 0 0

Internal Counts

Type Count
Automatic Rebinds 0
Commits 6
Rollbacks 0
Rollbacks due to Deadlock 0
Rows Deleted 0
Rows Inserted 0
Rows Updated 0

Database Manager Agents

Description Count
Agents assigned from pool 20888
Agents created from empty pool 13
Agents stolen from another application 0
High water mark for coordinating agents 7
Max agents overflow 0
High water mark for agents registered 13
High water mark for agents waiting for a token 0
Agents registered 13
Agents waiting for a token 0
Idle agents 6
Percent of Agents Stolen 0

Dirty Cleaner Triggers

Type Count
Page Steal 0
Page Threshold 0
LSN Gap 0

Page Steal Analysis

1-20%
Reduce
NUM_IOCLEANERS
21-40%
Marginal
41-60%
Ideal
61-80%
Marginal
81-100%
Increase
NUM_IOCLEANERS
    N/A    

Percentages Recap

Scale 100 %
CPU

Current CPU 69
Maximum CPU 100
Locks

Lock List in Use 1
Max Lock List Used 1
Hash Joins

Small Overflows 0 %
Big Overflows 0 %
Loops 0 %
Satisfied 100 %
Sorts

Overflows 0 %
Piped Sorts 100 %
Bufferpool

Random Read 0 %
Asynchronous Write 0 %
Index Hit Ratio 100 %
Overall Hit Ratio 100 %
Caches

Package Cache Hit 97
Section Cache Hit 100
Catalog Cache Hit 100
Miscellaneous

Max DBHEAP Used 8
Max Primary Log Used 0 %
Agents stolen 0


Legend

Good Needs Work Action Required Data


Key Links

Database-GUYS Inc.  |  International DB2 Users Group  |  IBM DB2 Home


Copyright © 2000 Database-GUYS Inc. Spencerport, New York, 14559 USA. All Rights Reserved.