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 to open the Properties view for the
selected object. |
| Buffer pool | Select a buffer pool name. Click Show Properties to open
the Properties view for the selected object. |
| 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 to open
the Properties view for the selected object. |
| 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 to open the Properties view for the selected object. |
| 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). |