Hi All,
We are able to connect to the database and run the reports but after schedule it always shows in the “pending” state and shows an error “java.lang.unsatisfiedlinkerror db2jcct2 native library could not be loaded”.
Any idea about this issue earlier.
The IBM® Data Server Driver for JDBC and SQLJ supports two types of connectivity: type 2 connectivity and type 4 connectivity.
Type 2 connectivity requires a DB2 client (or server) installation and has a restriction in that the “bitness” of the java application must match with the DB2 client ( or server) instance.
So a 32bit java application using type 2 connectivity can only work with a 32bit DB2 client (or server) instance and a 64bit java application using type 2 connectivity can only work with a 64bit DB2 client (or server) instance for connectivity to a remote (or local) database. The bitnes of the remote database instance does not matter, only that of which is configured in the client application environment.
Example, if install the IBM Data Server Driver for JDBC and SQLJ on a Windows 64-bit operating system then one cannot use IBM Data Server Driver for JDBC and SQLJ type 2 connectivity to connect to a DB2 Database for Linux, UNIX, and Windows instance from a 32-bit Java application.
If the above requirement has been met and yet continue failing at loading the native db2 library then check that library path is being set correctly.
The JVM used for the application environment must load the correct library, depending on its bit type (32-bit or 64-bit). A 32-bit JVM can only load the 32-bit DB2 native libraries and a 64-bit JVM can only load the 64-bit DB2 native libraries.
Windows:
Ensure LIB environment variable references the correct library path for the JVM.
db2jcct2.dll is located in %DB2HOME%\bin
Associated libraries (*.lib) are located in:
(32-bit) %DB2HOME%\lib\Win32.
(64-bit) %DB2HOME%\lib