STATISTICS FEEDBACK field (STATFDBK_SCOPE subsystem parameter)
The STATFDBK_SCOPE subsystem parameter specifies the scope of the SQL statements that Db2 collects statistics recommendations for in the SYSIBM.SYSSTATFEEDBACK catalog table.
| Acceptable values: | ALL, DYNAMIC, NONE, or STATIC |
|---|---|
| Default: | ALL |
| Update: | option 24 on panel DSNTIPO |
| DSNZPxxx: | DSN6SPRM STATFDBK_SCOPE |
- NONE
- No statistics recommendations are collected in the catalog table.
- DYNAMIC
- Statistics recommendations are collected in the catalog table for dynamic SQL statements only.
- STATIC
- Statistics recommendations are collected in the catalog table for static SQL statements only.
- ALL
- Statistics recommendations are collected in the catalog table for all SQL Statements.