The transaction log file contains transaction for the catalog store only. It is used
to roll back (undo) or roll forward changes as necessary.
The catalog store transaction log file does not contain any transactions for the
warehouse data in the IQ store. The name of the physical file is dbname.log
and it is stored in the same directory as the .db file.
The catalog store transaction log is a small file whose growth over time is related to
its activity. This file must exist as a component of the
SAP Sybase IQ database.
Do not delete or alter this file. If this file is lost or damaged, technical support may
be necessary to recover the database. To protect .log file, it may be mirrored to
another directory. All transactions involving data in the catalog store are logged to
this transaction log, including:
- Any create, alter or drop commands associated with
SAP Sybase IQ database objects
- Adding or removing users from the database
- Adding or changing user permissions
- Adding or changing a dbspace to the database
- Any DML statement for user data that is stored in the catalog