Row count (-ROWCNT) adapter command for DB2 (Windows/UNIX)

Use the Row Count adapter command (-ROWCNT) to specify the number of rows to be retrieved per fetch.

-ROWCNT row_count

Option: Description
row_count: The number of rows to be retrieved per fetch. The time to fetch is optimized in accordance with the increase in the number of rows to retrieve.; Therefore, a significant performance improvement may be gained by retrieving as many rows as possible in a single fetch.

Note: The number of rows retrieved is limited only by the amount of memory installed on the querying computer.

The default for the number of rows to be retrieved per fetch for the DB2® (Windows/UNIX) Adapter is one row.