Creating/editing table space
Use the Property tab of Tablespace Editor to create/edit a table space and specify its definition.
Tablespace name
Enter a name for the new table space (this is a one-part name).
Dropped table recovery
Use this option if you wish to recover dropped tables in the specified table space (with the RECOVER TABLE ON option of the ROLLFORWARD command used). This option is only available for a REGULAR table space.
Type of data in tablespaces
Regular
If this type is selected, all data except for temporary tables are stored in the table space.
Large
If this type is selected, long or LOB table columns and structured type columns or index data are stored in the table space.
System temporary
If this type is selected, temporary tables (work areas used by the database manager to perform operations such as sorts or joins) are stored in the table space.
User temporary
If this type is selected, declared global temporary tables are stored in the table space.
Managed by...
System
If this option is selected, the table space will be a system managed space (SMS) table space.
Database
If this option is selected, the table space will be a database managed space (DMS) table space.
Page size dependent options
Define the Page size and the Buffer pool values (in kilobytes) for the table space.
Extent size dependent options
Define the Extent size and the Prefetch size values (in pages, kilobytes, megabytes or gigabytes) for the table space.
I/O cost estimate
Define the Transfer rate and the Overhead values (in milliseconds) for the table space.