DB2 UDB for Linux, UNIX, and Windows table space properties

Use the Properties view to modify the properties of a DB2® UDB for Linux®, UNIX®, and Windows® or DB2 UDB for iSeries® table space.

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.

General page
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 Show Properties icon to open the Properties view for the selected object.
Buffer pool Select a buffer pool name. Click Show Properties Show Properties icon to open the Properties view for the selected object.
Tables page
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 Show Properties icon 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 Show Properties icon to open the Properties view for the selected object.
Containers page
Use the grid and the toolbar buttons on this page to add or delete containers.
  • Click the New toolbar button to add a new container to the bottom of the grid.
  • Click the Delete toolbar button to delete a container.
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).
Documentation page
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback