Transaction Log

The transaction log file contains information that allows Sybase IQ to recover from a system failure. The transaction log is also required for auditing. The default file name extension for this file is .log.

To move or rename the transaction log file, use the Transaction Log utility (dblog). See Utility Guide > Database Administration Utilities > Transaction Log utility (dblog).

Warning!

The Sybase IQ transaction log file is different from most relational database transaction log files. If for some reason you lose your database files, then you lose your database (unless it is the log file that is lost). However, if you have an appropriate backup, then you can reload the database.

Truncating the Transaction Log
Sybase IQ records in the transaction log the information necessary to recover from a system failure. Although the information logged is small for each committed transaction, the transaction log continues to grow in size. In systems with a high number of transactions that change data, over a period of time the log can grow to be very large.
Truncating the Transaction Log Of a Stopped Database
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.

Parent topic: Strategic File Locations