For more information about DB2 UDB for Linux, UNIX, and Windows or DB2 UDB for iSeries syntax, see the reference information that is included with each product.
Property | Description |
---|---|
Name | Type a name. |
Label | Type a label. This label is displayed in visual diagrams. |
Type | Shows the table space type. This field cannot be edited. This property is set when you add a table space by using the Data Project Explorer menu items or by using a data diagram. |
Management | Select an option for the MANAGED BY clause. You can select SYSTEM_MANAGED or DATABASE_MANAGED. |
Extent size | Type an EXTENTSIZE value. |
Prefetch size | Type a PREFETCHSIZE value. |
Overhead | Type an OVERHEAD value. |
Transfer rate | Type a TRANSFERRATE value. |
Recover dropped table | Select to specify the DROPPED TABLE RECOVERY YES option. |
Group | Select a partition group name for the IN DATABASE PARTITION
GROUP clause. Click Show Properties ![]() |
Buffer pool | Select a buffer pool name. Click Show Properties ![]() |
Property | Description |
---|---|
Tables, Current® | Shows a list of the tables that are assigned to the
table space. Select a table from the list and click the > button to remove
the table from the list. Select a table and click Show Properties ![]() |
Tables, Available | Shows a list of available tables to add to the table
space. Select a table from the list and click the < button to move a table
to the Current tables list. Select a table and click Show
Properties ![]() |
Property | Description |
---|---|
Name | Type a name. |
Type | Select a container type. You can select DEVICE, DIRECTORY, or FILE. |
Size (in pages) | Type a PAGESIZE page value. |
Size | Type a SIZE integer value. |
Units | Select a unit of measurement for the SIZE value. You can select K (kilobytes), M (megabytes), or G (gigabytes). |