When connecting to a DB2 V7.2 database, you
can use these JDBC providers:
- DB2 legacy CLI-based type 2 JDBC driver
- DB2 legacy CLI-based type 2 JDBC driver (XA)
These templates are functionally equivalent to the
DB2 JDBC
provider and
DB2 JDBC provider (XA) templates that were
available in WebSphere Application Server V5.0.0. Although the DB2 JDBC
provider templates can still be used in V5.0.1 or higher, they are
deprecated and it is recommended that the
DB2 legacy CLI-based type 2
JDBC driver templates be used instead.
When connecting to a DB2 8.1 database, you can use these JDBC Providers:
- DB2 legacy CLI-based type 2 JDBC driver
- DB2 legacy CLI-based type 2 JDBC driver (XA)
- DB2 Universal JDBC Driver Provider
- DB2 Universal JDBC Driver Provider (XA)
Use the DB2 legacy CLI-based type 2 JDBC driver templates to connect to
DB2 with the type-2 JDBC app driver. This is the same driver that is used
to connect to DB2 7.2 databases. In addition, you can use the
DB2
Universal JDBC Driver Provider templates to use the new DB2 Universal
JDBC Driver to connect to DB2 8.1 databases. Data sources using these JDBC
provider templates have a custom property called driverType that must be
set to
2 or
4 for type-2 Universal Driver or type-4
Universal Driver respectively. The type-2 Universal Driver supports XA;
the type-4 Universal Driver does not support XA unless DB2 8.1 Fix Pack 7
(or higher) or DB2 8.2 is installed.
When connecting to a DB2/390 database, you can use these JDBC Providers:
- DB2/390 JDBC Provider
- DB2/390 JDBC Provider (XA)
Use these templates to connect to DB2 6.1 or 7.1 databases on OS/390
(zSeries). This configures WebSphere to use the type-2 JDBC app driver to
connect to DB2/390.
When connecting to a DB2 database on iSeries, you can use these JDBC
Providers:
- DB2 UDB for iSeries (Native - V5R2 and later)
- DB2 UDB for iSeries (Native XA - V5R2 and later)
- DB2 UDB for iSeries (Native - V5R1 and earlier)
- DB2 UDB for iSeries (Native XA - V5R1 and earlier)
- DB2 UDB for iSeries (Toolbox)
- DB2 UDB for iSeries (Toolbox XA)
These templates can be used as expected. The
DB2 UDB for iSeries
(Toolbox) templates can be used to connect to any release of DB2 on
iSeries; the appropriate template must be selected for the release of DB2
on iSeries in use if one of the native templates is selected. Note that he
Toolbox JDBC Driver is a type-4 driver, while the Native JDBC Driver is a
type-2 driver.