Interpreting Notification Messages

By default, SAP 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.

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 SAP Sybase IQ inserts the number of records specified in the NOTIFY load option, the server sends a message such as:

2010-05-27 13:03:49 0000000002 
[20897]: 100000 Records, 2 Seconds

The first line shows how many rows SAP Sybase IQ has read so far and the number of seconds taken since the last notification message to read these additional rows. Even if SAP 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”.

• Memory Message
  The memory message displays information about memory usage of the SAP Sybase IQ server.
• IQ Main Store Blocks Message
  The IQ main store blocks message displays information about use of the blocks and buffers in the IQ main store.
• IQ Temporary Store Blocks Message
  The IQ temporary store blocks message displays information about use of the blocks and buffers in the IQ temporary store.
• Main Buffer Cache Activity Message
  The main buffer cache activity message displays information about the IQ main store buffer cache.
• Temporary Buffer Cache Message
  The temporary buffer cache activity message displays information about the IQ temporary store buffer cache.
• User Name, Connection Handle, and Connection ID
  After the temporary buffer cache message, the connection handle, connection ID (SA connID), and user name are logged in the .iqmsg file once per database connection.