Hi Guys,
I just wondering whether is really worthwhile enabling CIO for DB2. The reason behing my question is under JFS2 and file system buffering you can basically take advantage of readahead_max_pages which makes a huge difference when performing large read sequential (e.g database backup or even large joins suh as the one's common on a datawarehouse ). My impresion is that once CIO is enable it'll use DIO implicitly therefore all reads/writes will be done synchronously unless the data is already in the db2 bufferpool. I wonder if anyone else who has implemented CIO DIO for DB2 can share their experience regardless they were positive or negative. thanks in advance.
Harby.