By default, Sybase IQ displays information about your database during insert and load operations in the IQ message log (.iqmsg file).
The statistics in these messages indicate when you need to perform maintenance and optimization tasks, such as adding more dbspaces. The messages also report on the progress of the load. This section explains each notification message.
At the start of the insert is a description of the operation, such as this one:
In table 'partsupp', the full width insert of 5 columns will begin at record 1. 2001-02-27 13:03:47 0000000002 Insert Started: 2001-02-27 13:03:47 0000000002 partsupp 2001-02-27 13:03:48 0000000002 [20270]: =n*** File: /remote/rip/tpcd_data/scale_1/partsupp.tbl
Each time it inserts the number of records specified in the NOTIFY load option, Sybase IQ sends a message like this:
2001-02-27 13:03:49 0000000002 [20897]: 100000 Records, 2 Seconds
Mem: 469mb/M470
Main Blks: U63137/6%, Buffers: U12578/L7
Temporary Blks: U273/0%, Buffers: U1987/L1960
Main I: L331224/P22 O: D25967/P7805 C:D0
Temporary I: L25240/P8 O: D4749/P0 C:D0
The first line shows how many rows Sybase IQ has read since the last notification message, and the number of seconds taken reading them. Even if Sybase IQ reads the same number of messages each time, the amount of time varies depending on the data read (for example, how many data conversions are required). Reported time intervals smaller than 1 second are usually reported as “0 Secs”.
