IBM Books


Number of Agents


Snapshot Information Level
Database
Application

API Structure(s)
sqlm_dbase
sqlm_appl

Monitor Group
Statement
Statement

Resettable

No

 

API Element Name
Element Type

num_agents
highest

 

Description:  Number of agents concurrently executing a statement.

Usage:  An indicator how well the query is divided among partitions (partitioned database) or is using intra-partition parallelism.

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

[ DB2 List of Books | Search the DB2 Books ]