DB2 Administration › Reserve Free Space in Tablespaces and Indexes

Reserve Free Space in Tablespaces and Indexes

You should monitor the free space in the tablespaces and indexes associated with the DB2 objects. Your DB2 administration team should be able to advise if you experience negative performance because of poor organization of data and the lack of free space.

If there is a lack of free space, increase the free space parameters, and then reorganize the tablespace and index. If the free space parameters are adequate, simply reorganize the tablespace and index. These actions result in the following benefits:

• Improved row access because of the clustering of data
• More space for data resulting in fewer overflows
• Less frequent reorganization required because of fewer overflows and fragmentation
• Fewer index page splits and consequently more effective index access to data rows because of more space for index entries