Partition databases

In the case of huge data (millions of records), consider partitioning databases and objects.

The DB2® database manager allows great flexibility in spreading data across multiple database partitions of a partitioned database. You can choose how to distribute your data by declaring distribution keys. To determine which and how many database partitions your table data is spread across, you can select the database partition groups and table spaces where you want to store the data.