DB2 ODBC driver

ODBC driver for DB2 8–11

The Easysoft DB2 ODBC driver provides ODBC access to IBM DB2 from Linux and UNIX platforms. The DB2 ODBC Driver supports DB2 8.x, 9.x, 10.x, and 11.x.

The DB2 ODBC driver is a small footprint, wire protocol driver that does not require DB2 client software to connect to DB2.

Connect to DB2 from Linux and UNIX

The DB2 ODBC driver connects 32-bit and 64-bit applications on Linux and UNIX platforms to DB2 databases. Download the DB2 ODBC driver to connect Perl, PHP, Python, Ruby, C, and any other language, interface, or application that supports ODBC to DB2.

The DB2 ODBC driver is compatible with and includes unixODBC, the open-source ODBC Driver Manager for non-Windows platforms. The DB2 ODBC driver installation can automatically install the driver into unixODBC, making the DB2 ODBC driver immediately available to your ODBC applications.

To protect data as it is transmitted across the network, the DB2 ODBC driver supports the DATA_ENCRYPT DB2 authentication mode and SSL encryption to secure the connection between the client machine and DB2 server.

The DB2 ODBC driver supports Kerberos authentication, which extends the benefits of centralised authentication to DB2 users. Centralised authentication makes it unnecessary for users to remember multiple passwords and for security administrators to protect multiple password repositories.

Additional DB2 ODBC driver functionality includes support for:

  • DB2 data types:
    • Numbers (SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, DECFLOAT).
    • Character strings (CHAR, VARCHAR, CLOB).
    • Graphic strings (GRAPHIC, VARGRAPHIC, DBCLOB).
    • Binary strings (BLOB).
    • Datetime values (DATE, TIME, TIMESTAMP).
    • XML values (XML).
  • Data type conversion.
  • Stored procedures.
  • Multi-row SQL operations, for example, you can insert multiple rows by using a single SQL statement.
  • Scalar (both DB2 and ODBC) and catalog functions.
  • Arrays of parameters, which reduce network round-trips and increase performance.
  • Advanced Encryption Standard (AES) encryption of the user ID and password submitted to DB2, which enhances security.
  • Currently Committed Transaction Isolation, which significantly reduces lock wait and deadlock scenarios.
  • Statement concentrator, which enables SQL statements that are identical except for the values of literals to share the same access plan. The statement concentrator avoids compilation overhead by enabling a compiled statement to be reused.
  • Inline LOBs, which improve the performance of queries that access LOB data, because no additional I/O is required to fetch, insert, or update this data.
  • Oracle-compatible data type support (NUMBER, NVARCHAR2, and VARCHAR2; DATE as TIMESTAMP(0))
  • New and enhanced SQL syntax and functions.

Diagram

Platforms

The DB2 ODBC driver is currently available on these platforms:

Note The DB2 ODBC driver does not support DB2 for zSeries or DB2 for iSeries.

Version Platform Distribution
v1.0 (DB2 8.0 - 11.5) AIX (PPC) (32 - Bit) (4.3-6.1)
v1.0 (DB2 8.0 - 11.5) AIX (PPC) (64 - Bit) (5.0-7.2)
v1.0 (DB2 8.0 - 11.5) HP-UX (Itanium i64) (32 - Bit) (11i)
v1.0 (DB2 8.0 - 11.5) HP-UX (Itanium i64) (64 - Bit) (11i)
v1.0 (DB2 8.0 - 11.5) Linux (ARMv71) (32 - Bit) (Raspberry Pi, kernel 4.9.41-v7+, glibc 2.24+)
v1.0 (DB2 8.0 - 11.5) Linux (Itanium i64) (64 - Bit) (kernel 2.4-3.0+, glibc 2.2.5)
v1.0 (DB2 8.0 - 11.5) Linux (x86) (32 - Bit) (kernel 2.2-3.0+, glibc 2.1+)
v1.0 (DB2 8.0 - 11.5) Linux (x86) (64 - Bit) (kernel 2.6-4.0+, glibc 2.3.5+)
v1.0 (DB2 8.0 - 11.5) Solaris (Sparc) (32 - Bit) (2.6-2.10)
v1.0 (DB2 8.0 - 11.5) Solaris (Sparc) (64 - Bit) (2.8-2.11)
v1.0 (DB2 8.0 - 11.5) Solaris (x86) (32 - Bit) (2.8)
v1.0 (DB2 8.0 - 11.5) Solaris (x86) (64 - Bit) (2.8-2.11)
v1.0 (DB2 8.0 - 11.5) Windows (x86) (32 - Bit, 64 - Bit) (7, 8, 2012 R2, 10, 2016, 2019,11,2022)