New and changed configuration parameters

deadlock pipe active

Controls whether Adaptive Server collects deadlock messages.

deadlock pipe max messages

Determines the number of deadlock messages Adaptive Server stores.

enable monitoring

Controls whether Adaptive Server collects the monitoring table data.

errorlog pipe active

Controls whether Adaptive Server collects error log messages.

errorlog pipe max messages

Determines the number of error log messages Adaptive Server stores.

max sql text monitored

Specifies the total number of bytes Adaptive Server allocates for each user task to store SQL text.

object lockwait timing

Controls whether Adaptive Server collects timing statistics for requests of locks on objects.

per object statistics active

Controls whether Adaptive Server collects statistics for each object.

plan text pipe active

Determines whether Adaptive Server collects query plan text.

plan text pipe max messages

Determines the number of query plan text messages Adaptive Server stores.

process wait events

Controls whether Adaptive Server collects statistics for each wait event for every task.

sql text pipe active

Controls whether Adaptive Server collects SQL text.

sql text pipe max messages

Specifies the number of SQL text messages Adaptive Server stores.

statement pipe active

Controls whether Adaptive Server collects statement-level statistics.

statement pipe messages

Determines the number of statement statistics messages Adaptive Server stores.

statement statistics active

Controls whether Adaptive Server collects the monitoring table statement-level statistics.

sql batch capture

Controls whether Adaptive Server collects SQL text.

wait event timing

Controls whether Adaptive Server collects statistics for indiviual wait events.

enable housekeeper GC

Provides these parameter values:

• 0 – disables the housekeeper garbage collection task.

• 1 – enables lazy garbage collection.

• 2 – reserved for future use.

• 3 – reserved for future use.

• 4 – enables aggressive garbage collection for both the housekeeper garbage collection task and the delete command.

• 5 – enables aggressive garbage collection for the housekeeper garbage collection task, and lazy garbage collection by the delete command.