Online Documentation for SQL Manager for DB2

Setting reorganize options


This step of the wizard allows you to set the reorganize options.

 

Reorganize Tables - Setting reorganize options

 

 

Reorganize by index

Use this drop-down list to select an index to reorganize the selected table by.

 

Temporary tablespace

Specifies the name of a system temporary table space in which a temporary copy of the table being reorganized is stored.

 

 

Options

 

RadioButton Execute online

Select this option to reorganize the table while permitting user access (INPLACE).

 

CheckBox Truncate table

This option determines whether the table is to be truncated or not.

 

Action

Specify the preferable action: Start, Stop, Pause, Resume.

 

RadioButton Execute offline

Select this option to reorganize the table while not permitting user access (INPLACE).

 

CheckBox Reorganize Long/LOB data

If this option is selected, Long fields and LOB data will be reorganized.

 

CheckBox Access table through index

Check this option to specify that table rows are to be reorganized by accessing the table through an index.

 

 

Table access

 

RadioButton Read-only

This option specifies that other users can have read-only access to the table while the indexes are being reorganized.

RadioButton Read/write

This option specifies that other users can read from and write to the table while the indexes are being reorganized.

RadioButton Do not allow access

This option specifies that no other users can access the table while the indexes are being reorganized.

 

 

Select tables one by one in the Table name list and set options for each of them separately, or check the CheckBox Use equal options for all tables option to apply the current options for all the tables.

 

 

Click the Next button to proceed to the Setting runstats options step of the wizard.