Official Introduction to DB2® for z/OS®, The, 2nd Edition

DB2 data structures

The elements that DB2 manages can be divided into two broad categories:

• Data structures, which are accessed under the user's direction and used to organize user data (and some system data).

• System structures, which are controlled and accessed by DB2. “DB2 system structures” on page 62 describes the DB2 system structures.

This section describes the following DB2 data structures, beginning with the smaller data structures and progressing to larger data structures:

• “Tables”

• “Indexes” on page 48

• “Keys” on page 49

• “Views” on page 50

• “Table spaces” on page 53

• “Index spaces” on page 54

• “Databases” on page 54

Tables

Tables are logical structures that DB2 maintains. As you already learned, tables are made up of columns and rows. The rows ...