You can set preferences in the Preferences window for DB2® database connections.
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.
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) in the Data Source Explorer 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 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.
The pre-populated DB2 alias connections in the Data Source Explorer are
created using the options that you specified.