Unlike on distributed platforms, there is only one system-wide DB2® database on an i5/OS® system or logical partition. DB2 UDB for iSeries® or DB2 for i5/OS (depending on which version
of the i5/OS operating system
you are using) is integrated with the i5/OS operating
system and is not a separate product that needs to be installed.
DB2 UDB for iSeries or DB2 for i5/OS is the relational database
that is fully integrated with the i5/OS operating
system, which makes it easy to use and manage.
The product also provides a variety of functions and features,
such as triggers, stored procedures, and dynamic bitmapped indexing,
that serve a wide variety of application types. These applications
range from traditional host-based applications to client/server solutions
to business intelligence applications.
The database hierarchy looks like this:
(Single Database) > Schema name > Table name
Two JDBC drivers are available to access the database:
- Native JDBC driver: Type 2, used when the database is local to
the WebSphere® Application Server-based
server. This driver is local to WebSphere ESB and
cannot be used to access a database on a remote i5/OS workstation.
- Toolbox JDBC driver: Type 4, typically used when the database
being accessed is remote from the workstation hosting WebSphere ESB. The
Toolbox driver can be used when the database is local to the server,
but the Native driver is recommended because it is optimized for local
database access.
The Toolbox JDBC driver files are found in a single, fixed location
on i5/OS. On an i5/OS workstation, the Toolbox for Java™ JDBC driver file, jt400.jar,
can be found at a fixed location in the file system:
/QIBM/ProdData/Http/Public/jt400/lib/jt400.jar
In a heterogeneous environment where
WebSphere ESB is
running on a distributed platform, but accessing its Common database
on an i5/OS workstation, the
JDBC driver of choice is the Toolbox for Java JDBC
driver. The driver file for the Toolbox JDBC driver is called
jt400.jar and
it needs to be available on the workstation that is hosting
WebSphere ESB. You
can obtain the driver from the distributed workstation in one of two
ways:
- Copy the driver from the i5/OS database
workstation to a directory on the distributed workstation.
- Download the driver from the jtopen Web site to a directory on
the distributed workstation. The jtopen Web site URL is at: http://sourceforge.net/projects/jt400