IBM Db2 for i connection

To access your data in IBM Db2 for i, create a connection asset for it.

Db2 for i is the relational database manager that is fully integrated on your system. Because it is integrated on the system, Db2 for i is easy to use and manage.

Supported versions

IBM Db2 for i 7.4+ and 7.5+.

Prerequisites

Upload JAR files for JCC drivers

This connection has the option to upload JCC drivers, which is the default driver option. Upload two JAR files:

  • The Db2 JDBC driver file: db2jcc4.jar
  • One of the following license files matching the Db2 JBDC driver version based on your version of Db2:
    • If the Db2 JDBC driver comes from Db2 11.5 or lower: db2jcc_license_cisuz.jar
    • if the Db2 JDBC driver comes from Db2 12.1 or higher: db2jcc_license_consvIS.jar

For information, see Db2 Connect licensing information, Installing the IBM Data Server Driver for JDBC and SQLJ, and the note about license file differences between major Db2 versions in Db2 Connect editions.

See Importing JDBC drivers in the IBM Software Hub documentation for the procedure and required permissions to upload the JAR file to Cloud Pak for Data. Important: By default, uploading JDBC driver files is disabled and users cannot view the list of JDBC drivers in the web client. An administrator must enable users to upload or view JDBC drivers in the IBM Software Hub documentation.

Create a connection to Db2 for i

To create the connection asset, you need these connection details:

  • Driver: For more information, see Prerequisites.
  • Hostname or IP address
  • Port number
  • Location: The unique name of the Db2 location you want to access
  • Username and password
  • SSL certificate (if required by the database server)

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Federal Information Processing Standards (FIPS) compliance

This connection is FIPS-compliant and can be used on a FIPS-enabled cluster.

Restriction

For SPSS Modeler, you can use this connection only to import data. You cannot export data to this connection or to a Db2 for i connection connected data asset.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the Db2 for i SQL reference for the correct syntax.

Learn more