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