DB2 Version 9.7 for Linux, UNIX, and Windows

xquery_stmts - XQuery Statements Attempted monitor element

The number of XQuery statements executed for an application or database.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic
Application	appl	Basic

For snapshot monitoring, this counter can be reset.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-
Connection	event_conn	-

Usage: You can use this element to gauge the activity of native XQuery language requests. This does not include embedded XQuery language requests such as xmlquery, xmltable, or xmlexist.