New and changed configuration parameters

Table 3-3 summarizes the new configuration parameters in version 12.5.0.3.

**Table 3-3: New configuration parameters**
Parameter	Function
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.

Table 3-4 summarizes changed configuration parameters in 12.5.0.3.

**Table 3-4: Changed configuration parameters**
Parameter	Changes
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.