IOs in DB2

[TMAG]

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

[Serge Rielau]

Re: IOs in DB2

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/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0001244.htm

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[stefan.albert]

Re: IOs in DB2

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...@hotmai l.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