Alphabetical Listing of Configuration Parameters

Parameter descriptions include both summary and detailed information about each configuration parameter.

• abstract plan cache
  abstract plan cache enables caching of abstract plan hash keys.
• abstract plan dump
  abstract plan dump enables the saving of abstract plans to the ap_stdout abstract plans group.
• abstract plan load
  abstract plan load enables association of queries with abstract plans in the ap_stdin abstract plans group.
• abstract plan replace
  abstract plan replace enables plan replacement for abstract plans in the ap_stdout abstract plans group.
• abstract plan sharing
  abstract plan sharing enables abstract plan sharing between different users.
• additional network memory
  additional network memory sets the amount of additional memory allocated to the network memory pool.
• aggresive task stealing
  aggressive task stealing sets the SAP ASE scheduler task stealing policy to aggressive.
• allocate max shared memory
  allocate max shared memory determines whether SAP ASE allocates all the memory specified by max memory at start-up, or only the amount of memory the configuration parameter requires.
• allow backward scans
  allow backward scans controls how the optimizer performs select queries that contain the order by...desc command.
• allow nested triggers
  allow nested triggers controls the use of nested triggers.
• allow procedure grouping
  allow procedure grouping controls the ability to group stored procedures of the same name so that they can be dropped with a single drop procedure statement.
• allow remote access
  allow remote access controls logins from remote SAP ASEs. The default value of 1 allows SAP ASE to communicate with Backup Server.
• allow resource limits
  allow resource limits controls the use of resource limits.
• allow sendmsg
  allow sendmsg enables or disables sending messages from SAP ASE to a User Datagram Protocol (UDP) port.
• allow sql server async i/o
  allow sql server async i/o enables SAP ASE to run with asynchronous disk I/O.
• allow updates to system tables
  allow updates to system tables enables users with the system administrator role to make changes to the system tables and to create stored procedures that can modify system tables.
• average cap size
  average cap size is reserved for future use.
• audit queue size
  audit queue size determines the size of an audit queue. The in-memory audit queue holds audit records generated by user processes until the records can be processed and written to the audit trail.
• auditing
  auditing enables or disables auditing for SAP ASE.
• automatic cluster takeover
  automatic cluster takeover determines whether an instance automatically recovers from a cluster failure. Setting automatic cluster takeover to 1 allows an instance that is starting to automatically recover from an abrupt total cluster failure.
• builtin date strings
  builtin date strings determines if the server interprets strings given to chronological builtins as bigdatetimes. If a string is given as an argument in place of the chronological value, the server interprets it as a datetime value regardless of its apparent precision.
• caps per ccb
  caps per ccb is reserved for future use.
• capture compression statistics
  capture compression statistics enables the monTableCompression monitoring table to begin capturing compression statistics.
• capture missing statistics
  capture missing statistics enables or disables SAP ASE to capture information about columns that have missing statistics.
• check password for digit
  check password for digit enables or disables checking for at least one character or digit in a password. If set, this parameter does not affect existing passwords.
• CIPC large message pool size
  CIPC large message pool size specifies the number of large message buffers allocated by CIPC at start-up time.
• CIPC regular message pool size
  CIPC regular message pool size specifies the number of regular message buffers allocated by CIPC at start-up time.
• cis bulk insert array size
  cis bulk insert array size determines the size of the array CIS internally buffers (and asks the Open Client bulk library to transfer as a block) when performing a bulk transfer of data from one SAP ASE to another SAP ASE.
• cis bulk insert batch size
  cis bulk insert batch size determines how many rows from the source tables are to be bulk copied into the target table as a single batch using select into.
• cis connect timeout
  cis connect timeout determines the wait time, in seconds, for a successful Client-Library connection.
• cis cursor rows
  cis cursor rows specifies the cursor row count for cursor open and cursor fetch operations. Increasing this value means more rows are fetched in one operation, which increases speed but requires more memory.
• cis idle connection timeout
  cis idle connection timeout configures SAP ASE to check for CIS connections to any remote server that have been unused longer than the specified number of seconds. SAP ASE deletes the unused connections and reallocates their resources.
• cis packet size
  cis packet size specifies the size of Tabular Data Stream™ (TDS) packets that are exchanged between the server and a remote server when a connection is initiated.
• cis rpc handling
  cis rpc handling specifies the default method for remote procedural call (RPC) handling.
• cluster heartbeat interval
  cluster heartbeat interval controls the interval that cluster instances use to send and check the heartbeat status.
• cluster heartbeat retries
  cluster heartbeat retries controls the number of times an instance retries a failed cluster heartbeat before entering failure mode.
• cluster redundancy level
  cluster redundancy level (CRL) controls the number of recoverable failed instances in a shared-disk cluster. It is the maximum number of instances that can fail simultaneously while allowing recovery to proceed concurrently with other activity.
• cluster vote timeout
  cluster vote timeout controls the maximum amount of time an instance waits for other instances to vote during the voting period. An instance waits only for those instances which it believes are running.
• column default cache size
  column defult cache size determines the size of the cache that SAP ASE must keep in memory to provide defaults for nonmaterialized columns.
• compression info pool size
  compression info pool size determines the size of the memory pool used for compression.
• compression memory size
  compression memory size determines the size (in 2KB pages) of the memory pool SAP ASE uses to decompress a compressed dump. SAP ASE uses the value for compression memory size while loading a compressed dump into an archive database.
• configuration file
  configuration file specifies the location of the configuration file currently in use.
• cost of a logical io
  cost of a logical io specifies the cost of a single logical I/O.
• cost of a physical io
  cost of a phsyical io specifies the cost of a single physical I/O.
• cost of a cpu unit
  cost of a cpu unit specifies the cost of a single CPU operation.
• cpu accounting flush interval
  cpu accounting flush interval specifies the amount of time, in machine clock ticks (non-SAP ASE clock ticks), that SAP ASE waits before flushing CPU usage statistics for each user from sysprocesses to syslogins, a procedure used in charge-back accounting.
• cpu grace time
  cpu grace time, together with time slice, specifies the maximum amount of time that a user process can run without yielding the CPU before SAP ASE preempts it and terminates it with a timeslice error.
• current audit table
  current audit table establishes the table where SAP ASE writes audit rows.
• deadlock checking period
  deadlock checking period specifies the minimum amount of time (in milliseconds) before SAP ASE initiates a deadlock check for a process that is waiting on a lock to be released.
• deadlock pipe active
  deadlock pipe active controls whether SAP ASE collects deadlock messages.
• deadlock pipe max messages
  deadlock pipe max messages determines the number of deadlock messages SAP ASE stores per engine.
• deadlock retries
  deadlock retries specifies the number of times a transaction can attempt to acquire a lock when deadlocking occurs during an index page split or shrink.
• default character set id
  default character set id specifies the number of the default character set used by the server.
• default database size
  default database size sets the default number of megabytes allocated to a new user database if create database is issued without any size parameters.
• default exp_row_size percent
  default exp_row_size percent reserves space for expanding updates in data-only-locked tables, to reduce row forwarding.
• default fill factor percent
  default fill factor percent determines how full SAP ASE makes each index page when it is creating a new index on existing data, unless the fill factor is specified in the create index statement.
• default language id
  default language id is the number of the language that is used to display system messages unless a user has chosen another language from those available on the server. us_english always has an ID of NULL.
• default network packet size
  default network packet size configures the default packet size for all SAP ASE users.
• default sortorder id
  default sortorder id is the number of the sort order that is installed as the default on the server.
• default unicode sortorder
  default unicode sortorder is a string parameter that uniquely defines the default Unicode sort order installed on the server.
• default XML sortorder
  default XML sortorder is a string parameter that defines the sort order used by the XML engine. A string parameter is used rather than a numeric parameter to guarantee a unique ID.
• deferred name resolution
  deferred name resolution determines whether deferred name resolution is applied globally to server connections.
• disable character set conversions
  disable character set conversions enables or disables character set conversion for data moving between clients and SAP ASE.
• disable disk mirroring
  disable disk mirroring enables or disables disk mirroring for SAP ASE.
• disable jsagent core dump
  disable jsagent core dump enables or disables JS Agent core dumps.
• disable varbinary truncation
  disable varbinary truncation controls whether SAP ASE includes trailing zeros at the end of varbinary or binary null data.
• disk i/o structures
  disk i/o structures specifies the initial number of disk I/O control blocks SAP ASE allocates at start-up.
• DMA object pool size
  DMA object pool size specifies the number of DMA (direct memory access) objects allocated by CIPC at start-up time.
• dtm detach timeout period
  dtm detach timeout period sets the amount of time, in minutes, that a distributed transaction branch can remain in the detached state.
• dtm lock timeout period
  dtm lock timeout period sets the maximum amount of time, in seconds, that a distributed transaction branch waits for lock resources to become available.
• dump history filename
  dump history filename specifies the path and name of your dump history file.
• dump on conditions
  dump on conditions determines whether SAP ASE generates a dump of data in shared memory when it encounters the conditions specified in maximum dump conditions.
• dynamic allocation on demand
  dynamic allocation on demand determines when memory is allocated for changes to dynamic memory configuration parameters.
• dynamic SQL plan pinning
  dynamic SQL plan pinning improves performance by reducing the time spent by server connections waiting for access to the query plan manager.
• early row send increment
  early row send increment configures the additional number of rows sent in the second and subsequent packets of a result set (subject to the maximum packet size).
• enable async database init
  enable async database init ensures that all create database and alter database commands initialize databases asynchronously by default
• enable backupserver HA
  enable backupserver HA enables or disables the high availability Backup Server for the cluster.
• enable cis
  enable cis enables or disables Component Integration Service.
• enable compression
  enable compression enables or disables data compression.
• enable concurrent dump tran
  enable concurrent dump tran enables or disables SAP ASE to use concurrent dumps.
• enable console logging
  enable console logging determines whether SAP ASE sends messages to the console.
• enable DTM
  enable DTM enables or disables the SAP ASE distributed transaction management (DTM) feature.
• enforce dump configuration
  enforce dump configuration enables dump operations to use a dump configuration.
• enable dump history
  dump history update determines whether there are updates to the dump history file at the end of the database dump operation.
• enable encrypted columns
  enable encrypted columns enables and disables encrypted columns.
• enable enterprise java beans
  enable enterprise java beans enables and disables EJB Server in the SAP ASE database.
• enable file access
  enable file access enables access through proxy tables to the external file system.
• enable full-text search
  enable full-text search enables Enhanced Full-Text Search services.
• enable functionality group
  enable functionality group enables or disables the changes available for specific SAP ASE version 15.7 and later features.
• enable inline default sharing
  enable inline default sharing enables SAP ASE to share inline defaults.
• enable HA
  enable HA enables or disables SAP ASE as a companion server in an active-active high availability subsystem.
• enable housekeeper GC
  enable housekeeper GC configures the housekeeper task.
• enable hp posix async i/o
  enable hp posix async i/o enables or disables asynchronous I/O on database devices created on on HP-UX 11.31 and later file systems.
• enable HugePages
  enable HugePages enables and disables the use of huge pages on Linux platforms that support huge pages.
• enable i/o fencing
  enable i/o fencing enables or disables I/O fencing for each database device that supports the SCSI-3 Persistent Group Reservation (PGR) standard.
• enable ISM
  enable ISM enables and disables SAP ASE to use integrated service management (ISM) on the Solaris platform.
• enable java
  enable java enables and disables Java in the SAP ASE database. You cannot install Java classes or perform any Java operations until the server is enabled for Java.
• enable job scheduler
  enable job scheduler determines whether Job Scheduler starts when Adaptive Server starts.
• enable js restart logging
  enable js restart logging enables or disables diagnostics logging after the restart of Job Scheduler.
• enable large chunk elc
  enable large chunk elc enables or disables large allocation in the engine local cache.
• enable large pool for load
  enable large pool for load configures the use of large buffer pools during the recovery phase for load database and load transaction commands.
• enable ldap user auth
  enable ldap user auth enables or disables SAP ASE to authenticate each user on the LDAP server.
• enable literal autoparam
  enable literal autoparam enables and disables literal server-wide parameterization.
• engine local cache percent
  engine local cache percent enables or disables modification of the Engine Local Cache (ELC) as a percentage of procedure cache.
• enable logins during recovery
  enable logins during recovery determines whether non-system administrator logins are allowed during database recovery.
• enable merge join
  enable merge join enables or disables merge join at the server level.
• enable metrics capture
  enable metrics capture enables SAP ASE to capture metrics at the server level.
• enable monitoring
  enable monitoring controls whether SAP ASE collects the monitoring table data.
• enable pam user auth
  enable pam user auth controls the ability to authenticate users using pluggable authentication modules (PAM).
• enable pci
  enable pci enables or disables the Java PCI Bridge for SAP ASE.
• enable permissive unicode
  enable permissive unicode enables or disables SAP ASE to ignore Unicode noncharacters.
• enable plan sharing
  enable plan sharing enables or disables SAP ASE to use shared query plans.
• enable predicated privileges
  enable predicated privileges enables or disables predicated privileges.
• enable query tuning mem limit
  enable query tuning mem limit enables or disables the query tuning memory limit.
• enable query tuning time limit
  enable query tuning time limit enables or disables the query tuning time limit.
• enable rapidlog
  enable rapidlog enables the capture of diagnostic for 'Proc Cache Header' memory pool messages.
• enable real time messaging
  enable real time messaging enables or disables the real time messaging services.
• enable rep agent threads
  enable rep agent threads enables or disables the RepAgent thread within SAP ASE.
• enable row level access control
  enable row level access control enables or disables row level access control.
• enable semantic partitioning
  enable semantic partitioning enables or disables partitioning other than round-robin (for example list, hash, and range partitioning) in SAP ASE.
• enable sort-merge join and JTC
  enable sort-merge join and JTC enables or disables the query processor to select a sort merge or a nested loop join when SAP ASE compiles a query in compatibility mode.
• enable sql debugger
  enable sql debugger enables or disables the SAP ASE SQL debugger, which allows you to step through your T-SQL code.
• enable ssl
  enable ssl enables or disables Secure Sockets Layer session-based security.
• enable stmt cache monitoring
  enable stmt cache monitoring enables or disables SAP ASE to collect monitoring information about the statement cache.
• enable surrogate processing
  enable surrogate processing enables or disables the processing and maintains the integrity of surrogate pairs in Unicode data.
• enable unicode conversion
  enable unicode conversion enables or disables character conversion using Unilib for the char, varchar, and text datatypes.
• enable unicode normalization
  enable unicode normalization enables or disables Unilib character normalization.
• enable utility lvl 0 scan wait
  enable utility lvl 0 scan wait enables or disables running alter table ... add | drop partition commands while Adaptive Server runs isolation level 0 scans.
• enable webservices
  enable webservices enables or disables Webservices.
• enable xact coordination
  enable xact coordination enables or disables SAP ASE transaction coordination services.
• enable xml
  enable xml enables or disables XML services.
• engine memory log size
  engine memory log size is for diagnostic use only and has no relevance in a production environment.
• errorlog pipe active
  errorlog pipe active controls whether SAP ASE collects error log messages.
• errorlog pipe max messages
  errorlog pipe max messages determines the number of error log messages SAP ASE stores per engine.
• esp execution priority
  esp execution priority sets the priority of the XP Server thread for ESP execution.
• esp execution stacksize
  esp execution stacksize sets the size of the stack, in bytes, to be allocated for ESP execution.
• esp unload dll
  esp unload dll specifies whether DLLs that support ESPs should be automatically unloaded from XP Server memory after the ESP call has completed.
• event buffers per engine
  Controls the number of monitor event buffers.  Not used in the current version of SAP ASE.
• event log computer name (Windows only)
  event log computer name specifies the name of the Windows machine that logs SAP ASE messages in its Windows Event Log. This feature is available on Windows servers only.
• event logging
  (Windows servers only)event logging enables and disables the logging of SAP ASE messages in the Windows Event Log.
• executable codesize + overhead
  executable codesize + overhead reports the combined size, in kilobytes, of the SAP ASE executable and overhead.
• extended cache size
  extended cache size specifies the size of the secondary cache.
• FIPS login password encryption
  FIPS login password encryption provides FIPS 140-2 cryptographic module support for encrypting passwords in transmission, in memory, and on disk.
• global async prefetch limit
  global async prefetch limit specifies the percentage of a buffer pool that can hold the pages brought in by asynchronous prefetch that have not yet been read.
• global cache partition number
  global cache partition number sets the default number of cache partitions for all data caches.
• heap memory per user
  heap memory per user configures the amount of heap memory per user. A heap memory pool is an internal memory created at start-up that tasks use to dynamically allocate memory as needed.
• histogram tuning factor
  histogram tuning factor controls the number of steps SAP ASE analyzes per histogram for update statistics, update index statistics, update all statistics, and create index.
• housekeeper free write percent
  housekeeper free write percent specifies the maximum percentage by which the housekeeper wash task can increase database writes.
• i/o accounting flush interval
  i/o accounting flush interval specifies the amount of time, in machine clock ticks, that SAP ASE waits before flushing I/O statistics for each user from sysprocesses to syslogins. This is used for charge-back accounting.
• i/o batch size
  i/o batch size sets the number of writes issued in a batch before the task goes to sleep. Once this batch is completed, the task is woken up, and the next batch of writes are issued, ensuring that the I/O subsystem is not flooded with many simultaneous writes.
• i/o polling process count
  i/o polling process count specifies the maximum number of processes that SAP ASE can run before the scheduler checks for disk and network I/O completions. Tuning i/o polling process count affects both the response time and throughput of SAP ASE.
• identity burning set factor
  identity burning set factor changes the percentage of potential column values that is made available in a block of column values.
• identity grab size
  identity grab size allows each SAP ASE process to reserve a block of IDENTITY column values for inserts into tables that have an IDENTITY column.
• identity reservation size
  identity reservation size sets a limit for the number of identity values.
• idle migration timeout
  idle migration timeout specifies the amount of time after which an idle connection is closed without invalidating the migration request sent to the client, allowing you to stop an instance after a specified period of time without waiting for idle client connections to migrate.
• job scheduler interval
  job scheduler interval sets the interval when the Job Scheduler checks which scheduled jobs are due to be executed.
• job scheduler tasks
  job scheduler tasks sets the maximum number of jobs that can run simultaneously through Job Scheduler.
• js heartbeat interval
  Specifies the intervals between two JS Agent heartbeat checks, in minutes
• js job output width
  js job output width determines the line width the output uses for jobs stored in the js_output table.
• kernel mode
  kernel mode determines the mode the SAP ASE kernel uses, threaded or process.
• kernel resource memory
  kernel resource memory determines the size, in 2K pages, of the kernel resource memory pool from which all thread pools and other kernel resources are allocated memory.
• large allocation auto tune
  large allocation auto tune configures SAP ASE preallocate large amounts of memory for query execution, which reduces procedure cache contention.
• license information
  license information allows SAP system administrators to monitor the number of user licenses used in SAP ASE. Enabling this parameter only monitors the number of licenses issued; it does not enforce the license agreement.
• lock address spinlock ratio
  address lock spinlock ratio sets the number of rows in the internal address locks hash table that are protected by one spinlock for SAP ASEs running with multiple engines.
• lock hashtable size
  lock hashtable size specifies the number of hash buckets in the lock hash table.
• lock scheme
  lock scheme sets the default locking scheme to be used by create table and select into commands when a lock scheme is not specified in the command.
• lock shared memory
  lock shared memory disallows swapping of SAP ASE pages to disk and allows the operating system kernel to avoid the server’s internal page locking code. This can reduce disk reads, which are expensive.
• lock spinlock ratio
  For SAP ASEs running with multiple engines, lock spinlock ratio sets a ratio that determines the number of lock hash buckets that are protected by one spinlock. If you increase the value for lock hashtable size, the number of spinlocks increases, so the number of hash buckets protected by one spinlock remains the same.
• lock table spinlock ratio
  For SAP ASEs running with multiple engines, table lock spinlock ratio sets the number of rows in the internal table locks hash table that are protected by one spinlock.
• lock timeout pipe active
  lock timeout pipe active controls whether SAP ASE collects lock timeout messages.
• lock timeout pipe max messages
  lock timeout pipe max messages controls the maximum number of rows per engine in the lock timeout pipe, which determines the maximum number of rows that can be returned by the monLockTimeout monitoring table.
• lock wait period
  lock wait period limits the number of seconds that tasks wait to acquire a lock on a table, data page, or data row. If the task does not acquire the lock within the specified time period, SAP ASE returns error message 12205 to the user and rolls back the transaction.
• log audit logon failure
  log audit logon failure specifies whether to log unsuccessful SAP ASE logins to the SAP ASE error log and, on Windows servers, to the Windows Event Log, if event logging is enabled.
• log audit logon success
  log audit logon success specifies whether to log successful SAP ASE logins to the SAP ASE error log and, on Windows servers, to the Windows Event Log, if event logging is enabled.
• max async i/os per engine
  max async i/os per engine specifies the maximum number of outstanding asynchronous disk I/O requests for a single engine at one time.
• max async i/os per server
  max async i/os per server specifies the maximum number of asynchronous disk I/O requests that can be outstanding for SAP ASE at one time.
• max buffers per lava operator
  max buffers per lava operator sets an upper limit for the number of buffers used by lava operators that perform sorting or hashing (which are “expensive” in terms of processing). Lava operators use buffers from the session’s tempdb data cache pool as a work area for processing rows.
• max cis remote connections
  max cis remote connections specifies the maximum number of concurrent Client-Library connections that can be made to remote servers by Component Integration Services.
• max concurrently recovered db
  max concurrently recovered db determines the degree of parallelism.
• max js restart attempts
  Restricts the number of restart attempts and prevents the Job Scheduler restart feature from going into an infinite loop.
• max memory
  max memory specifies the maximum amount of total physical memory that you can configure SAP ASE to allocate. max memory must be greater than the total logical memory consumed by the current configuration of SAP ASE.
• max native threads per engine
  max native threads per engine defines the maximum number of native threads the server spawns per engine.
• max nesting level
  maximum nesting level sets the maximum nesting level for stored procedures and triggers. Each increased nesting level requires about 160 bytes of additional memory. For example, if you increase the nesting level from 16 to 26, SAP ASE requires an additional 1600 bytes of memory.
• max network packet size
  max network packet size specifies the maximum network packet size that can be requested by clients communicating with SAP ASE.
• max network peek depth
  (UNIX only) max network peek depth specifies how many levels deep SAP ASE peeks into a connections operating system receive buffer for a pending cancel.
• max number network listeners
  max number network listeners specifies the maximum number of network listeners allowed by SAP ASE at one time.
• max online engines
  max online engines places an upper limit of the number of engine threads that can be brought online. It does not take into account the number of CPUs available at start-up, and allows users to add CPUs at a later date.
• max online Q engines
  (Process mode only) max online Q engines specifies the maximum number of Q engines you can have online, and is required for MQ (see the Active Messaging Users Guide).
• max parallel degree
  max parallel degree specifies the server-wide maximum number of worker processes allowed per query. This is called the “maximum degree of parallelism.”
• max pci slots
  max pci slots sets the maximum number of PCI slots SAP ASE allows.
• max query parallel degree
  (Used when SAP ASE is in compatibility mode) Defines the number of worker processes to use for a given query.
• max repartition degree
  max repartition degree configures the amount of dynamic repartitioning SAP ASE requires, which enables SAP ASE to use horizontal parallelism. However, if the number of partitions is too large, the system is flooded with worker processes that compete for resources, which degrades performance.
• max resource granularity
  max resource granularity indicates the maximum percentage of the system’s resources a query can use.
• max scan parallel degree
  max scan parallel degree specifies the server-wide maximum degree of parallelism for hash-based scans.
• max SQL text monitored
  max SQL text monitored specifies the amount of memory allocated per user connection for saving SQL text to memory shared by Adaptive Server Monitor.
• max transfer history
  max transfer history controls how many transfer history entries SAP ASE retains in the spt_TableTransfer table in each database.
• max utility parallel degree
  max util parallel degree specifies the server-wide maximum number of worker processes allowed per query used by the create index with consumers and update stats with consumers commands.
• maximum dump conditions
  maximum dump conditions sets the maximum number of conditions you can specify under which SAP ASE generates a dump of data in shared memory.
• maximum failed logins
  maximum failed logins allows you to set the server-wide maximum number of failed login attempts for logins and roles.
• maximum job output
  maximum job output sets limit, in bytes, on the maximum output a single job can produce.
• memory alignment boundary
  memory alignment boundary determines the memory address boundary on which data caches are aligned.
• memory dump compression level
  memory dump compression level controls the compression level for shared memory dumps.
• memory per worker process
  memory per worker process specifies the amount of memory, in bytes, used by worker processes.
• messaging memory
  messaging memory configures the amount of memory available for SAP messaging.
• metrics elap max
  metrics elap max configures maximum elapsed time and thresholds for QP metrics
• metrics exec max
  metrics exec max configures maximum execution time and thresholds for QP metrics.
• metrics lio max
  metrics lio max configures maximum logical I/O and thresholds for QP metrics.
• metrics pio max
  metrics pio max configures maximum physical I/O and thresholds for QP metrics.
• min pages for parallel scan
  min pages for parallel scan controls the number of tables and indexes that SAP ASE can access in parallel.
• minimum password length
  minimum password length allows you to customize the length of server-wide password values or per-login or per-role password values.
• mnc_full_index_filter
  mnc_full_index_filter prevents SAP ASE from considering noncovered indexes that do not have a limiting search argument at the server level, if there is a column in the index or a predicate that does not have a histogram.
• msg confidentiality reqd
  msg confidentiality reqd requires that all messages into and out of SAP ASE be encrypted. The use security services parameter must be 1 for messages to be encrypted.
• msg integrity reqd
  msg integrity reqd requires that all messages be checked for data integrity. use security services must be 1 for message integrity checks to occur.
• net password encryption reqd
  net password encryption reqd restricts login authentication to use only RSA encryption algorithm or the SAP proprietary algorithm.
• network polling mode
  network polling mode configures the SAP ASE network polling mode.
• number of alarms
  number of alarms specifies the number of alarm structures allocated by SAP ASE.
• number of aux scan descriptors
  number of aux scan descriptors sets the number of auxiliary scan descriptors available in a pool shared by all users on a server.
• number of backup connections
  number of backup connections sets the maximum number of user connections Backup Server establishes to dump or load in-memory databases.
• number of ccbs
  Reserved for future use.
• number of checkpoint tasks
  number of checkpoint tasks configures parallel checkpoints. The value of number of checkpoint tasks must be less than or equal to the value of number of engines at start-up.
• number of devices
  number of devices controls the number of database devices SAP ASE can use. It does not include devices used for database or transaction log dumps.
• number of disk tasks
  number of disk tasks controls the number of tasks dedicated to polling and completing disk I/Os.
• number of dtx participants
  number of dtx participants sets the total number of remote transactions that the SAP ASE transaction coordination service can propagate and coordinate simultaneously.
• number of dump threads
  number of dump threads controls the number of threads that SAP ASE spawns to perform a memory dump.
• number of early send rows
  number of early send rows configures the number of rows that are sent to the client in the first packet of a new result set.
• number of engines at startup
  number of engines at startup is used exclusively during start-up to set the number of engines brought online.
• number of histogram steps
  number of histogram steps specifies the number of steps in a histogram.
• number of index trips
  number of index trips specifies the number of times an aged index page traverses the most recently used/least recently used (MRU/LRU) chain before it is considered for swapping out.
• number of java sockets
  number of java sockets enables the Java VM and the java.net classes SAP supports.
• number of large i/o buffers
  number of large i/o buffers sets the number of allocation unit-sized buffers reserved for performing large I/O for certain SAP ASE utilities.
• number of locks
  number of locks sets the total number of available locks for all users on SAP ASE.
• number of mailboxes
  number of mailboxes specifies the number of mailbox structures allocated by SAP ASE.
• number of messages
  number of messages specifies the number of message structures allocated by SAP ASE.
• number of network tasks
  number of network tasks controls the number of tasks dedicated to polling and completing network I/Os.
• number of oam trips
  number of oam trips specifies the number of times an object allocation map (OAM) page traverses the MRU/LRU chain before it is considered for swapping out. The higher the value of number of oam trips, the longer aged OAM pages stay in cache.
• number of open databases
  number of open databases sets the maximum number of databases that can be open simultaneously on SAP ASE.
• number of open indexes
  number of open indexes sets the maximum number of indexes that can be used simultaneously on SAP ASE.
• number of open objects
  number of open objects sets the maximum number of objects that can be open simultaneously on SAP ASE.
• number of open partitions
  number of open partitions specifies the number of partitions that SAP ASE can access at one time.
• number of pre-allocated extents
  number of pre-allocated extents specifies the number of extents (eight pages) allocated in a single trip to the page manager.
• number of Q engines at startup
  number of Q engines at startup, which specifies the number of Q engines that are online when the server starts, is required for MQ.
• number of remote connections
  number of remote connections specifies the number of logical connections that can simultaneously be open to and from an SAP ASE.
• number of remote logins
  number of remote logins controls the number of active user connections from SAP ASE to remote servers.
• number of remote sites
  number of remote sites determines the maximum number of remote sites that can simultaneously access SAP ASE.
• number of sort buffers
  number of sort buffers specifies the amount of memory allocated for buffers used to hold pages read from input tables and perform index merges during sorts. number of sort buffers is used only for parallel sorting.
• number of user connections
  number of user connections sets the maximum number of user connections that can simultaneously be connected to SAP ASE. It does not refer to the maximum number of processes; that number depends not only on the value of this parameter but also on other system activity.
• number of worker processes
  number of worker processes specifies the maximum number of worker processes that SAP ASE can use at any one time for all simultaneously running parallel queries.
• o/s file descriptors
  o/s file descriptors indicates the maximum per-process number of file descriptors configured for your operating system. This parameter is read-only and cannot be configured through SAP ASE.
• object lockwait timing
  object lockwait timing controls whether SAP ASE collects timing statistics for requests of locks on objects.
• open index hash spinlock ratio
  (Multiprocessing systems only) open index hash spinlock ratio sets the number of index metadata descriptor hash tables that are protected by one spinlock.
• open index spinlock ratio
  open index spinlock ratio specifies the number of index metadata descriptors that are protected by one spinlock.
• open object spinlock ratio
  (Multiprocessing systems only) open object spinlock ratio specifies the number of object descriptors that are protected by one spinlock.
• optimization goal
  optimization goal determines which optimization goal SAP ASE uses.
• optimize temp table resolution
  optimize temp table resolution allows stored procedures that reference temporary tables created outside the procedure to not require recompiling for each execution. 
• optimization timeout limit
  optimization timeout limit specifies the amount of time, as a fraction of the estimated execution time of the query, that SAP ASE can spend optimizing a query.
• optimizer level
  optimizer level determines the level of optimization the query processor uses.
• page lock promotion HWM
  page lock promotion HWM (high-water mark), with page lock promotion LWM (low-water mark) and page lock promotion PCT (percentage), specifies the number of page locks permitted during a single scan session of a page-locked table or index before SAP ASE attempts to escalate from page locks to a table lock.
• page lock promotion LWM
  page lock promotion LWM (low-water mark), with page lock promotion HWM (high-water mark) and the page lock promotion PCT, specify the number of page locks permitted during a single scan session of a page locked table or an index before SAP ASE attempts to promote from page locks to a table lock.
• page lock promotion PCT
  page lock promotion PCT sets the percentage of page locks (based on the table size) above which SAP ASE attempts to acquire a table lock. If the number of locks held on an object is between page lock promotion LWM (low-water mark) and page lock promotion HWM (high-water mark).
• page utilization percent
  page utilization percent is used during page allocations to control whether SAP ASE scans a table’s object allocation map (OAM) to find unused pages or simply allocates a new extent to the table.
• partition groups
  partition groups specifies the maximum number of partition groups that can be allocated by SAP ASE.
• partition spinlock ratio
  For SAP ASEs running with multiple engines, partition spinlock ratio sets the number of rows in the partition descriptors that are protected by one spinlock.
• pci memory size
  pci memory size sets the size of the pluggable component interface (PCI) memory pool.
• per object statistics active
  per object statistic active controls whether SAP ASE collects statistics for each object.
• percent database for history
  percent database for history specifies the percentage of the total space available in sybmgmtdb that is reserved for the js_history table.
• percent database for output
  percent database for output specifies the percentage of the total space available in sybmgmtdb that is reserved for job output.
• percent history free
  percent history free specifies the percentage of reserved space in sybmgmtdb to be kept free.
• percent output free
  Specifies the percentage of reserved space kept free in sybmgmtdb that is reserved for Job Scheduler output.
• performance monitoring option
  performance monitoring option enables the license for the BMC DBXray graphical performance monitoring and diagnostic tool .
• permission cache entries
  permission cache entries determines the number of cache protectors per task, increasing the amount of memory for each user connection and worker process.
• plan text pipe active
  plan text pipe active determines whether SAP ASE collects query plan text.
• plan text pipe max messages
  plan text pipe max messages determines the number of query plan text messages SAP ASE stores per engine.
• print deadlock information
  print deadlock information prints deadlock information to the error log.
• print recovery information
  print recovery information determines what information SAP ASE displays on the console during recovery. (Recovery is performed on each database at SAP ASE start-up and when a database dump is loaded.)
• procedure cache size
  procedure cache size specifies the size of the procedure cache, in 2K pages.
• procedure deferred compilation
  procedure deferred compilation enables or disables compiling statements that reference local variables or temporary tables inside a stored procedure until execution time, so that the optimization of those statements can use runtime values, instead of estimations.
• process wait events
  process wait events controls whether SAP ASE collect statistics for each wait event for every task.
• prod-consumer overlap factor
  prod-consumer overlap factor affects optimization. SAP ASE changes the group by algorithm, and you cannot use set statistics I/O with parallel plans.
• quorum heartbeat interval
  quorum heartbeat interval specifies the number of seconds between quorum heartbeats.
• quorum heartbeat retries
  quorum heartbeat retries specifies the number of times an instance attempts to detect a quorum heartbeat before determining that the quorum device is no longer running, and exiting.
• quoted identifier enhancements
  quoted identifier enhancements enables and disables quoted identifiers use in SAP ASE.
• rapidlog buffer size
  Specifies the buffer size for the output of diagnostic for measuring 'Proc Cache Header' performance.
• rapidlog max files
  Specifies the maximum number of fies for the output of diagnostic for measuring 'Proc Cache Header' performance.
• read committed with lock
  read committed with lock determines whether an SAP ASE using transaction isolation level 1 (read committed) holds shared locks on rows or pages of data-only-locked tables during select queries.
• recovery interval in minutes
  recovery interval in minutes sets the maximum number of minutes per database that SAP ASE uses to complete its recovery procedures in case of a system failure.
• recovery prefetch size
  recovery prefetch size sets the look-ahead size (in numbers of log records) to be used by the recovery prefetch scan.
• remote server pre-read packets
  remote server pre-read packets determines the number of packets that are pre-read by a site handler during connections with remote servers.
• restricted decrypt permission
  restricted decrypt permission enables or disables restricted decrypt permission in all databases. You must have the sso_role to set this parameter.
• row lock promotion HWM
  row lock promotion HWM (high-water mark), with row lock promotion LWM (low-water mark) and row lock promotion PCT specifies the maximum number of row locks permitted during a single scan session of a table or an index before SAP ASE attempts to escalate from row locks to a table lock.
• row lock promotion LWM
  row lock promotion LWM (low-water mark), with the row lock promotion HWM (high-water mark) and row lock promotion PCT specifies the number of row locks permitted during a single scan session of a table or an index before SAP ASE attempts to promote from row locks to a table lock.
• row lock promotion PCT
  If the number of locks held on an object is between row lock promotion LWM (low-water mark) and row lock promotion HWM (high-water mark), row lock promotion PCT sets the percentage of row locks (based on the number of rows in the table) above which SAP ASE attempts to acquire a table lock.
• rtm thread idle wait period
  rtm thread idle wait period defines the time, in seconds, a native thread used by SAP ASE waits when it has no work to do. When the time set for a native thread is reached, the thread automatically fades out.
• runnable process search count
  runnable process search count specifies the number of times an engine loops while looking for a runnable task before relinquishing the CPU to the operating system.
• sampling percent
  sampling percent is the numeric value of the sampling percentage, such as 5 for 5%, 10 for 10%, and so on.
• secure default login
  secure default login specifies a default login for all users who are preauthenticated but who do not have a login in master..syslogins.
• select for update
  select for update enables SAP ASE to exclusively lock rows for subsequent updates within the same transaction, and for updatable cursors, preventing other concurrent tasks from updating these rows and from blocking the subsequent update.
• select on syscomments.text
  select on syscomments.text enables protection of the text of database objects through restriction of the select permission on the text column of the syscomments table.
• send doneinproc tokens
  send doneinproc tokens enables or disables SAP ASE for sending doneinproc packets (these are TDS messages that are sent after various statements, in particular, non-select statements like insert, update, and so on).
• session migration timeout
  session migration timeout specifies the amount of time available for a client to complete a migration by connecting to the target instance. If the client does not migrate to the target instance in the time alloted, SAP ASE fails the connection.
• session tempdb log cache size
  session tempdb log cache size specifies the size for each session tempdb log cache.
• shared memory starting address
  shared memory starting address determines the virtual address where SAP ASE starts its shared memory region. It is unlikely that you will ever reconfigure shared memory starting address. (Do so only after consulting with SAP Technical Support.)
• size of auto identity column
  size of auto identity column sets the precision of IDENTITY columns that are automatically created with the sp_dboption auto identity and unique auto_identity index options.
• size of global fixed heap
  size of global fixed heap specifies the memory space for internal data structures and other needs.
• size of process object heap
  size of process object fixed heap specifies the total memory space for all processes using the Java VM.
• size of shared class heap
  size of shared class heap specifies the shared memory space for all Java classes that are called into the Java VM. SAP ASE maintains the shared class heap server-wide for both user-defined and system-provided Java classes.
• size of unilib cache
  size of unilib cache specifies the memory used in bytes rounded up to the nearest 1K in addition to the minimum overhead size, which provides enough memory to load a single copy of the largest Unilib conversion table plus the largest Unilib sort table.
• solaris async i/o mode
  solaris async i/o mode allows you to select various asynchronous IO modes on the Solaris platform.
• sproc optimize timeout limit
  sproc optimize timeout limit specifies the amount of time SAP ASE can spend optimizing a stored procedure as a fraction of the estimated execution time.
• SQL batch capture
  SQL batch capture controls whether SAP ASE collects SQL text. If both SQL batch capture and max SQL text monitored are enabled, SAP ASE collects the SQL text for each batch for each user task.
• SQL Perfmon Integration
  (Windows only)SQL Perfmon Integration enables and disables the ability to monitor SAP ASE statistics from the Windows Performance Monitor.
• sql server clock tick length
  sql server clock tick length specifies the duration of the server’s clock tick, in microseconds.
• sql text pipe active
  sql text pipe active controls whether SAP ASE collects SQL text.
• sql text pipe max messages
  sql text pipe max messages specifies the number of SQL text messages SAP ASE stores per engine.
• stack guard size
  stack guard size sets the size, in bytes, of the stack guard area, which is an overflow stack of configurable size at the end of each stack.
• stack size
  stack size specifies the size, in bytes, of the execution stacks used by each user process on SAP ASE.
• start mail session
  (Windows only) start mail session enables and disables the automatic initiation of an SAP ASE mail session when you start SAP ASE.
• start xp server during boot
  start xp server during boot determines whether XP Server starts when SAP ASE starts.
• startup delay
  startup delay controls when RepAgent is started during the server start.
• statement cache size
  statement cache size increases the server allocation of procedure cache memory and limits the amount of memory from the procedure cache pool used for cached statements.
• statement pipe active
  statement pipe active controls whether SAP ASE collects statement-level statistics.
• statement pipe max messages
  statement pipe max messages determines the number of statement statistics messages SAP ASE stores per engine.
• statement statistics active
  statement statistic active controls whether SAP ASE collects monitoring table statement-level statistics.
• streamlined dynamic SQL
  streamlined dynamic SQL enables the statement cache to store dynamic SQL statements.
• strict dtm enforcement
  strict dtm enforcement determines whether or not SAP ASE transaction coordination services strictly enforce the ACID properties (atomicity, consistency, integrity and durability ) of distributed transactions.
• suppress js max task message
  suppress js max task message prevents SAP ASE from printing the Job Scheduler js maxtask error messages to the error log.
• suspend audit when device full
  suspend audit when device full determines what SAP ASE does when an audit device becomes completely full.
• syb_sendmsg port number
  syb_sendmsg port number specifies the port number that SAP ASE uses to send messages to a UDP (User Datagram Protocol) port with sp_sendmsg or syb_sendmsg.
• sysstatistics flush interval
  sysstatistics flush interval determines the length of the interval, in minutes, between flushes of sysstatistics.
• systemwide password expiration
  systemwide password expiration sets the number of days that passwords remain in effect after they are changed.
• tape retention in days
  tape retention in days specifies the number of days you intend to retain each tape after it has been used for either a database or a transaction log dump. This parameter can keep you from accidentally overwriting a dump tape.
• tcp no delay
  tcp no delay controls TCP (Transmission Control Protocol) packet batching. The default value means that TCP packets are not batched.
• text prefetch size
  text prefetch size limits the number of pages of text, unitext, and image data that can be prefetched into an existing buffer pool.
• threshold event max messages
  Determines the number of events SAP ASE stores in the monThresholdEvent table. Once the number of events in the monThresholdEvent monitoring table exceed this value, SAP ASE overwrites the oldest unread events with new events.
• threshold event monitoring
  Enable or disables SAP ASE from recording threshold events.
• time slice
  time slice sets the number of milliseconds that the SAP ASE scheduler allows a task to run.
• total data cache size
  total data cache size reports the amount of memory, in kilobytes, that is currently available for data, index, and log pages. This parameter is a calculated value that is not directly user-configurable.
• total logical memory
  total logical memory displays the total logical memory for the current configuration of SAP ASE.
• total physical memory
  total physical memory is a read-only configuration parameter that displays the total physical memory for the current configuration of SAP ASE.
• transfer utility memory size
  SAP ASE maintains a memory pool for the transfer table command and for tables marked for incremental transfer. This pool provides memory for maintaining state information about current and past transfers, and for memory used to write to and read from transfer files. transfer utility memory size determines the size of this memory pool.
• txn to pss ratio
  txn to pss ratio determines the total number of transaction descriptors that are available to the server.
• unified login required
  unified login required requires that all users who log in to SAP ASE be authenticated by a security mechanism.
• update statistics hashing
  update statistics hashing enables SAP ASE to gather hash-based statistics.
• upgrade version
  upgrade version reports the version of the upgrade utility that upgraded your master device. The upgrade utility checks and modifies this parameter during an upgrade.
• use security services
  use security services specifies that SAP ASE uses network-based security services.
• user log cache queue size
  Determines whether a queueing strategy is used for logging.
• user log cache size
  user log cache size specifies the size, in bytes, for each user’s log cache. Its size is determined by the server’s logical page size.
• user log cache spinlock ratio
  For SAP ASEs running with multiple engines, user log cache spinlock ratio specifies the ratio of user log caches per user log cache spinlock. There is one user log cache for each configured user connection.
• wait event timing
  wait event timing controls whether SAP ASE collects statistics for individual wait events.
• wait on uncommitted insert
  Allows you to control the wait behavior of the update,insert, and delete commands for an uncommitted insert.
• workload manager cache size
  workload manager cache size specifies the maximum amount of memory, in 2K pages, that the workload manager can use.
• xact coordination interval
  xact coordination interval defines the length of time between attempts to resolve transaction branches that have been propagated to remote servers.
• xp_cmdshell context
  xp_cmdshell context sets the security context for the operating system command to be executed using the xp_cmdshell system ESP.