This section describes the new and changed configuration parameters in version 12.5.
Table 5-2 summarizes the new configuration parameters.
Parameter |
Function |
---|---|
allocate max shared memory |
Determines whether Adaptive Server allocates all the memory specified by max memory at start-up or only the amount of memory the configuration parameter requires. |
cis bulk insert array size |
Controls the size of the array when performing a bulk transfer of data from one Adaptive Server to another. During the transfer, CIS buffers rows internally, and asks the Open Client bulk library to transfer them as a block. |
dynamic allocation on demand |
Determines when memory is allocated for changes to dynamic memory configuration parameters. |
enable enterprise java beans |
Enables or disables the EJB Server. |
enable file access |
Enables or disables access through proxy tables to the External File System. Requires a license for ASE_XFS. |
enable full-text search |
Enables or disables Enhances Full-Text Search services. Requires a license for ASE_EFTS. |
enable row level access control |
Enables or disables row-level access control. |
enable ssl |
Enables or disables Secure Sockets Layer session-based security. |
enable surrogate processing |
Enables or disables the processing and maintains the integrity of surrogate pairs in Unicode data. |
enable unicode normalization |
Enables or disables Unilib character normalization. |
heap memory per user |
Specifies the heap memory per user for Adaptive Server. |
max memory |
Specifies the maximum amount of total logical memory that you can configure Adaptive Server to allocate. |
number of engines at startup |
Specifies the number of engines that are brought online at start-up. This replaces the minimum online engines parameter. |
number of java sockets |
Specifies the maximum amount of total physical memory that you can configure Adaptive Server to allocate. |
procedure cache size |
Specifies the size of the procedure cache in 2K pages. |
total logical memory |
Specifies the amount of memory that Adaptive Server is configured to use. |
total physical memory |
Displays the amount of memory that is being used by Adaptive Server at a given moment in time. |
Table 5-3 summarizes changes to existing 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 maximum number is now determined by the maximum number of file descriptors available to a single process for a given operating system. |
Table 5-4 lists the configuration parameters that were static, but are now 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 |