Performing Tuple Mover Operations Manually

Vertica recommends using the automatic tuple mover at all times. However, if you are directed to do so by Technical Support, use the following sequence of operations.

Note: Running the automatic tuple mover while doing manual moveout/mergeout operations at the same time is not supported.

1. In SQL, stop the automatic tuple mover:

   SELECT STOP_TUPLE_MOVER();

2. Restart the database. See Starting and Stopping the Database in the Database Administrator's Guide.
3. Perform manual tuple mover operations as instructed by Technical Support:

   To submit problem reports, questions, comments, and suggestions, please use the Technical Support page on the Vertica Systems, Inc. Web site:

   http://www.vertica.com/support

   You must be a registered user in order to access the page.

   Before reporting a problem, please run the Diagnostics Utility described in the Troubleshooting Guide and attach the resulting .zip file.

   • SELECT ADVANCE_EPOCH
   • ALTER PROJECTION
   • SELECT ANALYZE_STATISTICS

   See the SQL Reference Manual for descriptions of these commands

4. Restart the automatic tuple mover

   SELECT START_TUPLE_MOVER();

5. Restart the database.