IQ Log Files

There are four log files in the SAP Sybase IQ database.

The names of the IQ log files are derived from the name of the database with unique extensions. For example, an IQ database named "customer" would contain a catalog store named customer.db, an IQ message file named customer.iqmsg, and a catalog store transaction log file named customer.log. If using file systems for the IQ store and IQ temporary store, their names would be customer.iq and customer.iqtmp, respectively. For raw partitions, the dbspaces would be named by the partition name.

• Message Log
  The IQ message file is created when an SAP Sybase IQ server starts for the first time.
• Catalog Store Transaction Log
  The transaction log file contains transaction for the catalog store only. It is used to roll back (undo) or roll forward changes as necessary.
• Server Logs
  The SAP Sybase IQ server engine logs messages to several log files which are created each time the server is started
• RLV Log
  RLV store logging is different, and in many ways simpler, than traditional database (disk or in-memory) logging. because data in the RLV store is transient. Data pages are not persisted to disk, and data is merged to the IQ main store on a frequent basis.