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:
  1. 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.
  2. 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.