Prefetch size

This box contains the number of pages that are read from the table space when data prefetching is being performed. Initially, it displays the default value of the dft_prefetch_sz configuration parameter.

To change the prefetch size, use one of these methods:

• Click on the arrow keys to display a list of recommended sizes and select one.
• Type the number of prefetch pages in the box (preferably a multiple of the extent size).

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

[ DB2 List of Books | Search the DB2 Books ]