MAXROWSRETURNED
The MAXROWSRETURNED parameter specifies the maximum number of rows a query can return to the client. The governor imposes the restriction you specify after any WHERE clause is fully processed, but before the result table is returned to the application.
Description
MAXROWSRETURNED provides protection from excessive resource use that inefficient or erroneous queries cause.
Specifications
Use: Configuration parameter for the query processor services.
Service class: QP
Service task: CACQP
Data type: INT
Default: 0
Valid values: 0 - 2147483647