|
Title: Accessing DB2 for i5/OS data from AIX Applications - Optimize AIX access to your DB2 for i5/OS database
Abstract: AIX 5L is quickly becoming the preferred commercial implementation of UNIX operating system. The recently announced IBM eServer i5 servers can run AIX 5L in as many as 160 separate logical partitions (LPARs). This gives iSeries customers a very rich portfolio of business applications that are currently available on AIX. Traditionally, many organizations use the iSeries server as a reliable and highly scalable database server. The iSeries database, DB2 for i5/OS, is fully integrated in i5/OS and OS/400, and exploits its robust features, such as single-level storage, tight security, and object-based architecture. For these reasons, IBM believes that DB2 for i5/OS will remain the database of choice for most iSeries shops.
Generally, AIX applications can use several programming environments to access the iSeries database: JDBC, ODBC, DB2, CLI, and embedded SQL. However, depending on the protocol and specific driver implementation, an AIX application can directly communicate with a back-end database server job on an iSeries server or it may require DB2 Connect Gateway services. Currently, only IBM Toolbox for Java JDBC driver supports a direct, native connection to iSeries servers. All other interfaces require DB2 Connect. This paper provides connectivity options, implementation tips, and a number of coding examples that illustrate how to optimize the access to a DB2 for i5/OS database from an AIX partition for each of these programming interfaces.
|
