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:
In table 'tab2', the full width insert of 2 columns will begin at record 1. I. 02/11 13:28:14. 0000000002 Insert Started: I. 02/11 13:28:14. 0000000002 tab2 I. 02/11 13:28:14. 0000000227 [20895]: Insert Pass 1 completed in 0 seconds. I. 02/11 13:28:14. 0000000227 [20895]: Insert Pass 2 completed in 0 seconds. I. 02/11 13:28:14. 0000000227 [20834]: 1 records were inserted into 'tab2'.
Each time Sybase IQ inserts the number of records specified in the NOTIFY load option, the server sends a message like:
2010-05-27 13:03:49 0000000002 [20897]: 100000 Records, 2 Seconds
The first line shows how many rows Sybase IQ has read so far and the number of seconds taken since the last notification message to read these additional rows. Even if Sybase IQ reads the same number of rows 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”.