8.4. Table Spaces
As discussed in Chapter 7, Working with Database Objects, a table space is a logical, not physical, database object. You cannot point to anything on disk or your server and say “This is my table space.” In DB2, all tables and indexes must be created in table spaces. Therefore, it is important to understand how to create and change table spaces.
A table space is a collection of one or more underlying physical storage devices known as containers. This allows you complete control over the placement of the containers on the disks, devices, and file systems available on your server.
There are two types of table spaces depending on how the physical space is allocated: system managed space (SMS) and database managed space (DMS). SMS ...
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
