DB2 Version 9.7 for Linux, UNIX, and Windows

tq_rows_read - Number of Rows Read from table queues monitor element

Total number of rows read from table queues.

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

If monitoring does not indicate that this number is increasing, then processing progress is not taking place.

If there is significant differences in this number between nodes, then some nodes may be over utilized while others are being under utilized.

If this number is large, then there is a lot of data being shipped between nodes, suggest that optimization might improve the access plan.