Best practice for partitioning data
DB2® Multisystem enables the partitioning of data using partitioned tables and distributed files.
There are two methods for partitioning data:
- Partitioned tables - The data for a table is spread across multiple members within a single physical file on a single IBM i instance. This is the recommended method for physical partitioning of data in a table.
- Distributed files (distributed tables) - The data for a table is spread across multiple IBM i instances. This option is no longer recommended for use.
For more information on physical partitioning of data in a table, see Partitioned tables.