IBM Data Server Driver for JDBC and SQLJ (for V11.5)
To Get the Library
Usually, it is stored in the sqllib/java directory under the directory where you installed DB2.
Installation
Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
Copy the required libraries under the $DATASPIDER.HOME/server/plugin/data_processing/modules/db2_115_adapter directory.
Start DataSpiderServer and DataSpider Studio.
DB2 V11.1 Adapter
Required library
db2jcc4.jar
Driver Version
IBM Data Server Driver for JDBC and SQLJ (for V11.1)
To Get the Library
Usually, it is stored in the sqllib/java directory under the directory where you installed DB2.
Installation
Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
Copy the required libraries under the $DATASPIDER.HOME/server/plugin/data_processing/modules/db2_111_adapter directory.
Start DataSpiderServer and DataSpider Studio.
DB2 V10.5 Adapter
Required library
db2jcc4.jar
Driver Version
IBM Data Server Driver for JDBC and SQLJ (for V10.5)
To Get the Library
Usually, it is stored in the sqllib/java directory under the directory where you installed DB2.
Installation
Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
Copy the required libraries under the $DATASPIDER.HOME/server/plugin/data_processing/modules/db2_105_adapter directory.
Start DataSpiderServer and DataSpider Studio.
DB2 V10.1 Adapter
Sales and support for DB2 V10.1 adapter has ended.
Required library
db2jcc.jar
Driver Version
IBM Data Server Driver for JDBC and SQLJ (for V10.1)
To Get the Library
Usually, it is stored in the sqllib/java directory under the directory where you installed DB2.
Installation
Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
Copy the required libraries under the $DATASPIDER.HOME/server/plugin/data_processing/modules/db2_101_adapter directory.
Start DataSpiderServer and DataSpider Studio.
DB2 V9.7 Adapter
Sales and support for DB2 V9.7 adapter has ended.
Required library
db2jcc.jar
Driver Version
IBM Data Server Driver for JDBC and SQLJ (for V9.7)
To Get the Library
Usually, it is stored in the sqllib/java directory under the directory where you installed DB2.
Installation
Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
Copy the required libraries under the $DATASPIDER.HOME/server/plugin/data_processing/modules/db2_97_adapter directory.
Start DataSpiderServer and DataSpider Studio.
DB2 for i 7.4/7.3/7.2/7.1 Adapter
Sales and support for DB2 for i 7.1 adapter has ended.
Required library
jt400.jar
To Get the Library
Usually it is stored in the /QIBM/ProdData/HTTP/Public/jt400/lib/DB2 UDB directory.
Installation
Stop DataSpiderServer and DataSpider Studio if DataSpiderServer and DataSpider Studio is operating.
Copy the required libraries under the $DATASPIDER_HOME/server/plugin/data_processing/modules/db2udb_iseries<version>_adapter directory. <version> indicates the version of DB2 for iSeries. It will be "71" for 7.1, "72" for 7.2, "73" for 7.3, and "74" for 7.4.
<version> indicates the version of DB2 for iSeries. It will be "71" for 7.1, "72" for 7.2, "73" for 7.3, and "74" for 7.4.