Personal tools
You are here: Home Forums DB2 Asynchronous pool data page reads ?????????
Navigation
Log in


Forgot your password?
 
Document Actions

Asynchronous pool data page reads ?????????

Up to DB2

Asynchronous pool data page reads ?????????

Posted by Pawan at April 17. 2008

Hi, Whats mean Asynchronous pool data page reads.......


sudden taking too much???how remove that???         



Buffer pool data logical reads             = 9129169
Buffer pool data physical reads            = 5159477
Buffer pool temporary data logical reads   = 11226
Buffer pool temporary data physical reads  = 0
Asynchronous pool data page reads          = 5155607
Buffer pool data writes                    = 13340
Asynchronous pool data page writes         = 10252
Buffer pool index logical reads            = 4311772
Buffer pool index physical reads           = 583180
Buffer pool temporary index logical reads  = 0
Buffer pool temporary index physical reads = 0
Asynchronous pool index page reads         = 547845
Buffer pool index writes                   = 5250
Asynchronous pool index page writes        = 3822
Total buffer pool read time (milliseconds) = 3755903
Total buffer pool write time (milliseconds)= 51108
Total elapsed asynchronous read time       = 3503608
Total elapsed asynchronous write time      = 40889
Asynchronous data read requests            = 150545
Asynchronous index read requests           = 14203
No victim buffers available                = 211773
LSN Gap cleaner triggers                   = 1081
Dirty page steal cleaner triggers          = 16
Dirty page threshold cleaner triggers      = 0
Time waited for prefetch (ms)              = 9925135
Unread prefetch pages                      = 134946
Direct reads                               = 77398690
Direct writes                              = 3066
Direct read requests                       = 4957
Direct write requests                      = 364
Direct reads elapsed time (ms)             = 1408341
Direct write elapsed time (ms)             = 947
Database files closed                      = 789
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


Re: Asynchronous pool data page reads ?????????

Posted by perallis at April 17. 2008

Hi Pawan,

The "Asynchronous pool data page reads"  indicates the total amount of time spent reading in data and index pages from the table space containers (physical) by asynchronous engine dispatchable units (EDUs) for all types of table spaces. This value is given in microseconds.




More Details: Infocenter DB2LUW V8


Powered by Ploneboard
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls