This tutorial gives an overview of the physical storage model for a database.
In order for a database to perform well, it must be able to efficiently store and quickly retreive, search and manipulate large amounts of data. Within a DB2 database, data is stored on disk and must be read into memory in order to be searched and manipulated. On disk, data is stored within tablespaces and when the data is needed to build the result set for a particular query, the required pages must be read from the tablespaces into the buffer pool.
Therefore, physical placement of data will have a direct effect on the overall performance of the databaes system. To design and build a database that will meet performance expectations, the database administrator must understand the concepts of data placement and data manipulation in order to create an appropriate physical database design.
The DB2 storage model provides a basis to establish a good physical database design through efficient data placement.
Within a DB2 database, the storage of data is defined and controlled at four different levels :