Page tree
Skip to end of metadata
Go to start of metadata
Configuration Help Errors (10400s)

No new writeups yet.

10401    10           additional network memory allocates additional memory for clients which request packet sizes that are larger than the default packet size for the server.
10402    10           lock address spinlock ratio specifies the number of address lock buckets in the address locks hash table which are protected by each spinlock (buckets per spinlock).
10403    10           allow nested triggers is a toggle that controls the use of nested triggers. When the value is set to 1, data modifications made by triggers can fire other triggers.
10404    10           allow remote access determines whether users from remote servers can access this ASE. The default is 1, to allow ASE to communicate with Backup Server.
10405    10           allow sql server async i/o is a toggle that enables ASE to run with asynchronous disk I/O.
10406    10           allow updates to system tables allows system tables to be updated directly. The default is 0 (off).
10407    10           audit queue size determines the number of audit records that the audit queue can hold. The default is 100.
10408    10           configuration file specifies the location of the configuration file you want to use.
10409    10           cpu accounting flush interval specifies how many machine clock ticks to accumulate before adding cpu usage data to syslogins for use in chargeback accounting statistics.
10410    10           cpu grace time specifies the maximum amount of time (in milliseconds) a user process can run without yielding the CPU before ASE infects it.
10411    10           deadlock checking period specifies the minimum amount of time (in milliseconds) a process must wait for a lock before ASE initiates a deadlock check.
10412    10           deadlock retries specifies the number of times a transaction will retry to acquire a lock after it has become a deadlock victim.
10413    10           default character set id is the number of the default character set used by the server.
10414    10           default database size sets the default number of megabytes allocated to each new user database. The default run value is 2 (megabytes)
10415    10           default fill factor percent sets how full ASE makes each page when creating a new index on existing data (unless user gives other value in create index statement).
10416    10           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.
10417    10           default network packet size sets the default size of network packets for all users on ASE.
10418    10           default sortorder id is the number of the current default sortorder on ASE. Do not change this parameter. See the System Administration Guide for more information.
10419    10           disk i/o structures specifies the initial number of disk I/O control blocks ASE allocates on startup.
10420    10           event buffers per engine specifies the number of events per ASE engine that can be simultaneously monitored. Events are used for observing ASE performance.
10421    10           executable code size reports the size of the ASE executable.
10423    10           housekeeper free write percent sets the maximum percentage that database writes can increase because of free writes started by the housekeeper process.
10424    10           i/o accounting flush interval specifies how many disk I/Os to accumulate before flushing the data to syslogins for use in chargeback accounting.
10425    10           i/o polling process count specifies the number of tasks the scheduler will run before checking for disk and/or network I/O completions.
10426    10           identity burning set factor sets the percentage of potential IDENTITY column values made available in each block.
10427    10           identity grab size allows each ASE process to reserve a block of IDENTITY column values for inserts into tables that have an IDENTITY column.
10428    10           page lock promotion HWM sets the maximum number of page locks allowed before ASE escalates to a table lock. The default value is 200.
10429    10           page lock promotion LWM sets the minimum number of page locks allowed before ASE escalates to a table lock. The default value is 200.
10430    10           page lock promotion PCT sets the percentage of page locks allowed before ASE escalates to a table lock. The default value is 100.
10431    10           lock shared memory disallows swapping of ASE pages to disk, and allowing the operating system kernel to avoid the server's internal page locking code.
10432    10           max async i/o's per engine specifies the maximum number of asynchronous disk I/O requests that can be outstanding for a single engine at one time.
10433    10           max async i/o's per server specifies the maximum number of asynchronous disk I/O requests that can be outstanding for ASE at one time.
10435    10           max network packet size sets the maximum network packet size that a client program can request.
10436    10           max number of network listeners specifies the maximum number of network listeners that can be open at one time.
10437    10           max online engines controls the number of engines in a symmetric multiprocessor environment.
10438    10           memory alignment boundary determines on which boundary buffer caches are aligned.
10440    10           number of alarms specifies the number of alarms allocated by ASE. Alarms are used with the Transact-SQL waitfor command.
10441    10           number of devices controls the number of database devices ASE can use. It does not include devices used for database dumps.
10442    10           number of extent i/o buffers allocates the specified number of extents (8 data pages) for use by create index. Do not set this value to more than 100.
10443    10           number of index trips specifies the number of times an aged index page recycles itself onto the MRU chain.
10445    10           number of locks sets the number of available locks. The default run value is 10000.
10446    10           number of mailboxes sets the number of mailbox structures ASE allocates on start-up. Mailboxes are use for process-to-process communication and synchronization.
10447    10           number of messages specifies the number of message structures allocated by ASE at start-up time. Messages are used in conjunction with mailboxes for
                             process-to-process communication and synchronization.
10448    10           number of oam trips specifies the number of times an aged OAM page recycles itself onto the MRU chain.
10449    10           number of open databases sets the maximum number of databases that can be open at one time on ASE. The default run value is 12.
10450    10           number of open objects sets the maximum number of database objects that can be open at one time on ASE. The default run value is 500.
10451    10           number of preallocated extents specifies the number of extent structures allocated in a single trip to the page manager.
10452    10           number of remote connections controls the limit on active connections initiated to and from this ASE. The default is 20.
10453    10           number of remote logins controls the number of active user connections from this ASE to remote servers. The default is 20.
10454    10           number of remote sites controls the number of simultaneous remote sites that can access this ASE. The default is 10.
10455    10           number of sort buffers specifies the number of buffers used to hold pages read from input tables.
10456    10           number of user connections sets the maximum number of user connections that can be connected to ASE at one time.
10457    10           page lock spinlock ratio specifies the ratio of spinlocks protecting the internal page locks hash table.
10458    10           page utilization percent controls when ASE performs an OAM (Object Allocation Map) scan to find unused pages. The default run value is 95.
10459    10           partition groups sets how many partition groups to allocate for the server. Partition groups are used by ASE to control access to individual partitions of tables.
10460    10           partition spinlock ratio sets the number of partition caches each spinlock protects. These spinlocks keep processes from using partition caches used by other processes.
10461    10           permission cache entries determines the number of cache protectors per task.
10462    10           print deadlock information enables printing of deadlock information to the error log.
10463    10           print recovery information determines what information ASE displays on the console during recovery.
10464    10           procedure cache percent specifies the amount of memory allocated to the procedure cache after ASE's memory needs are met. The default run value is 20.
10465    10           recovery interval in minutes sets the maximum time per database that ASE uses to complete its recovery procedures in case of a system failure.
10466    10           remote server pre-read packets controls the number of packets that a site handler will pre-read in connections with remote servers. The default is 3.
10467    10           runnable process search count specifies the number of times an engine will loop looking for a runnable task before relinquishing the CPU.
10468    10           sort page count specifies the maximum amount of memory a sort operation can use.
10469    10           sql server clock tick length specifies the duration of the server's clock tick, in microseconds.
10470    10           stack guard size specifies the size of the stack guard area.
10471    10           stack size sets the size of ASE's execution stack.
10472    0             This option specifies the number of days that passwords remain in effect after they are changed. The default is 0 (passwords do not expire).
10473    10           lock table spinlock ratio specifies the number of table lock buckets in the table lock hash table which are protected by each spinlock (buckets per spinlock).
10474    10           tape retention in days sets the number of days you want to retain each tape after it has been used for a database or transaction log dump.
10475    10           tcp no delay disables TCP packet batching.
10476    10           time slice sets the number of milliseconds that ASE's scheduler allows a user process to run. The default run value is 100 milliseconds.
10477    10           total data cache size represents the amount of memory currently available for use as a data cache. It is a calculated value that is not directly user-configurable.
10478    10           The run value of 'total logical memory' indicates the size of memory required to satisfy the current configuration.
10479    10           upgrade version is changed by the upgrade program provided with new releases.
10480    10           user log cache size specifies the size (in bytes) for each user's log cache.
10481    10           user log cache spinlock ratio specifies the number of user log caches per user log cache spinlock.
10482    10           shared memory starting address determines the virtual address at which ASE starts its shared memory region. Most users do not need to modify this.
10483    10           size of auto identity column sets the precision of IDENTITY columns automatically created with the sp_dboption 'auto identity' option.
10485    10           os file descriptors is a read-only parameter that indicates how many file descriptors have been allocated to ASE. It is not user-configurable.
10486    10           Allow-limits allows the Resource Governor feature to be used by SAs. Default is 0 (off); static.
10487    10           number of auxiliary scan descriptors sets the maximum number of auxiliary scan descriptors that can be shared among all connections at one time. The default run value is 200.
10488    10           number of open indexes sets the maximum number of indexes that can be open at one time on ASE. The default value is 500.
10489    10           open object spinlock ratio specifies the number of open objects protected by one spinlock. The default value is 100.
10490    10           open index hash spinlock ratio specifies the number of internal hash tables for open indexes protected by one spinlock. The default value is 100.
10491    10           open index spinlock ratio specifies the number of open indexes protected by one spinlock. The default value is 100.
10492    10           enable cis specifies whether Component Integration Services is loaded when the server is started. The default is 1.
10493    10           cis connect timeout specifies the number of seconds to wait for a connect request to a remote server to complete.
10494    10           cis bulk insert batch size specifies the number of rows in a bulk copy batch when performing a SELECT INTO operation.
10495    10           max cis remote connections specifies the maximum number of connections to remote servers that can be active at one time.
10497    10           cis packet size specifies the maximum size of a network packet.
10498    10           cis cursor rows specifies the maximum number of rows that will be returned in response to a single fetch operation.
10499    10           CIS idle timeout specifies the number of seconds to wait before terminating an idle connection with a remote server.

  • No labels