You can set preferences in the Preferences window for DB2® database connections.
About this task
You can set global preferences to control the default
behavior for the pre-populated DB2 alias
connections that appear automatically in the Data Source Explorer (or
the Administration Explorer for products that include this view).
Procedure
To set preferences for DB2 database
connections:
- In the Preferences window: Click and expand the Data
Management node.
- Click DB2 Options.
- Specify DB2 connection
options, as described.
- Load DB2 alias connections
on startup
- Specifies that DB2 databases
with aliases that are bound to the locally installed DB2 client are discovered and displayed (disconnected)
when the workbench is started. Using this option, you can more easily
find and reconnect to aliased databases. If you do not select this
option, you can still connect explicitly to databases.
- Restore deleted DB2 aliases
on startup
- Specifies that DB2 aliases
that were deleted by the user are recreated when the workbench is
started. DB2 aliases can be
deleted from the Data Source Explorer (or
the Administration Explorer for products that include this view) to
simplify the view. If you have deleted aliases to simplify the view
and you do not want to work with them again, you should clear this
check box.
- DB2 alias connection type
- Specify which type of connection is created at startup. This is
the only way to edit the connection type on an automatic alias connection.
For more information about Type 2 and Type 4 connections, refer to
the DB2 server documentation.
- Load connection aliases with a Type 2 connection on startup
- Specifies that connections to databases with aliases that are
bound to the locally installed DB2 client
are created using a Type 2 connection type.
- Load connection aliases with a Type 4 connection on startup
- Specifies that connections to databases with aliases that are
bound to the locally installed DB2 client
are created using a Type 4 connection type.
- Click OK.
- Close and reopen the workbench.
Results
The pre-populated DB2 alias
connections are created using the options that you specified.