Number of Successful Fetches



Snapshot Level
Application
DCS Statement


Logical Data Grouping
stmt
dcs_stmt


Monitor Switch
Statement
Statement


Resettable


No


 


Event Type
Statement


Logical Data Grouping
stmt_event


 


Element Name
Element Type



fetch_count
counter

 

Description:  The number of successful fetches performed on a specific cursor.

Usage:  You can use this element to gain insight into the current level of activity within the database manager.

For performance reasons, a statement event monitor does not generated a statement event record for every FETCH statement. A record event is only generated when a FETCH returns a non-zero SQLCODE.