Sybase IQ Data Collections

Learn about predefined data collections you can use to create jobs for Sybase IQ.

Data Collections for Server-Type Resources
Collection	Description	KPIs
All statistics collection	Contains all statistics, including server availability and performance statistics.	All KPIs listed below.
Availability statistics collection	Contains server availability statistics used in the heat chart. This is the default collection, and is automatically created when you authenticate an IQ simplex server.	Server Status SCC Agent Status Total CPU Usage System CPU Usage User CPU Usage IQ Memory Allocated Catalog Cache in Use Main Cache in Use Temporary Cache in Use Available Connections
Engine Statistics Collection	Contains IQ engine performance statistics.	Total CPU Usage System CPU Usage User CPU Usage IQ Memory Allocated IQ Maximum Memory Allocated IQ Threads in Use IQ Threads Available
Connection statistics collection	Contains connection performance statistics.	Active Connections Available Connections Active User Connections Active INC Incoming Connections Active INC Outgoing Connections User Connections Per Minute User Disconnections Per Minute
Transaction statistics collection	Contains transaction performance statistics.	Active Transactions Active User Transactions Active INC Transactions Active Load Table Statements
DBSpace statistics collection	Contains DBspace statistics for each DBspace.	Percentage of Available DBSpace DBSpace Size in Use
DBSpace file statistics collection	Contains statistics for each DBspace file.	Percentage of Available DBSpace File DBSpace File Size in Use
Store I/O statistics collection	Contains performance statistics for store reads and writes.	Catalog Store Disk Reads Per Second Catalog Store Disk Writes Per Second Temporary Store Disk Reads Per Second Temporary Store Disk Writes Per Second Main Store Disk Reads Per Second Main Store Disk Writes Per Second
Cache statistics collection	Contains performance statistics for caches.	Catalog Cache Hits Per Second Catalog Cache Reads Per Second Catalog Cache Size Catalog Cache in Use Catalog Cache Pinned Catalog Cache Pinned Percent Catalog Cache Dirty Pages Percent Temporary Cache Hits Per Second Temporary Cache Reads Per Second Temporary Cache Size Temporary Cache in Use Temporary Cache Pinned Temporary Cache Pinned Percent Temporary Cache Dirty Pages Percent Main Cache Hits Per Second Main Cache Reads Per Second Main Cache Size Main Cache in Use Main Cache Pinned Main Cache Pinned Percent Main Cache Dirty Pages Percent
Op/Req statistics collection	Contains performance statistics related to operations and requests.	IQ Waiting Operations IQ Active Operations Requests Per Second Unscheduled Requests
Network statistics collection	Contains network-related performance statistics.	Bytes Received Per Second Bytes Received Uncompressed Per Second Bytes Sent Per Second Bytes Sent Uncompressed Per Second Available Communication Buffers Total Communication Buffers

Data Collections for Multiplex-Type Resources
Collection	Description	KPIs
All multiplex statistics collection	Contains all multiplex-related statistics and all statistics for each node. When scheduled, all node statistics are collected.	Multiplex Status The following KPIs of each node: Server Status SCC Agent Status Multiplex Role Multiplex Status Multiplex Failover Node INC Status Total CPU Usage System CPU Usage User CPU Usage IQ Memory Allocated IQ Maximum Memory Allocated IQ Threads in Use IQ Threads Available Active Connections Available Connections Active User Connections Active INC Incoming Connections Active INC Outgoing Connections User Connections Per Minute User Disconnections Per Minute Active Transactions Active User Transactions Active INC Transactions Active Load Table Statements The following KPIs for each DBspace: Percentage of Available DBSpace DBSpace Size in Use The following KPIs for each DBSpace file: Percentage of Available DBSpace File DBSpace File Size in Use Catalog Store Disk Reads Per Second Catalog Store Disk Writes Per Second Temporary Store Disk Reads Per Second Temporary Store Disk Writes Per Second Main Store Disk Reads Per Second Main Store Disk Writes Per Second Catalog Cache Hits Per Second Catalog Cache Reads Per Second Catalog Cache Size Catalog Cache in Use Catalog Cache Pinned Catalog Cache Pinned Percent Catalog Cache Dirty Pages Percent Temporary Cache Hits Per Second Temporary Cache Reads Per Second Temporary Cache Size Temporary Cache in Use Temporary Cache Pinned Temporary Cache Pinned Percent Temporary Cache Dirty Pages Percent Main Cache Hits Per Second Main Cache Reads Per Second Main Cache Size Main Cache in Use Main Cache Pinned Main Cache Pinned Percent Main Cache Dirty Pages Percent IQ Waiting Operations IQ Active Operations Requests Per Second Unscheduled Requests Bytes Received Per Second Bytes Received Uncompressed Per Second Bytes Sent Per Second Bytes Sent Uncompressed Per Second Available Communication Buffers Total Communication Buffers
Multiplex availability collection	Contains multiplex status, availability statistics, and multiplex role/status/failover/INC status of each node. When scheduled, all node availability statistics are collected. This is the default collection and is automatically created when you authenticate a multiplex-type resource.	Multiplex status The following KPIs of each node: Server Status SCC Agent Status Total CPU Usage System CPU Usage User CPU Usage IQ Memory Allocated Catalog Cache in Use Main Cache in Use Temporary Cache in Use Available Connections Multiplex Role Multiplex Status Multiplex Failover Node INC Status