IBM Books

Internal Rows Inserted


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_inserted
counter

 

Description:  The number of rows inserted into the database as a result of internal activity caused by triggers.

Usage:  This element can help you gain insight into the internal activity within the database manager. If this activity is high, you may want to evaluate your design to determine if you can alter it to reduce this activity.

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

[ DB2 List of Books | Search the DB2 Books ]