SelectTotStmts (DB2DB_SQL)


Indicates the ratio of SQL SELECT statements to the total SQL statements that have been attempted against the selected database. This parameter is helpful in analyzing database activity and throughput.

Default parameter attributes

Attribute

Default value

Application class

DB2EEEDB_NODE_SQL

Command type

not applicable

Platform

All

Active at installation

yes

Parameter type

Consumer

Scheduling (poll time)

not applicable

Icon style

Graph

Alarm 1 range

not applicable

Alarm 2 range

not applicable

Border range

not applicable

Unit

Percentage

Annotated?

No

Value set by

CollDatabase

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for DB2 Universal Database 9.0