Supported Sybase ASE Configuration Parameters

Go Up to Parameters, Arguments, Options, and Variables Appendix

The following parameters are available from the Explorer’s Configuration node. For information on working with these parameters, see Working with Configuration/initialization Parameters.

SQL Perfmon Integration	SQL batch capture	abstract plan cache
abstract plan dump	abstract plan load	abstract plan replace
additional network memory	allocate max shared memory	allow backward scans
allow nested triggers	allow procedure grouping	allow remote access
allow resource limits	allow sendmsg	allow sql server async i/o
allow updates to system tables	audit queue size	auditing
average cap size	'caps per ccb	check password for digit
cis bulk insert array size	cis bulk insert batch size	cis connect timeout
cis cursor rows	cis packet size	cis rpc handling
configuration file	cpu accounting flush interval	cpu grace time'
curread change w/ open cursors	current audit table	deadlock checking period
deadlock pipe active	deadlock pipe max messages	deadlock retries
default character set id	default database size	default exp_row_size percent
default fill factor percent	default language id	default network packet size
default sortorder id	default unicode sortorder	default xml sortorder
disable character set conversions	disable disk mirroring	disk i/o structures
dtm detach timeout period	dtm lock timeout period	dump on conditions
dynamic allocation on demand	enable DTM	enable HA
enable cis	enable enterprise java beans	enable file access
enable full-text search	enable housekeeper GC	enable java
enable job scheduler	enable ldap user auth	enable metrics capture
enable monitoring	enable pam user auth	enable real time messaging
enable rep agent threads	enable row level access	enable semantic partitioning
enable snmp	enable sort-merge join and JTC	enable ssl
enable surrogate processing	enable unicode conversions	enable unicode normalization
enable webservices	enable xact coordination	enable xml
errorlog pipe active	errorlog pipe max messages	esp execution priority
esp execution stacksize	esp unload dll	event buffers per engine
event log computer name	event logging	executable codesize + overhead
extended cache size	global async prefetch limit	global cache partition number
heap memory per user	histogram tuning factor	housekeeper free write percent
i/o accounting flush interval	i/o batch size	i/o polling process count
identity burning set factor	identity grab size	job scheduler interval
job scheduler tasks	license information	lock address spinlock ratio
lock hashtable size	lock scheme	lock shared memory
lock spinlock ratio	lock table spinlock ratio	lock wait period
log audit logon failure	log audit logon success	max SQL text monitored
max async i/os per engine	max async i/os per server	max cis remote connections
max concurrently recovered db	max memory	max native threads per engine
max network packet size	max number network listeners	max online engines
max parallel degree	max repartition degree	max resource granularity
max scan parallel degree	maximum dump conditions	maximum failed logins
maximum job output	memory alignment boundary	memory per worker process
messaging memory	minimum password length	msg confidentiality reqd
msg integrity reqd	number of alarms	number of aux scan descriptors
number of ccbs	number of checkpoint tasks	number of devices
number of dtx participants	number of dump threads	number of engines at startup
number of histogram steps	number of index trips	number of java sockets
number of large i/o buffers	number of locks	number of mailboxes
number of messages	number of oam trips	number of open databases
number of open indexes	number of open objects	number of open partitions
number of pre-allocated extents	number of remote connections	number of remote logins
number of remote sites	number of sort buffers	number of user connections
number of worker processes	o/s file descriptors	object lockwait timing
open index hash spinlock ratio	open index spinlock ratio	open object spinlock ratio
optimization goal	optimization timeout limit	page lock promotion HWM
page lock promotion LWM	page lock promotion PCT	page utilization percent
partition groups	partition spinlock ratio	per object statistics active
percent database for history	percent database for output	percent history free
percent output free	performance monitoring option	permission cache entries
plan text pipe active	plan text pipe max messages	print deadlock information
print recovery information	procedure cache size	process wait events
read committed with lock	recovery interval in minutes	remote server pre-read packets
row lock promotion HWM	row lock promotion LWM	row lock promotion PCT
rtm thread idle wait period	runnable process search count	sampling percent
secure default login	select on syscomments.text	send doneinproc tokens
shared memory starting address	size of auto identity column	size of global fixed heap
size of process object heap	size of shared class heap	size of unilib cache
sql server clock tick length	sql text pipe active	sql text pipe max messages
stack guard size	stack size	start mail session
statement cache size	statement pipe active	statement pipe max messages
statement statistics active	strict dtm enforcement	suspend audit when device full
syb_sendmsg port number	sysstatistics flush interval	systemwide password expiration
tape retention in days	tcp no delay	text prefetch size
time slice	total data cache size	total logical memory
total physical memory	txn to pss ratio	unified login required
upgrade version	use security services	user log cache size
user log cache spinlock ratio	wait event timing	xact coordination interval
xp_cmdshell context