IBM Books

Internal Rows Updated


Snapshot Information Level
Database
Application

API Structure(s)
sqlm_dbase
sqlm_appl
sqlm_stmt

Monitor Group
Basic
Basic
Basic

Resettable

Yes

 

Event Information Level
Database
Connection
Statement

API Structure(s)
sqlm_db_event
sqlm_conn_event
sqlm_stmt_event

  

API Element Name
Element Type

int_rows_updated
counter

 

Description:  This is the number of rows updated from the database as a result of internal activity.

Usage:  This element can help you gain insight into internal activity within the database manager of which you might not be aware. If this activity is high, you may want to evaluate your table design to determine if the referential constraints that you have defined on your database are necessary.

Internal update activity can be a result of:

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

[ DB2 List of Books | Search the DB2 Books ]