Enterprise Edition
Customer Service

Brother-Eagle Community

  • Visit/Join Now!
  • Get tips from other users!
  • Share your own tips, advice, and metric formulas!

DBI Products

Brother-Eagle® DB2 Performance
Advice: Selects/TX

The number of Select Statements executed for each transaction tells us about the size of a transaction and may help with capacity planning and other analysis (see Logical Index Reads/TX).

The formula is:
Selects/TX = (SELECT_SQL_STMTS) / ( COMMIT_SQL_STMTS + ROLLBACK_SQL_STMTS)

Brother-Eagle presents "Selects/TX" as a delta value showing the change since the prior measurement.

Brother-Eagle will flag values in excess of 20 with a warning and values in excess of 30 with an alert because these values exceed typical industry averages. Transactions that run high numbers of statements are at risk for increased lock contention and may require larger LOGBUFSZ buffers.


View full list of DB2 LUW advice topics