IBM DB2
IBM DB2 is a relational database management system (RDBMS) built for transactional workloads and analytics. It supports SQL-based querying, high availability, scalability, and advanced features like compression and AI-powered optimization, making it suitable for both on-premises and cloud environments.
Prerequisites
The following prerequisites must be met to create and test a successful connection.
- The IBM DB2 server must be accessible from the iceDQ server.
- Valid credentials to access the database.
- IBM DB2 JDBC version 11.5 or above.
Authentication Mechanism
The following authentication mechanism is supported.
- Username & Password
Connection Properties
Use the following properties to create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | DB2_Prod_conn |
| Driver * | Driver used to establish the connection. By default, one driver is available. | DB2 Custom JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format supported by the driver: jdbc:db2://[host]:[port]/[database] | jdbc:db2://192.168.44.31:50000/Prod_db |
| Host * | IP address or hostname of the database server. | db2.acme.com or 192.168.44.31 |
| Port * | Port is the address on which the server listens. Default value is 50000 for Db2. | 50000 |
| Database * | Name of the target Db2 database. | Prod_db |
| Type * | The connection type – either System Connection or User Connection. Refer Connections for more details. | System or User |
| Username * | Database login username with necessary privileges. | db2admin |
| Password * | Password associated with the specified username. | Admin@123 |
Custom Properties
Custom properties are optional connection parameters in the DB2 driver, allowing customization of settings like timeouts and proxy configurations. A list of supported properties is available here. The availability and behavior of custom connection properties may vary depending on the version of the DB2 JDBC driver in use.
Unsupported Datatypes
The following datatypes are not supported.
- DATALINK
- BIT