DB2 Version 9.7 for Linux, UNIX, and Windows
tq_max_send_spills - Maximum number of table queue buffers overflows
monitor element
Maximum number of table queue buffers overflowed to a temporary table.
Element identifier
tq_max_send_spills
Element type
watermark
Table 1. Snapshot Monitoring Information
Snapshot Level
Logical Data Grouping
Monitor Switch
Application
subsection
Statement
Table 2. Event Monitoring Information
Event Type
Logical Data Grouping
Monitor Switch
Statements
event_subsection
-
Usage
Indicates the maximum number of table queue buffers that have been written to a temporary table.
Parent topic:
Database system monitor elements
Related reference
:
tq_cur_send_spills - Current number of table queue buffers overflowed monitor element
tq_tot_send_spills - Total number of table queue buffers overflowed monitor element