Parameters in this group configure user environments.
[User Environment] number of user connections = 40 stack size = DEFAULT stack guard size = DEFAULT permission cache entries = DEFAULT user log cache size = 65536 user log cache spinlock ratio = 1 max native threads per engine = DEFAULT messaging memory = DEFAULT enable real time messaging = DEFAULT histogram tuning factor = DEFAULT rtm thread idle wait period = DEFAULT
number of user connections = 40 This option sets the maximum number of user connections that can be connected to Adaptive Server at the same time. The default is 25.
user log cache size = 65536 This option specifies the size in bytes of each user’s log cache. The size of this private log cache is determined by the logical page size of the server. A large value of 65536 (65K) avoids having to write to the real log until this cache is full, which is more efficient when performing many loads.
user log cache spinlock ratio = 1 For ASE with multiple engines, this option specifies the ratio of user log caches per user log cache spinlock. There is one user log cache for each configured user connection. A value of 1 reduces contention and locking of the real log.
