Sybase 12.4.2 manual Main IQ Store blocks messages, IQ Temporary Store blocks message, 188

Bulk loading data using the LOAD TABLE statement

Table 5-2: Memory messages

Item	Description
Mem: # mb	Current memory being used by this Adaptive Server IQ
	server, in megabytes.
M# mb	The maximum number of megabytes used by this IQ
	server since it was started.

Main IQ Store blocks messages

This line describes the permanent (main) IQ Store:

Main	Blks: U63137/6%, Buffers: U12578/L7
Table 5-3: Main blocks
Item	Description
U#	Number of blocks in use.
#%	Percentage of database filled.
Buffers:	Number of buffers in use.
U#	Note: This value will grow to maximum number of buffers that fit in
	the main buffer cache. The number increments whenever a buffer is
	allocated, but only decrements when a buffer is destroyed, not when it
	is unlocked or flushed. When it decreases, you have hit the current limit
	of virtual memory available and new memory is coming from buffer
	cache or you have an error and insert has been rolled back and restarted.
L#	Number of locked buffers. This number increments whenever you
	request a buffer. If you exceed the maximum while running a script, the
	command that exceeds it will fail and subsequent commands may
	complete incorrectly.

IQ Temporary Store blocks message

This message provides similar information to the Main IQ Store Blocks message explained above.

Temporary Blks: U273/0%, Buffers: U1987/L1960

Main buffer cache activity message

This line displays information about the main buffer cache.

Main I: L331224/P22 O: D25967/P7805 C:D0

188