Changes to configuration parameters

Table 2-2 summarizes changes to existing configuration parameters.

**Table 2-2: Changed configuration parameters**
Parameter	Change
procedure cache percent	Removed from Adaptive Server version 12.5. You now determine the size of the procedure cache with procedure cache size.
total memory	Displays the total logical memory for the current configuration of Adaptive Server
size of process object heap	Now a server-wide setting and not assigned to a specific task.
max cis remote connections	Removed from Adaptive Server version 12.5. The max number is now determined by the max number of file descriptors available to a single process for a given operating system

Table 2-3 lists the configuration parameters that were static, but are now dynamic.

**Table 2-3: Configuration parameters changed from static to dynamic**
Configuration parameter	Configuration parameter
addition network memory	number of pre-allocated extents
audit queue size	number of user connections
cpu grace time	number of worker processes
deadlock pipe max messages	open index hash spinlock ratio
default database size	open index spinlock ratio
default fill factor percent	open object spinlock ratio
disk i/o structures	partition groups
errorlog pipe max messages	partition spinlock ratio
max cis remore connections	permission cache entries
memory per worker process	plan text pipe max messages
number of alarms	print recovery information
number of aux scan descriptors	process wait events
number of devices	size of global fixed heap
number of dtx participants	size of process object heap
number of java sockets	size of shared class heap
number of large i/o buffers	size of unilib cache
number of locks	sql text pipe max messages
number of mailboxes	statement pipe max messages
number of messages	tape retention in days
number of open databases	time slice
number of open indexes	user log cache spinlock ratio
number of open objects