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
- From the workbench menu bar, click . The Database Retrieval Parameters pane is displayed
in the Preferences window:
- Enter the number of rows that you want to retrieve for
each request.
- 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.