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 settings on this page 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 might slow the overall process down because the screen is refreshed many times. The Database retrieval parameters pane provides you with a tuning option for interface or retrieval.

Procedure

  1. Click Window > Preferences from the workbench menu bar, expand the CICS Explorer® folder and click Database Retrieval Parameters. The Database Retrieval Parameters pane is displayed in the Preferences view:
    A screen capture showing the database retrieval parameters
  2. Enter the number of rows that you want to retrieve for each request.
  3. Click OK. The number of rows of data that you specified are displayed. You can click the Retrieve more button to display more rows of data. The number of rows that are retrieved is based on the number you previously specified.
    screen capture showing the retrieved data