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
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
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 V9.5 Adapter
Sales and inquiry support for DB2 V9.5 adapter has ended.
Required library
db2jcc.jar
Driver Version
IBM Data Server Driver for JDBC and SQLJ (for V9.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_95_<OS>_adapter directory.
<OS> indicates the DB2 adapter for each OS. It will be "aix" for AIX, "win" for WIndows, and "solaris" for Solaris.
Start DataSpiderServer and DataSpider Studio.
DB2 V9.1 Adapter
Sales and inquiry support for DB2 V9.1 adapter has ended.
Required library
db2jcc.jar
db2jcc_license_cu.jar
Driver Version
IBM DB2 JDBC Universal Driver Architecture (for V9.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_91_<OS>_adapter directory.
<OS> indicates the DB2 adapter for each OS. It will be "aix" for AIX, "win" for WIndows, and "solaris" for Solaris.
Start DataSpiderServer and DataSpider Studio.
DB2 for i 7.2/7.1 Adapter / DB2 UDB for iSeries 6.1 Adapter
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 "61" for iSeries 6.1, "71" for i 7.1, and "72" for i 7.2.