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.