DB2 ODBC Driver
If you're looking for the best performance and scalability for your IBM DB2 connected applications then this driver is the one for you. The Easysoft ODBC-DB2 Driver provides excellent ODBC performance to IBM DB2 databases from Linux and Unix platforms.
Written to create superior "out-of-the-box" connectivity to your database; eliminating the need for the installation of any additional software whilst maximising your all important data access capabilities.
As you would expect from Easysoft, installation is easy and our support team is on hand here to help you with any difficulties or questions.
ODBC Driver for DB2 8.x, 9.x, 10.x and 11.x
The Easysoft ODBC-DB2 Driver provides ODBC access to IBM DB2 from Linux and Unix platforms. The ODBC-DB2 Driver supports DB2 8.x, 9.x, 10.x and 11.x.
The Easysoft ODBC-DB2 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 Easysoft ODBC-DB2 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 ODBC-enabled language, interface or application to DB2.
The Easysoft ODBC-DB2 Driver is compatible with and includes unixODBC, the open source ODBC Driver Manager for non-Windows platforms. The Easysoft ODBC-DB2 Driver installation can automatically install the driver into unixODBC, making the ODBC-DB2 Driver immediately available to your ODBC applications.
To protect data as it is transmitted across the network, the Easysoft ODBC-DB2 Driver supports the DATA_ENCRYPT DB2 authentication mode and SSL encryption to secure the connection between the client machine and DB2 server.
The Easysoft ODBC-DB2 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 Easysoft ODBC-DB2 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.
- DB2 9.7 features:
- 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.
Platforms
The Easysoft ODBC-DB2 Driver is currently available on these platforms:
Note The Easysoft ODBC-DB2 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) |
HP Integrity Ready
The Easysoft ODBC-DB2 Driver for HP-UX and Linux Itanium was built and tested on HP Integrity Servers, which offer maximum hardware potential, reduced costs and unsurpassable performance.