8.3. Database Partition Groups

In a multi-partition environment, a database partition is an independent subset of a database that contains its own data, indexes, configuration files, and transaction logs. A partition group is a logical grouping of one or more database partitions that lets you control the placement of table spaces and buffer pools within the database partitions.

8.3.1. Database Partition Group Classifications

Partition groups are classified based on the number of database partitions they contain.

  • Single-partition partition groups contain only one database partition.

  • Multi-partition partition groups contain more than one database partition.

Figure 8.8 shows four database partition groups.

  • pgall is a multi-partition partition group ...

Get Understanding DB2®: Learning Visually with Examples 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.