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:
Reading and writing datasets
Executing SQL recipes
Performing visual recipes in-database
Using live engine for charts
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 DSSRestart 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 usernamepassword
: 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.