IBM DB2

Warning

Tier 2 support : Connection to IBM DB2 is covered by Tier 2 support

Note

You might want to start with our detailed tutorial for your first steps with SQL databases in DSS .

You might want to start with that tutorial. The rest of this page is reference information for DB2.

DSS supports the full range of features on DB2:

Installing the JDBC driver

The DB2 JDBC driver is available in your DB2 installation and can be provided by your DB2 administrator.

The driver is made of a single JAR file db2jcc4.jar

To install:

  • Copy this JAR file to the lib/jdbc driver of DSS

  • Restart DSS

Creating a DB2 connection

As a beta-support database, there is not a dedicated “DB2” connection in DSS.

Instead, create a “Other databases (JDBC)” connection, and enter the following information:

  • JDBC Driver class: com.ibm.db2.jcc.DB2Driver

  • JDBC URL: jdbc:db2://yourHost:yourPort/yourDatabase

  • JDBC properties:
    • user : your username

    • password : your password

  • SQL dialect: IBM DB2

Creating DB2 datasets

To create a DB2 dataset, you need to create a “Other SQL databases” dataset. You can also Import your tables.