IBM Books


Maximum Number of Agents


Snapshot Information Level
Database

API Structure(s)
sqlm_dbase

Monitor Group
Statement

Resettable

No

 

API Element Name
Element Type

agents_top
highest

 

Description:  Maximum number of agents used when running a statement.

Usage:  An indicator how well queries are being 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 ]