DB2 10.5 for Linux, UNIX, and Windows

Designing tables

When designing tables, you must be familiar with certain concepts, determine the space requirements for tables and user data, and determine whether you will take advantage of certain features, such as compression and optimistic locking.

When designing partitioned tables, you must be familiar with the partitioning concepts, such as:

Data organization schemes
table-partitioning keys
Keys used for distributing data across data partitions
Keys used for MDC dimensions

For these and other partitioning concepts, see Table partitioning and data organization schemes.