Online Documentation for SQL Manager for DB2

Setting reorganize options


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

 

Reorganize Indices - Setting reorganize options

 

 

Options

 

RadioButton Cleanup only

If this option is selected, cleanup is performed without rebuilding the indexes.

RadioButton Convert type 1 indexes to type 2

If this option is selected, type 1 indexes will be converted to type 2.

RadioButton Cleanup pages only

If this option is selected, only committed pseudo empty pages will be removed from the index tree.

RadioButton Cleanup all

If this option is selected, indexes will be cleaned up by removing both committed pseudo deleted keys and committed pseudo empty pages.

 

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.

 

 

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