Online Documentation for SQL Manager for DB2

Setting table properties


Use the Properties tab of Table Editor to specify new 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

Use the drop-down list to select a schema for the new table.

 

Name

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

 

New table - Setting table properties

 

 

Storage

 

Tablespace

Use the drop-down list to identify the table space where the table will be created.

 

Index

Use the drop-down list to identify the table space where the table indexes will be stored.

 

Long data

Use the drop-down list to identify the table space where the long data of the table will be stored.

 

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.

 

CheckBox Compress

This option specifies whether data compression applies to the rows of the table. It is available for server version 9.7.

 

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.

 

 

To compile the table, use the iconCompile Compile item available within the Navigation bar.