Specifying query settings
In Server Configuration Templates—Settings—Integration Service—Query Management—Query Execution, shown in
Figure 10‑6, the administrator accepts or sets the value for each of the following properties:
Maximum run time for the query
Specify a non-zero value to set a limit on the amount of time a query can run.
Maximum query size in rows
Specify a non-zero value to set a limit on the number of rows a query returns.
Max memory per query
Specify a non-zero value to set a limit on the amount of memory a query can consume.
Max Fetch Scroll Memory Size per Query
Defines the maximum size of the memory buffer that binds to the ODBC per query. Change this value if there is sufficient memory on the machine. Use trial and error to determine the ideal setting.
Max Rows Fetched Per Fetch Scroll
Determines the total number of ODBC rows retrieved for each call of SQLFetchScroll and sets a limit on the memory usage per execution. Use trial and error to determine the ideal number of rows to retrieve per call.
Max ODA Fetch Size Per Query
Sets the fetch buffer size when fetching data from an ODA driver.
These settings are per connection, therefore all queries on the particular connection use the same setting. Using a value other than the default on upper limit could result in increased memory usage by iHub.
Figure 10‑6 Specifying Integration service query settings
