Wise-GUYTM Database Snapshot for PERFDB

HTML Prepared: Mon Dec 30 17:37:39 EST 2002, Auto-Refresh=Manual Reload Required
Server: dgiaix02, Node: 0
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 20 % 0 538 MB 0
Average 11 0 42 % 0 593 MB 0
Max 13 0 100 % 4 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 5 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 5 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 2

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: 5 ms
Overall Average Write Time: 0 ms
Random Read (Sync): 100 %
Asynchronous Write: 0 %
Index Hit Ratio: 96 %
Overall Hit Ratio: 96 %

  Logical Physical Asynchronous
Data Reads 1008 34 0
Data Writes   0 0
Index Reads 946 47  
Index Writes   0 0

Critical Caches

  Lookups Inserts Hit % Overflows Heap
Full
High
Water
Package Cache 817 105 88 0 N/A 190 4K
Application Sections 2730 121 96 N/A N/A N/A
Catalog Cache 315 18 95 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 3 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
936 0 2588 784 642 6 0 0

Rows

Selected Deleted Updated Inserted
638 0 0 0

Direct I/O

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

Internal Counts

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

Database Manager Agents

Description Count
Agents assigned from pool 170722
Agents created from empty pool 20
Agents stolen from another application 0
High water mark for coordinating agents 9
Max agents overflow 0
High water mark for agents registered 20
High water mark for agents waiting for a token 0
Agents registered 20
Agents waiting for a token 0
Idle agents 18
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 20
Maximum CPU 100
Locks

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

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

Overflows 0 %
Piped Sorts 100 %
Bufferpool

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

Package Cache Hit 88
Section Cache Hit 96
Catalog Cache Hit 95
Miscellaneous

Max DBHEAP Used 10
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