DB2 Version 9.7 for Linux, UNIX, and Windows

stats_fabricate_time - Total time spent on statistics fabrication activities monitor element

The total time spent on statistics fabrications by real-time statistics gathering, in milliseconds. Statistics fabrication is the statistics collection activity needed to generate statistics during query compilation. If this monitor element is collected at the database level, it represents the total time spent on real-time statistics gathering activities for all the applications running on the database. If it is collected at the statement level, it represents the time spent on the latest real-time statistics gathering activities for the statement. The times reported by all the database partitions are aggregated together.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Statement
Dynamic SQL	dynsql	Statement

For snapshot monitoring, this element can be reset.

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Database	event_db	-
Statement	event_stmt	-

Usage

Use this element along with stats_fabrications to evaluate the performance impact of real-time statistics gathering at the database level. For snapshot monitor for dynamic SQL, you can use this element along with total_exec_time and num_executions to evaluate the impact of statistics fabrications. For the statement event monitor, you can combine this element with stmt_start and stmt_stop for further evaluation of real-time statistics gathering impact.