IBM Db2 DBMS Notes CompareData

IBM Db2 ODBC Drivers

IBM DB2 ODBC DRIVER - DB2COPY1 11.05.5000.1587 fail
IBM DB2 ODBC DRIVER - IBMDBCL1 11.05.8000.317 pass
SQL Error. Native Code: 0, SQLState: IM004, Return Code: -1
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

CompareData can no longer connect to Db2 using IBM Data Server Driver for ODBC after application code page update to UTF-8. Db2 for Windows and IBM Data Server Driver for ODBC do not currently support Windows UTF-8 code page.

The most recent version of CompareData that uses Windows locale code page (Active Code Page) that works with IBM Data Server Driver for ODBC is version 2.6.0.

You can also evaluate using third-party ODBC drivers for Db2.