DB2 Version 9.7 for Linux, UNIX, and Windows

total_olap_funcs - Total OLAP Functions monitor element

The total number of OLAP functions executed.

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

At the database or application level, use this value in conjunction with olap_func_overflows to determine if a significant percentage of OLAP functions would benefit from modest increases in the sort heap size.