Setting database retrieval parameters

When you retrieve data from a database, the performance of your workstation can be adversely affected by the amount of data being retrieved and the rate at which the screen is refreshed to display the data. You can adjust the database retrieval parameters to achieve the correct balance between data retrieval and performance.

About this task

The database engine processes the number of rows specified and then the screen is refreshed. However, if you are monitoring the interactive behaviour of another application, this action might slow the overall process because the screen is refreshed many times. The Database Retrieval Parameters pane provides a tuning option for interface or retrieval.

Procedure

  1. From the workbench menu bar, click Window > Preferences > Database Retrieval Parameters. The Database Retrieval Parameters pane is displayed in the Preferences window:
    Screen capture of the Preferences window that shows the Database Retrieval Parameters panel
  2. Enter the number of rows that you want to retrieve for each request.
  3. Click OK. When you run a search or query, the CICS® IA plug-in reads data from the host until the number of rows of data that you specified are displayed. The number of resources retrieved is displayed in the status area at the bottom of the view. If there are more resources to retrieve, the Retrieve more button is available. Click Retrieve more to fetch the next resources, up to the limit.

    In the following example, the number of rows to retrieve is set to 200 and the first 200 resources are displayed. If you click Retrieve more, the query or search pauses again after 400 resources are retrieved.

    Screen capture of the Show Resources view with search results when the number of rows to retrieve is set to 200.