Wise-GUYTM Database Snapshot for PERFDB

HTML Prepared: Mon Dec 30 17:19:09 EST 2002, Auto-Refresh=Manual Reload Required
Server: dgiaix02, Node: 3
Snapshot Number: 240 Wise-GUY temporary license license expires on TR 20021231
Approximate Interval: 120 seconds

System Utilization at a Glance

 
 
Database
Connections
SORTHEAP
Used (4K Pages)
CPU
Busy
 
Paging
VM
Used
Active
Sorts
Current 1 0 68 % 0 560 MB 0
Average 3 0 53 % 0 594 MB 0
Max 4 0 100 % 0 601 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 6 0 0 %
BP Phys Writes 0 21 0 0 %
Direct Reads 0 0 0 0 %
Direct Writes 0 0 0 0 %
PKG Cache Inserts 0 6 0 0 %
Sorts 0 3 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
36 3 ms 0 0 0 36 36 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: 6 ms
Overall Average Write Time: 21 ms
Random Read (Sync): 35 %
Asynchronous Write: 0 %
Index Hit Ratio: 100 %
Overall Hit Ratio: 99 %

  Logical Physical Asynchronous
Data Reads 5286 159 102
Data Writes   1 0
Index Reads 4646 11  
Index Writes   0 0

Critical Caches

  Lookups Inserts Hit % Overflows Heap
Full
High
Water
Package Cache 760 68 92 0 N/A 158 4K
Application Sections 2689 87 97 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
726 0 2588 670 642 6 0 0

Rows

Selected Deleted Updated Inserted
638 0 0 14

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 39
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 52368
Agents created from empty pool 14
Agents stolen from another application 0
High water mark for coordinating agents 9
Max agents overflow 0
High water mark for agents registered 14
High water mark for agents waiting for a token 0
Agents registered 14
Agents waiting for a token 0
Idle agents 12
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 68
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 35 %
Asynchronous Write 0 %
Index Hit Ratio 100 %
Overall Hit Ratio 99 %
Caches

Package Cache Hit 92
Section Cache Hit 97
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.com.  |  International DB2 Users Group  |  IBM DB2 Home


Copyright © 2000 Database-Guys.com. Spencerport, New York, 14559 USA. All Rights Reserved. Final Snapshot Number: 241