Implementing Db2 table spaces

Db2 table spaces are storage structures that store one or more data sets, which store one or more tables.

You can let Db2 create table spaces for your tables implicitly, or you can create them explicitly before you create the tables. You only need to create a table space explicitly when you define a declared temporary table or if you manage all of your own data sets. It is best to create partition-by-growth or partition-by-range universal table spaces in most cases. Other table space types are deprecated. That is, they are supported in Db2 12, but support might be removed in the future.