IBM Books

Percentage of free space in each data page (PAGEFREESPACE)

This field contains the percentage of each data space that is to be left as free space. To change this percentage, use one of these methods:

For example, if you specify 50, then 50% of each data page is left as free space. The default value of 0 specifies that no space in each data page will be specifically left as free space.

If you specify an invalid value because of the minimum row size (for example, a row that is at least 3000 bytes long and a page free space of 50), the row will be placed on a new page. If you specify 100, each row will reside on a new page.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]