This page of the Table Reorganization Wizard allows you to specify the reorganization method.
You can perform table reorganization using two methods:
This method involves exporting current table data into temporary external text file on the server workstation using server-side dbload utility, dropping and re-creating the table using CREATE TABLE command and importing data into a table from a temporary file. As part of this operation the wizard recreates all table dependent objects, such as triggers, indexes, synonyms, views, foreign key referential integrity constraints and user permissions. You have to specify the location of the directory on the server workstation where to keep the temporary text file for unload operation, log file and generated operation script file. If the specified directory on the server does not exist or if you do not have sufficient privileges to create a text file in this directory the reorganization operation will be cancelled. You also should configure the optional Telnet or SSH connection parameters for your database server connection to enable this operation. The telnet connection is used to run Informix DBLOAD utility remotely at the server to achieve fastest data export and import. You can configure the telnet or SSH protocol access for your server connection using the Host Access tab of the Connection Manager dialog box. Use Tools -> Connection Manager top-level menu to open the Connection Manager dialog box.
If you do not configure the telnet connection to your server, you still can use the script, generated by the wizard. The script includes required SQL statements and Informix dbload commands. You can use Copy popup menu to copy the generated script into another tool.
*** WARNING ***
The table is dropped and recreated during this operation. Even though the Server Studio takes all required steps to make this operation safe and not to lose table data in case of failure by ensuring that the data export into the text file was successful before the table is dropped, it is always a good idea to create a backup of the table before you start using this reorganization method.
This method uses ALTER TABLE SQL statements to change table storage properties and force table data to be physically reallocated. The operation is run as part of one database transaction so failure in any part of it will rollback the entire reorganization operation. You can modify the following storage parameters when performing in-place reorganization: table dbspace or dbspace fragmentation, next extent size, table lock mode. You can not change the first extent size using this method. If you want to change it, you need to use the "Remote Export\Import" reorganization method. You also need to have at least as much free space available in the target table dbspace as amount of data currently occupied by the table.