New and changed configuration parameters

This section describes the new and changed configuration parameters in version 12.0.

Table 6-1 summarizes the new configuration parameters.

Table 6-1: New configuration parameters

Parameter

Function

check password for digit

Sets the server to check for at least one character or digit in a password.

dtm detach timeout period

Sets the maximum amount of time that detached transactions remain active in Adaptive Server.

dtm lock timeout period

Sets the maximum amount of time, in seconds, that a distributed transaction branch waits for lock resources to become available.

enable dtm

Enables or disables the Distributed Transaction Management feature.

enable HA

Enables Adaptive Server to be configured for Sybase’s Failover in a high availability system.

enable java

Enables or disables Java on the server.

enable xact coordination

Enables or disables Adaptive Server distributed transaction coordination services.

maximum failed logins

Sets the server-wide maximum number of login attempts for logins and roles.

minimum password length

Specifies a server-wide value for minimum password length for both logins and roles.

number of dtx participants

Sets the total number of remote transactions that the Adaptive Server transaction coordination service can propagate and coordinate at one time.

size of global fixed heap

Specifies the memory space for internal data structures.

size of process object fixed heap

Specifies the memory space for the Java VM for Java objects referenced during a session.

size of shared class heap

Specifies the shared memory space for all Java classes called into the Java VM.

strict dtm enforcement

Determines whether or not Adaptive Server transaction coordination services will strictly enforce the ACID properties of distributed transactions.

text prefetch size

Limits the number of pages of text and image data that can be prefetched into an existing buffer pool.

txn to pss ratio

Determines the total number of transaction descriptors available to the server.

xact coordination level

Defines the length of time between attempts to resolve transaction branches that were propagated to remote servers.

Table 6-2 summarizes the changes to existing configuration parameters.

Table 6-2: Changed configuration parameters

Parameter

Change

enable cis

The default value has been changed from 0 (off) to 1 (on).