リスト4 バッファ・プールのスナップショットの例

             Bufferpool Snapshot

Bufferpool name                            = IBMDEFAULTBP
Database name                              = SAMPLE
Database path                              = C:\DB2\NODE0000\SQL00002\
Input database alias                       = SAMPLE
Snapshot timestamp                         = 02-20-2004 06:24:45.991065

Buffer pool data logical reads             = 370
Buffer pool data physical reads            = 54
Buffer pool temporary data logical reads   = 0
Buffer pool temporary data physical reads  = 0
Buffer pool data writes                    = 3
Buffer pool index logical reads            = 221
Buffer pool index physical reads           = 94
Buffer pool temporary index logical reads  = 0
Buffer pool temporary index physical reads = 0
Total buffer pool read time (ms)           = 287
Total buffer pool write time (ms)          = 1
Asynchronous pool data page reads          = 9
Asynchronous pool data page writes         = 0
Buffer pool index writes                   = 0
Asynchronous pool index page reads         = 0
Asynchronous pool index page writes        = 0
Total elapsed asynchronous read time       = 0
Total elapsed asynchronous write time      = 0
Asynchronous data read requests            = 3
Asynchronous index read requests           = 0
No victim buffers available                = 0
Direct reads                               = 86
Direct writes                              = 4
Direct read requests                       = 14
Direct write requests                      = 2
Direct reads elapsed time (ms)             = 247
Direct write elapsed time (ms)             = 56
Database files closed                      = 0
Data pages copied to extended storage      = 0
Index pages copied to extended storage     = 0
Data pages copied from extended storage    = 0
Index pages copied from extended storage   = 0
Unread prefetch pages                      = 0
Vectored IOs                               = 3
Pages from vectored IOs                    = 9
Block IOs                                  = 0
Pages from block IOs                       = 0
Physical page maps                         = 0

Node number                                = 0
Tablespaces using bufferpool               = 4
Alter bufferpool information:
 Pages left to remove                      = 0
 Current size                              = 250
 Post-alter size                           = 250