DB2 Version 9.7 for Linux, UNIX, and Windows

fetch_count - Number of Successful Fetches monitor element

The number of successful physical fetches or the number of attempted physical fetches, depending on the snapshot monitoring level.

For the stmt and dynsql snapshot monitoring levels and the statement event type: the number of successful fetches performed on a specific cursor.
For the dcs_stmt snapshot monitoring level: The number of attempted physical fetches during a statement's execution (regardless of how many rows were fetched by the application). In this situation, fetch_count represents the number of times the server needed to send a reply data back to the gateway while processing a statement.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	stmt	Statement
DCS Statement	dcs_stmt	Statement
Dynamic SQL	dynsql	Statement

For Dynamic SQL snapshot monitoring, this counter can be reset.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Statements	event_stmt	-

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 generate a statement event record for every FETCH statement. A record event is only generated when a FETCH returns a non-zero SQLCODE.