Tools Settings -- Fields and controls

General page

" " Automatically display hover help
" " Automatically display infopops
" " Automatically start local DB2 on tools startup
" " Add tools tracing to DB2 Trace
" " Use statement termination character

" " Automatically display hover help

Select this check box to specify that hover help in the administration tools should be displayed automatically when you hold the mouse cursor over a toolbar icon. The default is for the hover help to display automatically.

Hover help is provided for the graphical icons, such as the Control Center toolbar icons, in the administration tools.

" " Automatically display infopops

Select this check box to specify that infopops that are in Control Center SmartGuides and in certain Control Center windows and notebooks should be displayed automatically when you hold the mouse cursor over a field or control. The default is for the infopops not to display automatically.

You can display the infopop for a particular field or control by selecting that field or control and pressing F1, regardless of whether this check box is selected.

Infopops are provided for the fields and controls in the Control Center SmartGuides and in Control Center windows and notebooks that involve actions on DB2 UDB for OS/390 objects.

" " Automatically start local DB2 on tools startup

Select this check box to specify that the local DB2 instance be started automatically when any of the DB2 administration tools are started.

" " Add tools tracing to DB2 Trace

Select this check box to include Control Center information in the DB2 Trace log.

" " Use statement termination character

Select this check box to specify that a character will be used to terminate statements in command scripts. Command scripts are used in the Command Center and Script Center.

If you select this check box, the default character that will be used is the semicolon (;). If you want to specify a different character, type a single character in the entry field.

If you select this check box, you cannot use the backslash (\) character to continue statements in command scripts.



Alert Center page

" " Specify when to surface the window

" " Specify when to surface the window

Select one radio button to set the default for when the Alert Center window will surface:

Never
The Alert Center window will never automatically surface. If this radio button is selected, you must explicitly open the Alert Center window from the toolbar or product folder to see monitored objects in alarm or warning states.

On new warnings and alarms
The Alert Center window will surface every time there is a new warning or alarm. If the window is minimized, it will open. If the window is open, but covered by other windows, it will surface and cover the other windows. This option is the default.

On new alarms only
The Alert Center window will surface only when there is a new alarm.



Node Status page

" " Enable node status reporting
" " Node status refresh interval
" " Actions to take when instance node is down or unknown

" " Enable node status reporting

Select this check box if you want to be notified when the status of one or more nodes changes.

" " Node status refresh interval

To indicate the length of time between report updates, click on the arrow keys to select a refresh interval between 10 seconds and 1 hour.

" " Actions to take when instance node is down or unknown

To indicate what action to take when the status of an instance node is down or unknown, select one or more of the following check boxes:

Beep
The system beeps.

Message
A message appears on your screen.

Run command
Type a command in the field. The specified command is executed.

Four parameters are passed to the specified command: node number, host name, port number and switch name. For more information, See the Command Reference.



Replication page

" " Drop table space when empty
" " Source table column attributes
" " Target table attributes
" " Substitute user-defined values to define replication objects
" " File name

" " Drop table space when empty

Select this check box to have the table space for target tables and change data tables be dropped when the table space is empty.

By default, empty table spaces for target and change data tables are dropped. If this check box is not selected, you are responsible for dropping the table spaces.

For more information on target tables and change data tables, see the Replication Guide and Reference.

" " Source table column attributes

Select one radio button to specify what images of source table columns are automatically captured when you define a replication source:

Capture before and after image
Both the before image and after image of the source table columns are captured.

Capture after image only
Only the after image of the source table columns is captured.

This selection becomes the default for when you define a quick or custom replication source. If you define a custom replication source, you can change this default for individual columns.

" " Target table attributes

Select one or more of these check boxes to set replication attributes for target tables:

Create target tables
Target tables are created automatically every time you define a replication subscription.

If this check box is selected, the Create Table option in the Define Subscription window will be set. If this check box is not selected, you must check the Create Table check box in the Define Subscription window.

Drop target tables if subscription is removed
Target tables are dropped if you remove the associated subscription.

If this check box is not selected, you are responsible for dropping the target tables.

" " Substitute user-defined values to define replication objects

Select this check box to specify the use of the defaults file. You can use this file to substitute table and index names generated during the definition of a replication source, join, or subscription. When you run your SQL, the Control Center examines the file you specify and accepts your modifications.

" " File name

Type the name of the file you want to use for the defaults file. This name:

This is field is available only if you select the Substitute user-defined values to define replication objects check box. You can either use DPREPL.DFT or another name.