Setting preferences for DB2 database connections

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:

  1. In the Preferences window: Click Windows > Preferences and expand the Data Management node.
  2. Click DB2 Options.
  3. 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.
  4. Click OK.
  5. Close and reopen the workbench.
The pre-populated DB2 alias connections in the Data Source Explorer are created using the options that you specified.

Feedback