DB2 Architecture on OS/400

On OS/400® machines, the DB2 Universal Database™ is integrated to the operating system. Therefore, some concepts change. For example, the physical organization of the database is quite different from UNIX™ or Windows™ platforms.

Table 1. Common terms for the physical organization of the database with DB2® OS/400
SQL Terms DB2 OS/400 Terms
Table Physical file
Row Record
Column Field
Index Keyed logical file, access path
View Non keyed logical file
Schema Library, Collection, Schema (OS/400 V5R1 only)
Log Journal
Isolation Level Commitment control level

A Collection is a library containing a Journal, Journal Receivers, Views on the database catalogs.