i5/OS and OS/400 (5722-SS1): Architecture 525
Draft Document for Review October 18, 2004 5486OpS.fm
X/Open's Call Level Interface (CLI) supported transmission protocols for the
iSeries include:
TCP/IP
Advanced Program-to-Program Communication (APPC)
Advanced Peer-to-Peer Networking® (APPN)
X/Open Call Level Interface to SQL
The integrated database is a full-function database with features competitive to
other widely used databases, reducing the need for a dedicated Database
Administrator. The fact that the database is integrated allows the operating
system to control some of its management functions and makes it easier to
maintain than a competitive database. With security built-into i5/OS and OS/400,
DB2 UDB allows a better security model than other database where additional
tools are purchased to provide the security functions.
The SQL Client Integration API allows providers of gateways and client/server
solutions to integrate their products with DB2 UDB for iSeries. Many iSeries
customers need applications that both access DB2 UDB for iSeries data, and
access data on other databases platforms such as Oracle or Sybase.
Distributed database support
i5/OS and OS/400 support distributed relational databases using SQL.
Distributed database support allows read and write access from an iSeries
server to another iSeries server or to any other database supporting the Open
Group DRDA architecture, including DB2 UDB for OS/390® and z/OS®, DB2
UDB for Windows, and DB2 UDB for AIX.
DB2 Relational Connect, a feature of DB2 UDB for Windows and UNIX servers,
allows access to additional databases such as Oracle, Microsoft SQL Server,
and others. An iSeries server can connect to a system running DB2 Relational
Connect to access data in the databases accessible by DB2 Relational Connect.
The CPI for database is SQL. The customer’s investment in data is protected by
distributed support with data connectivity across platforms. Interactive access to
distributed database is possible using the prompted facilities of interactive SQL
(ISQL). This is available in DB2 Query Manager and SQL Development Kit for
iSeries (5722-ST1), which is a separately licensed program.
High performance database server (centralized and distributed
server)
The high performance iSeries server and improvements in communication
performance combine to strengthen the position of the iSeries server as a high
performance database server. In addition, DB2 UDB for iSeries offers enhanced
To Next Page
Loading...
Need help?
General