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
- 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:
- Enter the number of rows that you want to retrieve for
each request.
- 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.