Tools Settings overview - IBM DB2 9.7 for Linux, UNIX, and Windows

Use the Tools Settings notebook to customize settings and set properties for DB2® administration tools, including documentation settings, font, and color.

Some of the pages display only after you install the centers for which they apply.

Important: The Tools Settings notebook has been deprecated in Version 9.7 and might be removed in a future release. For more information, see Control Center tools have been deprecated.

General page

Use this page specify whether the local DB2 instance should be automatically started when the DB2 tools are started, whether to use a statement termination character, whether to use searched or positioned UPDATE and DELETE statements and whether to set filtering when the maximum number of rows is exceeded from a display sample contents request.

For more information, see Setting startup and default options for the DB2 administration tools.

Documentation page

Use this page to specify whether hover help and infopop help features in the DB2 administration tools should display automatically, and also to specify the location from which the DB2 Information Center is accessed (at the instance level).

For more information, see Setting up access to DB2 contextual help and documentation.

Fonts page

Use this page to change the font in which text and menus appear in the DB2 administration tools. From the fields available, select the font size and color in which you want the menus in the DB2 administration tools to appear.

Note: Some changes will not take effect until the Control Center is restarted. If you have chosen a font color that will not show up on the background color on your system, the database manager will temporarily override the font color that you have chosen and select a font color that will show up. This system override will not be saved as part of your user profile.

For more information, see Changing the fonts for menus and text.

OS/390 and z/OS page

Use this page to set column headings and define the online and batch utility execution options for OS/390® and z/OS® objects. Defaults are provided for some of the options. For more information, see "Estimating column sizes" in Setting DB2 UDB OS/390 and z/OS utility execution options.

For the Optimize grouping of objects for parallel utility execution option, see Example 1 for online and Example 2 for batch. If this option is not selected, objects are grouped according to the order in which they were selected, with the maximum number of objects in each group. See Example 1 and Example 2.

For the Specify the Maximum number of objects to process in parallel for online execution option, see Example 1. For the Maximum number of jobs to run in parallel for batch execution and Maximum number of objects per batch job options, see Example 2.

For more information, see Setting DB2 UDB OS/390 and z/OS utility execution options.

Health Center Status Beacon page

Use this page to specify the type of notification you will receive when an alert is generated in the Health Monitor. You can be notified through a pop-up message or with the graphical beacon that displays on the lower-right portion of the status line for each DB2 center, or using both methods of notification.

For more information, see Enabling or disabling notification using the Health Center Status Beacon.

Scheduler Settings page

Use this page to set the default scheduling scheme. Select Server Scheduling if you want task scheduling to be handled by the scheduler that is local to the database server, if the scheduler is enabled on that system. Select Centralized Scheduling if you want the storage and scheduling of tasks to be handled by a centralized system, in which case you need to select the centralized system from the Centralized Scheduler list. To enable another scheduler, select a system and click Create New to open a window in which you can Creating a database for the DB2 tools catalog on a cataloged system. If the system you want is not cataloged, you must catalog it first.

For more information, see Setting the default scheduling scheme.

Command Editor page

Use this page to specify how you will generate, edit, execute, and manipulate SQL and XQuery statements, IMS™ commands, and DB2 commands and work with the resulting output. These settings affect commands, SQL statements and XQuery statements on DB2 databases, z/OS and OS/390 systems and subsystems, and IMSysplexes.

For more information, see Setting Command Editor options.

IMS page

Use this page to set your preferences when working with IMS. You can set preferences for using wizards, syntax support, results, and the length of your command history.

For more information, see Setting IMS options.