# IBM DB2[¶](https://doc.dataiku.com/dss/latest/connecting/sql/db2.html#ibm-db2 "Permalink to this headline")

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:

* Reading and writing datasets

* Executing SQL recipes

* Performing visual recipes in-database

* Using live engine for charts

## Installing the JDBC driver[¶](https://doc.dataiku.com/dss/latest/connecting/sql/db2.html#installing-the-jdbc-driver "Permalink to this headline")

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[¶](https://doc.dataiku.com/dss/latest/connecting/sql/db2.html#creating-a-db2-connection "Permalink to this headline")

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[¶](https://doc.dataiku.com/dss/latest/connecting/sql/db2.html#creating-db2-datasets "Permalink to this headline")

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