New and changed configuration parameters in Adaptive Server 15.0.2
| 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. |
| 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.