Chapter8.The DB2 Storage Model

Chapter 8. The DB2 Storage Model

This chapter describes how DB2 stores its objects on disk and introduces the concepts of table spaces, pages, and extents. It discusses how you can create and modify these objects on your database server so that your system will perform as optimally as possible and so that you do not run out of space when working with the database.

In this chapter you will learn about:

• DB2's storage model

• Database creation and structure

• Partition groups

• Table spaces

• Containers

• Extents

• Pages

• Buffer pools