JDBC and ODBC drivers
Db2 Big SQL uses a JDBC driver that conforms to the JDBC 3.0 and JDBC 4 specifications to provide connectivity to Java™ applications. Db2 Big SQL uses a 32-bit or a 64-bit ODBC driver, on either Linux® or Windows, that conforms to the Microsoft Open Database Connectivity 3.0.0 specification, to provide connectivity to C and C++ applications
Downloading ODBC and JDBC drivers
When you add the Db2 Big SQL service in Hortonworks Data Platform, the JDBC driver is automatically installed in the ../database/db2/java directory, which you can use directly or copy it to a location that is accessible from the client application that wants to use the driver.
- Download the correct IBM® Data Server Driver Package for your operating system. Db2 Big SQL requires the Version 11.1 package.
- Navigate to the file you downloaded. Right-click the vxx.xxxx_ntxxx_dsdriver_xx.exe file and select to Run as administrator to install the package. This package is installed by default in C:\Program Files\IBM\IBM DATA SERVER DRIVER\.
JDBC and ODBC connectivity
Db2 Big SQL uses the IBM Data Server Client driver package. This package uses the same standards-compliant JDBC, JCC, ODBC, CLI and .NET drivers that are used in other IBM software products, such as DB2® for Linux, UNIX and Windows, DB2 for z/OS®, and IBM Informix® database software.
| Connection artifacts | Db2 Big SQL |
|---|---|
| Driver location | $BIGSQL_DIST_HOME/db2/java |
| Driver JAR file | db2jcc.jar |
| Driver class | com.ibm.db2.jcc.DB2Driver |
| JDBC URL | jdbc:db2://hostname:port/BIGSQL[;currentSchema=schema] |
| Default port | 32051 |
| Connection artifacts | Db2 Big SQL |
|---|---|
| Driver download | DSClients-xxxxx-dsdriver-10.5.xxx.xxx-xxxxx |
| DSN configuration | db2dsdriver.cfg |
Default schema
In Db2 Big SQL, the default schema is the user name that was used to establish the connection.