Tablespaces are database objects that provide a mapping between objects containing data to be retained and the operating system storage subsystem. Data can be retained in a transactional state or in a persisted state. For example, a sort overflow requires data to be retained until the sort process is completed, while base tables and indexes persist data until removed by a process.
Tablespaces
Containers
Containers are the actual physical files that store data. Containers have the following three categories of management:
- Database Managed Space (DMS)
- System Managed Space (SMS)
- Automatic Storage (AS)
A disk storage device can be used by Db2 in its raw state; we call this a raw device. In the past, raw devices were used for...
