DB2 for i Server

DB2 for i is the relational database manager that is fully integrated and provides numerous 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.

In the IBM i system, each file (also called a file object) has a description that describes the file characteristics and how the data associated with the file is organized into records and the fields in the records. The operating system uses this description whenever a file is processed.

DB2 for i installations store all tables in their respective data sources in a single database.

This diagram illustrates the DB2 for i structure with EnterpriseOne: