DB2 Version 9.7 for Linux, UNIX, and Windows

stored_procs - Stored Procedures monitor element

This element contains a count of the total number of stored procedures from the start of the federated server instance, or the last reset of the database monitor counters, that the federated server has called at this data source on behalf of any 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: Use this element to determine how many stored procedure calls were made locally at the federated database or by an application against the federated database.