ApplCommitsAttempted (DB2_AGENT)


Indicates the number of SQL COMMIT statements that have been attempted for a particular application. A small value in this parameter may indicate that applications are not performing commits frequently enough, which may lead to problems with logging and data concurrency.  This parameter value is calculated as the total number of SQL COMMIT statements attempted on an hourly basis.

Default parameter attributes

Attribute

Default value

Application class

DB2_AGENT 

Command type

not applicable

Platform

All

Active at installation

no

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 

Number since last collection cycle

Annotated?

No

Value set by

CollAgent 

 

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

BMC PATROL for DB2 Universal Database 9.0