Configuring Work with Dialog Box Retrieval Limits


Overview

Tasks

Included with

Tivoli Problem Management

Overview

Database retrieval limits for Work with dialog boxes

You can configure the database retrieval limit for any Work with dialog box. Database retrieval limits eliminate queries that can suspend a workstation's operation for long periods of time and that slow down the operation of the database server by retrieving every record of a particular type

By default, all Work with dialog boxes retrieve a maximum of 200 rows of data. Also, Work with dialog boxes do not page to the next 200 rows of data. You can shorten retrieval time by decreasing this limit where appropriate. See Configuring database retrieval limits for Work with dialog boxes.


Tasks

Configuring database retrieval limits for Work with dialog boxes

To configure the database retrieval limit for a Work with dialog box:
  1. Access the Tivoli Toolkit Interface Designer, by doing one of the following:
    • From the Start menu, point to Programs, then Tivoli Service Desk '99, then Tivoli Developer's Toolkit and choose Interface Designer.
    • At the command prompt, type i-design and press Enter.
      Result: The TDT Interface Designer window appears.
  2. From the File menu, choose Open.
  3. In the Select Resource File dialog box, from the Look In list, select the directory containing the Tivoli Problem Management DF files.
  4. Select the DF file that contains the Work with dialog box you want to modify and choose Open.
    Result: A list of all the dialog boxes contained in the selected DF file appears in the Forms tab of the Tivoli Toolkit Interface Designer window. For more information on DF files and the dialog boxes contained in them, see the Tivoli Service Desk Technical Reference.
  5. Select the dialog box you want to modify and choose Update.
    Result: The selected dialog box appears in design mode.
  6. Double-click anywhere in the table area.
  7. In the Control Properties dialog box, choose the SQL tab.
  8. In the SQL tab, in the Record Limit box, type a new value.
    Note: The value in the Record Limit box defines the maximum number of rows of data the dialog box can retrieve. There is no recommended value that works in every situation. In general, the larger the limit, the longer it takes for the dialog box to display the requested records. However, if you set too small a limit, the dialog box may not contain enough information to be useful to your help desk analysts.
  9. Choose OK.
    Result: The selected dialog box appears in design mode.
  10. Press Alt+F4 to quit design mode.
    Result: The Tivoli Toolkit Interface Designer window reappears.
  11. From the File menu, choose Save.
    Result: The Tivoli Toolkit Interface Designer automatically reparses all of the dialog boxes that you modified in the selected DF file.
  12. From the File menu, choose Exit to quit the Tivoli Toolkit Interface Designer.

Note: For more information on using the Tivoli Toolkit Interface Designer, see the Tivoli Toolkit Interface Designer Guide.