Database administration commands and the Database Partitioning Feature (DPF)

The DB2® Database Partitioning Feature (DPF) allows the partitioning of a database into two or more partitions that can reside on either the same server or on a different server.

When you invoke and run database administration commands on a partitioned database, the task assistants that guide you through the process of setting up the options for the commands include the ability to specify whether to run the commands against all of the partitions, one or more specific partitions, or partitions groups. You can also choose to run the commands against the partitions in parallel, which is particularly useful for long running commands. If you save the commands to a script, the commands will be run sequentially.

Having more control of running commands on individual partitions gives you more flexibility in managing your databases and resources. The granularity of an operation can determine how long it will take. For example, when there are hundreds of partitions, backing up sets of partitions at different times or on different days might make more sense than backing up all of the partitions at the same time. Or, as another example, depending on the system resources that are available to each partition, you might want to set certain configuration parameters across non-catalog partitions while you customize the parameters for the catalog partition to optimize performance.

Restriction: In a DPF environment, these limitations apply:

Feedback