DB2 Version 9.7 for Linux, UNIX, and Windows

sp_rows_selected - Rows Returned by Stored Procedures monitor element

This element contains the number of rows sent from the data source to the federated server at the start of the federated server instance, or the last reset of the database monitor counters as a result of stored procedure operations for this application.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase_remote	Basic
Application	appl_remote	Basic

For snapshot monitoring, this counter can be reset.

Usage

This element has several uses. You can use it to compute the average number of rows sent to the federated server from the data source, per stored procedure, with the following formula:

    rows per stored procedure 
  = rows returned 
  / # of stored procedures invoked

You can also compute the average time to return a row to the federated server from the data source for this application:

  average time = aggregate stored proc. response time / rows returned