DB2 Version 10.1 for Linux, UNIX, and Windows

section_actuals - Section actuals configuration parameter

This parameter enables collection of section actuals (runtime statistics that are measured during section execution) such that the statistics can be viewed when an event monitor is subsequently created.

Configuration type

Database

Applies to

Database server with local and remote clients
Database server with local clients
Partitioned database server with local and remote clients

Parameter type

Configurable online

Propagation class

Unit of work boundary

Default [range]

NONE [NONE, BASE]

The following values are valid for this parameter:

NONE

Specifies that collection of section actuals is disabled.

BASE

Specifies that measurement is enabled and the following statistics are collected:

Basic operator cardinality counts
Statistics for each object that is referenced during section execution (DML statements only)

After section actuals are enabled, capture section actuals by using an activity event monitor and view them through a section explain that you perform by using the EXPLAIN_FROM_ACTIVITY procedure.

You cannot enable this parameter if the auto_stats_prof database configuration parameter is enabled (SQLCODE -5153).