Use the Advanced window to specify performance parameters
for a new table space.
To specify performance parameters for a table space:
- You can do one or more of the following tasks:
- In the Page size field, specify the size
of the pages to be used for the table space. The valid values are 4KB
and 8KB.
- In the Extent size field, specify the
number of pages to be written to a container before the database manager skips
to another container.
- In the Prefetch size field, specify the
number of pages to be read from the table space when data prefetching is being
performed.
- In the Overhead field, specify the number
of milliseconds you want to use during query optimization as the amount of I/O
controller overhead.
- In the Transfer field, specify the number
of milliseconds to be used to read one page into memory.
- In the Buffer pool field, specify the
name of the buffer pool that this table space should reside in.
- Click on the OK push button to return to the Create Table Space
window.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]