Online Documentation for SQL Manager for DB2

Table properties


The Properties tab allows you to view/edit common properties of the table: schema name, table name, Storage attributes, common options (Data capture, Table Lock, etc.)

 

Schema

View the schema of the table being edited.

 

Name

Specify a name for the table. Note that the name must not identify a table, view or alias described in the catalog.

 

Table Editor - Table Properties

 

 

Storage

 

Tablespace

Specifies the table space where the table are created.

 

Index

Specifies the table space where the table indexes are stored.

 

Long data

Specifies the table space where the long data of the table are stored.

 

Options

 

Data capture

This option indicates whether extra information regarding SQL changes to this table will be written to the log or not:

RadioButton None

RadioButton Table SQL changes

RadioButton Table SQL changes include LONGVAR columns

 

Lock

Specify whether lock is to be applied to a Row or to the entire Table while the table data is being modified.

 

CheckBox Not logged

This option specifies that changes made to the column are not to be logged.

 

CheckBox Append

This option specifies that new rows are appended at the end of table data.

 

CheckBox Value compression

This option specifies whether the table values are compressed or not.

 

CheckBox Volatile

This option specifies that cardinality of the table is volatile.

 

CheckBox Restrict the drop

Check this option to restrict dropping the table.

 

If necessary, specify the PCTFree value for the table specifying what percentage of each index page is left as free space when building the index.

 

Security policy name

Select the security policy that will be used to protect the table. The option is available only for DB2 version 9 and higher.

 

The lower editable area allows you to provide an optional comment for the table.