WebSphere Enterprise Service Bus, Version 6.2.0 Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows


i5/OS database and collections

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:

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:

concept Concept topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.doc/doc/cins_db_i5.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).