Use the Advanced window to specify performance parameters
for a new table space.
Fields and controls
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,
8KB, 16KB, and 32KB.
- 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.