Configuration Assistant overview - IBM DB2 9.7 for Linux, UNIX, and Windows

Use the Configuration Assistant to configure and maintain the database objects that you or your applications will be using. Each database that will be accessed must be configured at your DB2® client before you can work with it.

Important: The Configuration Assistant has been deprecated in Version 9.7 and might be removed in a future release. Start using IBM® Data Studio and IBM Optim™ tools. For a mapping between these recommended tools and Control Center tools, see Table of recommended tools versus Control Center tools.

You must configure your DB2 clients so they can work with the available objects. From the Configuration Assistant, you can work with existing database objects, add new ones, bind applications, set database manager configuration parameters, and import and export configuration information. The Configuration Assistant's graphical interface makes these complex tasks easier through:

Wizards that help you perform certain tasks.
Dynamic fields that are activated based on your input choices.
Hints that help you make configuration decisions.
Discovery that can retrieve information that is known about selected database objects.

The Configuration Assistant displays a list of the databases to which your applications can connect and access data. Each database is identified by its database alias. You can use the Add Database Wizard to add databases to the list. You can use the Change Database Wizard to alter the information associated with databases in the list.

The Configuration Assistant also has an Advanced view which uses a notebook to organize connection information by object: Systems, Instance Nodes, Databases, Database Connection Services (DCS), and Data Sources. You can use the notebook pages to perform object specific actions.

To open the Configuration Assistant:

Enter the
```
db2ca
```
command.
On Windows operating systems, click Start → Programs → IBM DB2 → Set-up Tools → Configuration Assistant.
On Linux operating systems, click Main Menu and, select IBM DB2 → Configuration Assistant.

Tasks from the Configuration Assistant

Databases
- Adding a database using a wizard
- Changing a database using a wizard
- Removing a database
- Binding files and utilities to a database
- Testing database connections
- Changing a password
Data sources
- Configuring CLI settings
Instance configurations
- Setting database manager configuration parameters
- Setting DB2 registry variables
- Configuring another instance
- Resetting configuration
Profiles
- Exporting a configuration profile
- Importing a configuration profile
- Editing a profile offline

Tasks from the Configuration Assistant - Advanced view

Systems
- Adding a system
- Changing a system
- Removing a system
Instance nodes
- Adding an instance node
- Changing an instance node
- Removing an instance node
Instance configurations
- Setting database manager configuration parameters
- Setting DB2 registry variables
- Configuring another instance
- Resetting configuration
Databases
- Adding a database
- Changing a database
- Removing a database
- Binding files and utilities to a database
- Testing database connections
- Changing a password
DCS (host databases)
- Adding a DCS (host database)
- Changing a DCS (host database)
- Removing a DCS (host database)
Data sources
- Adding a data source
- Changing a data source
- Removing a data source
- Configuring CLI settings
Profiles
- Exporting a configuration profile
- Importing a configuration profile
- Editing a profile offline

Configuration Assistant interface:

The Configuration Assistant has the following elements:

Menu bar

Use the menu bar to work with objects in the Configuration Assistant.

Choose Configure to work with instance and profile configurations.
Choose an object and Selected to work with that object.
Choose Edit to edit a profile offline.
Choose View to change to the Advanced view.
Choose Help to get task help.

Contents pane toolbar

"graphic of the configuration assistant tool bar"

Use the toolbar to tailor the view of objects and information to suit your needs. These toolbar functions can also be selected in the Edit menu and the View menu.

How to use the help:

Use the help to find task information:

To find a topic when you are not sure where to start

Select a topic from the table of contents in the left pane of the help window. To find the place in the table of contents that represents the current topic, you can click on a heading in the right pane.
Look up a keyword in the online index, by clicking the Index link in the table of contents.

To get help for the current window

Click the Help push button or press F1.
V8 windows and notebooks have control-specific help known as infopops. You can display the help for a field or control by selecting it and pressing F1. If your system can automatically display infopops, you can also see the infopop by holding the mouse cursor over the field or control.