statement pipe active

Summary information

Default value

0 (off)

Range of values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Monitoring

statement pipe active controls whether Adaptive Server collects statement-level statistics. If both statement pipe active and statement pipe max messages are enabled, Adaptive Server collects the statement statistics for each query. Use monSysStatement to retrieve the statistics for all executed statements.