|
View previous topic :: View next topic
|
| Author |
Message |
soundarr
New User
Joined: 17 Jan 2008
Posts: 25
Location: Chennai
|
|
|
|
Dear All,
I use IBM DB2 Query Monitor to check query performances. In that, for one of my queries, I see an exec count of 0 while the GetPages count is a non-zero value.
Trying to understand the meaning of this. Please suggest.
Thanks
Soundarr |
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
May be that page is already in one of the subsystem's buffer pools, the GETPAGE counter is incremented by one and the I/O counter is not incremented.
Why not to send an email to DBA, they can help you well? |
|
| Back to top |
|
|
|
|
