Use
the –m server start-up switch to truncate
the database transaction log. Leaving the –m server
start-up switch permanently set is not recommended. This
switch should only be used to start Sybase IQ for a transaction
log truncation. How this is done is up to the DBA, but the following
procedure provides a suggestion.
- Create a copy of the server switches .cfg file
with a name identifying the file as the log truncation configuration
setting, and edit this copy of the file to add the –m switch.
- Start Sybase IQ with the configuration file containing
the –m option. Note that no user access
or transactions should be allowed at this time.
- Shut down Sybase IQ and restart using the configuration
file without the –m option set.