Configuration Parameters

New and changed configuration parameters in Adaptive Server 15.0.2

New configuration parameters
Configuration parameter Description
enable merge join Enables or disables merge joins at the server level.
cost of a logical io Specifies the cost of a single logical IO.
cost of a physical io Specifies the cost of a single physical IO.
cost of a cpu unit Specifies the cost of a single CPU operation.
enable encrypted columns Enables and disables the encrypted columns feature when encrypted columns is licensed.
max online q engines Required for MQ series, max online q engines specifies the maximum number of Q engines allowed online.
metrics elap max If the elapsed time of the query is less than the value of metrics elap max, then the metrics associated with the query are not written to the system tables. enable metrics capture must be on.
metrics exec max If the execution time of the query is less than the value of metrics exec max, then the metrics associated with the query are not written to the system tables. enable metrics capture must be on.
metrics lio max If the logical IO time of the query is less than the value of metrics lio max, then the metrics associated with the query are not written to the system tables. enable metrics capture must be on.
metrics pio max If the physical IO time of the query is less than the value of metrics pio max, then the metrics associated with the query are not written to the system tables. enable metrics capture must be on.
min pages for parallel scan Lets you scan larger queries in parallel.
not password encryption read Requires all incoming login authentication requests using Adaptive Server authentication to encrypt the login password when transmitted on the network.
number of Q engines at startup Required for MQ series, specifies the maximum number of Q engines you can have online.
prod-consumer overlap factor Affects optimization. Adaptive Server changes the group by algorithm, and you cannot use set statistics IO with parallel plans.
send doneinproc tokens Replaces the dbcc tune option doneinproc.

Changed configuration parameters
Configuration parameter Description of change
max async i/os per engine The default value has changed from 2147483647 to 1024.
maximum failed logins The new -1 value indicates that the failed login count in the syslogins column logincount is updated whenever an authentical failure occurs, but that the account is not locked.
print deadlock information Adds a new parameter value of 2, which lets you print a summary of deadlock information to the error log.

See the Reference Manual: Tables.