Connection properties of DB2 connector
You can configure connection to DB2 database by filling required properties. Depending on whether the database is already cataloged within the DB2 client or not, different properties must be set.
By default, DB2 connector requires that a database used during job execution, is added to the DB2 Client catalog. This must be completed on all DataStage Engine nodes from where the jobs are run. Such configuration is possible for all supported versions of DB2 database. For DB2 clients, versions equal or newer than 11.5, DB2 connector offers possibility to use database without creating entry in the catalog.
The configuration dialog contains dedicated section Connection with a default value of Connection definition set to DB2 client catalog entry. When this option is selected, the only required parameter is the database name as all connection details like hostname, port, and connection security settings are already configured within DB2 Client. Alternatively, you can set the Connection definition to Manual and then provide all required settings.
Connection definition: DB2 client catalog entry
- Database - Name must match the name from the catalog.
- Instance - If not defined, default value is taken from the environment.
- Username and Password - If not defined, process user is used. Make sure that the user has access to the database.
Connection definition: Manual
- Database - Name of the database
- Hostname - Fully qualified domain name or IP address of DB2 database server
- Port - Port number on which DB2 server listens for connector to given database.
When secure connection is required, you must set SSL Connection property to Yes. If there is a need to provide server security certificate, use the SSL certificate multi-line configuration property to store encoded server certificate in ARM text format.
- Username and Password - If not defined, process user is used. Make sure that the user has access to the database.
- API Key - API key string to be used for authentication.
- Instance - If not defined, default value is considered from the environment.
- Options - Additional CLI/ODBC connection options in a
key=value
format. Each pair must be separated by semicolon character. For more information on possible values, see CLI/ODBC configuration keywords listing by category in DB2 documentation.
Limitations:
When manual connection definition is used, DB2 Connector is not able to established direct connections to database partitions, so value of Use direct connections configuration property is always treated as No.