DB2 connection configuration
Overview
When you connect to DB2 directly, select Local DB as the location, select DB2 as the data type, and configure the detailed settings.
Configuration
Basic
| No | Item | Description |
|---|---|---|
| 1 | User ID | Use ID for the DB2 account. |
| 2 | Password | Password for the DB2 account. |
| 3 | Connection Type | Select Basic |
| 4 | DB2 Host | |
| 5 | DB2 Port | |
| 6 | Database | |
| 7 | Default Schema | If Default Schema is specified, the tables and views of the specified schema will be listed during mapping. If blank, all accessible tables and views will be listed. |
| 8 | Enable Transactions | Specify whether to enable transaction control. When ON, transactions are enabled for each connection, and operations are executed within the same transaction. When OFF, each operation is committed automatically (autocommit). |
DB2 Connection String
SDI uses IBM.Data.DB.Provider to connect to DB2.
You can connect to DB2 by using DB2 Connection String directly.
| No | Item | Description |
|---|---|---|
| 1 | Connetion Type | Select DB2 Connection String |
| 2 | DB2 Connection String | Enter the details of the DB2 Connection String. * Do not enter user and password information in the Connection String. Reference：DB2Connection.ConnectionString property |