Figure 1. MULTIFETCH Format
This parameter indicates the number of rows per multiple-row fetch. n can be any integer from 1 to 1000. The default 100 rows per fetch will be used if MULTIFETCH is not specified. A higher number of rows per fetch may enhance DB2 query performance, but more storage will be consumed. When the storage amount exceeds an internal value, MFX will dynamically reduce the number of rows per fetch.
The multiple-row fetch feature can only be used for DB2 version 8 and above. It will be ignored for prior DB2 versions.