Sam Durai <re***********@gmail.comwrites:
What is the minimum unit of I/O in DB2 9. Is it extendsize or
prefetch size or pagesize ?
The min unit of i/o is always the pagesize. Extentsize is the unit a
prefetcher will issue i/o for when prefetching. Prefetchsize is the
total i/o being done during prefetching via multiple prefetchers.
For details see the Performance doc in the DB2 guides.
http://publib.boulder.ibm.com/infoce...c/c0004962.htm
--
Haider