Sybase IQ Data Collections

Lists and describes predefined data collections you can use to create jobs for Sybase IQ.

Data collections for Sybase IQ
Collection	Description
All statistics collection	Contains all statistics, including server availability and performance statistics.
Availability statistics collection	Contains server availability statistics used in the heat chart. This is the default collection, and is automatically created at login. By default, the statistics are collected every 60 seconds.
Engine statistics collection	Contains performance statistics and includes the following KPIs: IQ maximum memory allocated IQ memory allocated IQ server system CPU usage IQ server total CPU usage IQ server user CPU usage IQ threads available IQ threads in use
Connection statistics collection	Contains performance statistics and includes the following KPIs: Number of active connections Number of active INC incoming connections Number of active INC outgoing connections Number of active user connections Number of connections available Number of user connections per minute Number of user disconnections per minute
Transaction statistics collection	Contains performance statistics and includes the following KPIs: Number of active INC transactions Number of active load table statements Number of active transactions Number of active user transactions
DBSpace statistics collection	Contains dynamic statistics for each dbspace, including: dbspace size in use percentage of available dbspace
DBSpace file statistics collection	Contains dynamic statistics for each dbspace file, including: dbspace file size in use percentage of available dbspace File
Store I/O statistics collection	Contains performance statistics and includes the following KPIs: Catalog store disk reads Catalog store disk writes Main store disk reads Main store disk writes Temp store disk reads Temp store disk writes
Caches statistics collection	Contains performance statistics and includes the following KPIs: Catalog cache hits Catalog cache reads Catalog cache size Catalog cache in use percent Catalog cache pinned Catalog cache pinned percent Catalog cache dirty pages percent Temp cache hits Temp cache reads Temp cache size Temp cache in use percent Temp cache pinned Temp cache pinned percent Temp cache dirty pages percent Main cache hits Main cache reads Main cache size Main cache in use percent Main cache pinned Main cache pinned percent Main cache dirty pages percent
Op/Req statistics collection	Contains performance statistics and includes the following KPIs: IQ active operations IQ waiting operations Requests per second Unscheduled requests
Network statistics collection	Contains performance statistics and includes the following KPIs: Available communication buffers Bytes received Bytes received uncompressed Bytes sent Bytes sent uncompressed Total communication buffers