Number of Successful Fetches

Snapshot Information Level Application	API Structure(s) sqlm_stmt	Monitor Group Statement
Resettable	Yes
Event Information Level Statement	API Structure(s) sqlm_stmt_event
API 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, an event is not generated for every FETCH statement. An event is only generated under the following conditions:

A FETCH is performed and returns a non-zero SQLCODE
A CLOSE CURSOR statement is performed, either explicitly or implicitly. (See "Statement Type" to help you determine whether the CLOSE CURSOR was issued implicitly.)

If, for example, your application performs 100 fetches and the first 99 fetches are successful, you will receive two statement events:

A fetch event indicating the 99 successful fetches. For this first statement event record, this element will equal 99 and the SQLCODE will be zero.
A fetch event indicating the one unsuccessful fetch. For this second statement event record, this element will equal one and the SQLCODE will be non-zero.

If, for example, your application performed 100 successful fetches followed by a CLOSE CURSOR, you will receive two statement events:

A fetch event indicating the 100 successful fetches. For this first statement event record, this element will equal 100 and the SQLCODE will be zero.
A close event indicating the cursor was closed. For this second statement event record, this element is not applicable and is set to zero.