This method involves exporting current table data into temporary external text file on the server workstation using server-side Informix DBLOAD utility, dropping and recreating the table using CREATE TABLE SQL statement 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 should also configure the optional Telnet or SSH connection parameters for your database server connection to enable this operation. The telnet connection is used to run remotely Informix DBLOAD utility for fast 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 do not lose table data in case of operation failure by ensuring that the data was successfully exported into the text file 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.
Check the "Leave data file and scripts on server" checkbox if you want to keep the data export text file, which contains the exported table data, and generated reorganization operation script file on the server after the operation is successfully completed. If this checkbox is not checked these files will be deleted from the temporary directory, which you have specified, after successful completion of the reorganization operation. You might use the export data file to manually load the data into the database table using Informix DBLOAD utility. Please note that the export text file is always left in the temporary directory in case of any error so that you could recover the table data manually if required.
The 'Perform commit every ... rows ' dropdown box allows you to define a corresponding parameter, which is used by Informix DBLOAD utility when it performs data import operation from the temporary text file into the recreated table.