IBM Books


Number of Rows Read from Tablequeues


Snapshot Information Level
Application

API Structure(s)
sqlm_subsection

Monitor Group
Statement

Resettable

No

 

Event Information Level
Statement

API Structure(s)
sqlm_subsection_event

 

API Element Name
Element Type

tq_rows_read
counter

 

Description:  Total number of rows read from tablequeues.

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.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]