Understanding DB2®: Learning Visually with Examples
by Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
7.3. Partition Groups
A database partition group is a set of one or more database partitions. By grouping database partitions, you can perform database operations at the partition group level rather than individually on each partition. This allows for database administration flexibility. For example, let's say you want to create a buffer pool with the same definition in three partitions. If you first create a partition group pgall that consists of the three partitions, you can associate the buffer pool bp1 you are about to create with this partition group. This lets you use the same buffer pool definition on each partition.
Partition groups also allow you to associate table spaces to database partitions. For example, if you would like table space ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access