An IQ message log file exists for each database to capture messages from the server about operations.
The message log file has the default name dbname.iqmsg, and is created in the same directory as the catalog store when you start a newly created database. The database creator may specify a different location, a different file name, or both.
Error messages
Status messages
Insert notification messages
Query plans
You can examine this file as you would any other text file.
At the beginning of the file, and when you start a database, you see output similar to:
I. 09/06 17:20:57. 0000000000 OpenDatabase Completed
I. 09/06 17:20:57. 0000000000 IQ cmd line srv opts: -iqmc 64 -iqtc 64
I. 09/06 17:20:57. 0000000000 IQ full cmd line: -n system1_demo -c 48m -gd all -gm 10
-gp 4096 -x tcpip{port=9030} -iqmc 64 -iqtc 64 -gc 20 -gl all -ti 4400 -gn 25
-o /system1/users/user1/sybase/IQ-15_4/logfiles/system1.0001.srvlog -hn 5
I. 09/06 17:20:57. 0000000000 DB: r/w, Main 63MB Buffs=510, Temp 63MB Buffs=510,
Pgsz=131072/8192blksz/16bpc, BP=4
I. 09/06 17:20:57. 0000000000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
I. 09/06 17:20:57. 0000000000 DB: Versn: 15.4.0.6556/110905/P/Mainline/Sun_x64/OS 5.10
/64bit/2011-09-05 23:25:52
I. 09/06 17:20:57. 0000000000 DB: Name: /system1/users/user1/iqdemo.db
I. 09/06 17:20:57. 0000000000 DB: Txn ID Seq: 1
I. 09/06 17:20:57. 0000000000 DB: DBID Blk: 2610
I. 09/06 17:20:57. 0000000000 DB: IQ Server system1_demo, PID 11033, LOGIN user1
I. 09/06 17:20:57. 0000000000 DB: Database encryption is OFF.
I. 09/06 17:20:57. 0000000000 Mem: 160mb/M163
Main Blks: U2721/21%, Buffers: U6/L1
Temporary Blks: U65/2%, Buffers: U4/L0
Main I: L24/P4 O: C2/D2/P0 D:0 C:100.0
Temporary I: L34/P0 O: C4/D4/P0 D:0 C: 0.0
I. 09/06 17:20:57. 0000000000 Collation ISO_BINENG, Case Ignore, Blank Padding On, Comparisons are Conditioned
I. 09/06 17:20:57. 0000000000 RcvyCmpl
I. 09/06 17:20:57. 0000000000 Chk
I. 09/06 17:20:57. 0000000000 ChkDone [NumTxnCP: 0]
I. 09/06 17:20:57. 0000000000 PostChk
I. 09/06 17:20:57. 0000000000 CloseDatabase
I. 09/06 17:20:57. 0000000000 Warning: Using default value for -iqmc or -iqtc is
insufficient for most applications