467,189 Members | 1,320 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,189 developers. It's quick & easy.

IOs in DB2

How can we distinguish sequnetial vs random IOs in db2. IS there any
kind of db2 or OS level monitoring that can help in this regard ? I am
running db2 on windows.

thanks
Sep 6 '07 #1
  • viewed: 1645
Share:
2 Replies
TMAG wrote:
How can we distinguish sequnetial vs random IOs in db2. IS there any
kind of db2 or OS level monitoring that can help in this regard ? I am
running db2 on windows.
I'm far from beinmg an expert on the topic, but here is where I'd start
to look:
http://publib.boulder.ibm.com/infoce...c/r0001244.htm

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Sep 7 '07 #2
random IO can be seen in logical/physical read and write to buffer
pool (asynchr.).
sequential IO is done by the prefetchers.

On Sep 6, 11:24 pm, TMAG <to_t...@hotmail.comwrote:
How can we distinguish sequnetial vs random IOs in db2. IS there any
kind of db2 or OS level monitoring that can help in this regard ? I am
running db2 on windows.

thanks

Sep 13 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.