Back
Next
Done
Show SQL
Cancel
Back
Next
Done
Show SQL
Cancel
Name page
Table space name
Table space name
Type an identifier for the table space that you're creating. This identifier:
Type page
Regular
Indexes only
Long
Temporary
Regular
Select this radio button to specify that the table space you are creating can contain any type of data except temporary tables.
If you opened the Create Table Space SmartGuide from the Table space Create push button in the Create Table SmartGuide, this radio button is selected by default and cannot be changed.
Indexes only
Select this check box to specify that the table space you are creating will contain only indexes.
When this box is selected, High performance is the only option on the Management page
If you opened the Create Table Space SmartGuide from the index space Create push button in the Create Table SmartGuide, the Regular radio button and this check box are selected by default and cannot be changed.
Long
Select this radio button to specify that the table space you are creating can contain long or LOB data like images, audio, video, or long text fields.
When this is selected, High performance is the only option on the Management page.
If you opened the Create Table Space SmartGuide from the long space Create push button in the Create Table SmartGuide, this radio button is selected by default and cannot be changed.
Temporary
Select this radio button to specify that the table space you are creating can be used by the database manager for temporary tables created during sorts, joins, and other operations.
There is no reason to have more than one temporary table space in a database, because the database manager uses only one at a time.
Management page
Low maintenance
High performance
Low maintenance
Select this radio button to specify that the table space you are creating will be system managed space, managed by the operating system.
High performance
Select this radio button to specify that the table space you are creating will be database managed space, managed by the database manager.
Containers page
Container list
Container List
This list shows the containers that are currently being used to store the table space. For SMS containers, the list shows the path of the container. For DMS containers, the list shows the full path, the type, and the size of the container.
Use the buttons to add more containers, change an existing container, or remove a container.
Read/Write page
Questions for recommended settings
Recommended settings
Questions for recommended settings
Answer these questions to get recommended extent and prefetch sizes in the Recommended settings group.
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 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 arrows to spin to the number you want.
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.
Recommended settings
These fields contain recommended settings based on the answers you specify in the Questions for recommended settings. You can also modify the Extent size and Prefetch size fields directly.
Drive Speed page
If containers are defined on only one drive:
Questions for recommended specifications
Recommended specifications
Calculated settings
If containers are defined on more than one drive:
Drive specifications (OS/2,
Windows NT, Windows 95, and Windows 98 only)
Questions for recommended specifications
Answer these questions to get recommended average seek time, rotation speed, and transfer rate in the Recommended specifications group. The recommended specifications are used to calculate settings for overhead and transfer.
Specify the size of the physical drive, not a logical partition of the drive.
The recommended specifications are based on the fact that hard drives of similar sizes have similar specifications.
Select 1995 or newer if the drive was new in or after 1995. If you are not sure, guess based on the age of the computer.
Selecting 1995 or newer recommends faster specifications.
The recommendation is based on the fact that newer drives of a given size tend to have faster specifications.
Select High performance server if the drive is in a computer designed to act as a data server.
Selecting High performance server recommends faster specifications.
The recommendation is based on the fact that servers tend to have drives with faster specifications.
Recommended specifications
These fields contain the recommended average seek time, rotation speed, and transfer rate based on the answers you specify in the Questions for recommended specifications. However, if you can get the exact specifications from the drive manufacturer, you can modify the fields directly.
Calculated settings
The overhead and transfer values in these fields are calculated from the values in the Average seek time, Rotation speed, and Transfer rate fields in the Recommended specifications which in turn are recommended based on the answers you specify in the Questions for recommended specifications.
However, you calculated the settings manually, you can modify the fields directly.
overhead = avg seek time + ( ( ( 1 / rotation speed ) * 60 * 1000 ) / 2 )
transfer = ( 1 / transfer rate ) * 1000 / 1024000 * 4096
Drive specifications (OS/2, Windows NT, Windows 95, and Windows 98
only)
This list shows the performance parameters for the drives where any containers will be stored. The overhead and transfer rates are used by DB2 to optimize database performance.
Use the Change push button to change the overhead and transfer rates for the selected drive.
