Here are the steps to collect section actuals.
Section explains and section actuals are very powerful features to investigate problems with a query execution plan.
This invocation will create an activity event monitor and collect detailed activity information including section explain and section actuals for the specified query in .
Note that in this example, section actuals collection is also enabled, which is further explained in the section actuals section.
Section actuals permit you to see what the real cardinalities are vs. estimated cardinalities in an access plan.
This includes section data, values, actuals, etc, which are crucial during investigating a query performance issues.
These statistics are referred to as section actuals.
For more detailed information on section explain and section actuals, please visit the DB2 information Center (see Resources).
Collect section actuals for statement of interest.
