Type an identifier for the table space that you are creating. This identifier:
Specifies that the table space that you are creating can contain any type of data except temporary tables.
If you opened the Create Table Space wizard from the Create Table wizard, and you chose to create a regular table space, this radio button and this check box are selected by default and cannot be changed.
Specifies that the table space that you are creating will contain only indexes.
When this check box is selected, High performance is the only option on the Management page.
If you opened the Create Table Space wizard from the Create Table wizard, and you chose to create a separate index space, this radio button and this check box are selected by default and cannot be changed.
Specifies that the table space that you are creating can contain long or LOB data such as images, audio, video, or long text fields.
When this check box is selected, High performance is the only option on the Management page.
If you opened the Create Table Space wizard from the Create Table wizard, and you chose to create a separate long space, this radio button is selected by default and cannot be changed.
Specifies that the table space that you are creating can be used by the database manager for temporary tables created during sorts, joins, and other operations.
A database should have one temporary space. You can create more, but for most situations only one is required. The default temporary table space is called TEMPSPACE1.
Specifies that the table space that you are creating will be system-managed, that is, managed by the operating system.
Specifies that the table space that you are creating will be database-managed, that is, managed by the database manager.
The average size of a table in this table space will be less than 400 KB. The system recommends an extent size of 8 4KB pages.
You can calculate the size of a table by multiplying the byte count of a single row by the number of rows in the table. A rough estimate is all that you need.
The extent recommendation is based on the fact that smaller tables are more efficiently stored in smaller extent blocks.
The average size of a table in this table space will be in the range 400 KB - 2 MB. This is the default setting. The system recommends an extent size of 16 4KB pages.
You can calculate the size of a table by multiplying the byte count of a single row by the number of rows in the table. A rough estimate is all that you need.
The extent recommendation is based on the fact that smaller tables are more efficiently stored in smaller extent blocks.
The average size of a table in this table space will be greater than 2 MB. The system recommends an extent size of 32 4KB pages.
You can calculate the size of a table by multiplying the byte count of a single row by the number of rows in the table. A rough estimate is all that you need.
The extent recommendation is based on the fact that smaller tables are more efficiently stored in smaller extent blocks.
Type a number in this field or use the spin buttons to specify the number.
The number in this field multiplied by the extent size is the recommended prefetch size.
The prefetch recommendation is based on the fact that if you have containers on separate physical drives, the database can prefetch from all of those drives at the same time.
Contains the recommended extent size settings based on the answers that you specify in Determining recommended settings.
You can also change the Extent size field directly by typing a number in this field.
Contains the recommended prefetch size settings based on the answers that you specify in Determining recommended settings. The numbers are based on factors and multiples of the extent size.
You can also modify the Prefetch size field directly by clicking the down arrow to display the list of valid prefetch sizes and selecting one.
Selecting this option will set the drive specifications for a typical laptop computer with an IDE-controlled hard drive (1.2 - 10 GB). If you know the exact drive specifications for your system, type them in the fields below.
Selecting this option will set the drive specifications for a typical desktop computer with an IDE-controlled hard drive (6 - 20 GB). If you know the exact drive specifications for your system, type them in the fields below.
Selecting this option will set the drive specifications for a typical server with SCSI-controlled hard drives. If you know the exact drive specifications for your system, type in the fields below.
Selecting this option will set the drive specifications for a server with high-performance, SCSI-controlled hard drives. If you know the exact drive specifications for your system, type them in the fields below. If you are using a RAID or another advanced storage system, select Other and calculate the values for your system.
Select this option if the drive is in a computer designed to act as a data server. This option recommends faster specifications.
Select this option if you are using a RAID or another advanced storage system. Type the calculated values for your system in the fields below.
If you have exact specifications from the manufacturer, you can change the fields directly.
The value in this field is used to calculate the overhead setting.
If you have exact specifications from the manufacturer, you can change the fields directly.
The value in this field is used to calculate the overhead setting.
If you have exact specifications from the manufacturer, you can change the fields directly. Transfer rate is also known as sustained data rate or sustained throughput. Do not use the "maximum interface transfer rate".
The value in this field is used to calculate the transfer setting.
The overhead value is calculated from the values in the Average seek time, Rotation speed, and Transfer rate fields in the Specifications, which, in turn, are recommended based on the answers that you specify in Determining your specifications and calculated settings.
However, if you calculated the settings manually, you can modify the fields directly.
This value is calculated using the following formula:
overhead = average seek time + ( ( ( 1 / rotation speed ) * 60 * 1000 ) / 2 )
The transfer value is calculated from the values in the Average seek time, Rotation speed, and Transfer rate fields in the Specifications, which, in turn, are recommended based on the answers that you specify in Determining your specifications and calculated settings.
However, if you calculated the settings manually, you can modify the fields directly.
This value is calculated using the following formula:
transfer = ( 1 / transfer rate ) * 1000 / 1 024 000 * 4096 (assuming a 4KB page size)