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 are logical structures that DB2 maintains. As you already learned, tables are made up of columns and rows. The rows ...

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.