Hi everyone,

i am looking at my estat and showing lots of db_file_scattered_reads (full Table Scans). Our parameter = 6 and block size = 4096. I am under the impression, increasing the db_file_multiblock_read_count will help read more blocks into the cache at one time, decreasing IO?

db_file_multiblock_read_count = (max_IO_size/db_block_size)

How do I find the max_io_size for aix 4.3.2, unix, rs6000 server?


Thanks,
Kathy