Understanding DB2®: Learning Visually with Examples
by Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
7.4. Table Spaces
A table space is a logical object of your database. It is used to associate your logical tables and indexes to your physical devices (containers) and physical memory (buffer pools). All tables and indexes must reside inside a table space.
7.4.1. Table Space Classification
Table spaces can be classified based on how the table space is managed and on what type of data they contain.
Based on how the table space is managed, a table space can be one of the following types.
System-managed space (SMS): This type of table space is managed by the operating system and requires minimal administration. This is the default table space type.
Database-managed space (DMS): This type of table space is managed by the DB2 database manager, and ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access