Table spaces in a multipartitioned environment

When you create a table space in a partition group with more than one partition, the tables will be distributed to each database partition. Normally, we would place large tables in those partition groups that span all or most of the partitions. This setup makes the best use of the hardware configuration.

For OLTP, you should consider using a partition group with one partition, while using multipartitioned groups for DSS tables. We will see here how to create tables spaces and discuss how to distribute data.

Getting ready

If you're not using automatic storage, ensure you have a naming convention that lets you correctly identify and manage database partitions. The database partition group must already exist.

How to do it...

This command creates a table space with one file container on each partition. We'll use the default partition group in this command.

CREATE  LARGE  TABLESPACE NAV_TBLS PAGESIZE 8 KMANAGED BY DATABASEUSING ( FILE  '/data/db2/db2instp...