An IQ message log file exists for each database. The default name of this file is dbname.iqmsg. The IQ message log file is created when the database is created. Its default location is in the same directory as the Catalog Store, although the database creator may specify another location.
By default, Sybase IQ logs the following types of messages in the message log file:
Error messages
Status messages
Insert notification messages
Query plans
You can examine this file as you would any other text file.
At the start of the file and when you start a database you see output like the following:
I. 08/11 16:29:24. 0000000000 OpenDatabase Completed I. 08/11 16:29:24. 0000000000 IQ cmd line srv opts: I. 08/11 16:29:24. 0000000000 DB: r/w, Main Buffs=127, Temp Buffs=95, Pgsz=131072/8192blksz/16bpc I. 08/11 16:29:24. 0000000000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999) I. 08/11 16:29:24. 0000000000 DB: Versn: 12.7.0/040810/P/Mainline/MS/Windows 2000/32bit/2006-08-10 09:54:19 I. 08/11 16:29:24. 0000000000 DB: Name: C:\Program Files\Sybase\ASIQ-12_7\demo\asiqdemo.db I. 08/11 16:29:24. 0000000000 DB: Txn ID Seq: 175 I. 08/11 16:29:24. 0000000000 DB: IQ Server fiona_asiqdemo I. 08/11 16:29:24. 0000000000 DB: Database encryption is OFF. I. 08/11 16:29:24. 0000000000 Mem: 41mb/M41 Main Blks: U4541/80%, Buffers: U4/L0 Temporary Blks: U65/2%, Buffers: U4/L0 Main I: L16/P2 O: C2/D2/P0 D:0 C:100.0 Temporary I: L28/P0 O: C4/D4/P0 D:0 C: 0.0
