Pool-GUYTM Bufferpool Snapshot for GUYSDB1

HTML Prepared: Thu Nov 5 01:23:10 EST 1998
Server: wiseguy
Snapshot Number: 5

 
Bufferpool
Name
 
Size
MB
 
Page
Size
Database
Files
Closed
Index
Hit
Ratio
Overall
Hit
Ratio
Overall
Average
Read ms
Asynchronous
Average
Read ms
Synchronous
Average
Read ms
Overall
Average
Write ms
Asynchronous
Average
Write ms
Synchronous
Average
Write ms
Asynchronous
Pages Read
Per Request
Pages
Read
Per Minute
Asynchronous
Write
Percentage
Asynchronous
Read
Percentage
Synchronous
Write
Percentage
Synchronous
Read
Percentage
 
Bufferpool
Name
SUPERHOTDATABP 10.7 4096 0 96 96 4 1 7 23 23 23 4 275 100 46 0 54 SUPERHOTDATABP
SYSCATBP1 8.8 4096 0 98 95 2 2 7 20 21 20 8 182 100 48 0 52 SYSCATBP1
TEMPSPACEBP8K 7.8 8192 0 0 77 2 3 1 1 1 0 8 394 95 82 5 18 TEMPSPACEBP8K
TEMPSPACEBP4K 5.9 4096 0 0 73 1 3 1 1 1 0 8 424 94 83 6 17 TEMPSPACEBP4K
IBMDEFAULTBP 3.9 4096 0 67 64 1 1 10 3 3 0 2 169 10 36 90 64 IBMDEFAULTBP
USERBP8K 15.6 8192 8 84 77 1 1 14 4 4 0 8 260 90 19 10 81 USERBP8K
HOTINDEXBP 19.5 4096 0 99 92 0 0 3 0 0 0 4 558 100 2 0 98 HOTINDEXBP

Notes

Key Links

Database-Guys  |  International DB2 Users Group  |  IBM DB2 Home


Copyright © 1998-2002 Database-Guys. Spencerport, New York, 14559 USA. All Rights Reserved.