No new writeups yet.
10601 10 lock hashtable size specifies the number of buckets in the lock hash table.
10602 10 the lock spinlock ratio specifies the number of page and row lock buckets in the lock hash table which are protected by each spinlock (buckets per spinlock).
10603 10 row lock promotion HWM sets the maximum number of row locks allowed before ASE escalates to a table lock. The default value is 200.
10604 10 row lock promotion LWM sets the minimum number of row locks allowed before ASE escalates to a table lock. The default value is 200.
10605 10 row lock promotion PCT sets the percentage of row locks allowed before ASE escalates to a table lock. The default value is 100.
10606 10 dump on conditions indicates whether ASE will create a shared memory dump file if any conditions configured using the
sp_dumpconfig stored procedure occurs. Possible values are 0 (not enabled) or 1 (enabled).
10607 10 enable ASE performance monitoring with Windows NT Perfmon.
10608 10 enable unloading of a DLL after each execution of extended stored procedure.
10609 10 specify the extended stored procedure execution priority on the XP Server. The values range from 0 to 15. The default value is 8.
10610 10 specify the extended stored procedure stack size on the XP Server. The values range and the default value is platform dependent.
10611 10 restrict the client execution privileges of the OS command specified with xp_cmdshell. Consult documentation for further details.
10612 10 enable start of Sybmail session with Windows NT mail subsystem with ASE startup.
10613 10 enable ASE Error logging with Windows NT Event Viewer.
10614 10 enable ASE audit (logon success) logging with Windows NT Event Viewer.
10615 10 enable ASE audit (logon failure) logging with Windows NT Event Viewer.
10616 10 specify the computer name for centralized error logging with Windows NT Event Viewer.
10617 16 cis rpc handling specifies whether Component Integration Services or a site handler is used to send RPCs. The default is 1.
10619 10 number of large i/o buffers controls the number of extent size i/o disk buffers which are allocated at server startup.
These buffers are used by 'disk mirroring', 'load database' and some dbcc commands.
10620 10 number of worker processes is the maximum number of worker processes that can be in use Server-wide at any one time.
10621 10 memory per worker process is the additional amount of memory that will be allocated to each worker process.
10622 10 max parallel degree is the maximum number of worker processes that can be used by a given query at any one time.
10623 10 max scan parallel degree is the maximum number of worker processes that can be used for a parallel scan against a non-partitioned object.
10624 10 When set to 1, the Server will allow ONLY those user connections which have already been authenticated by the underlying security mechanism. Default is 0.
10625 10 When set to 0, the Server will not initialize the Security Control Layer (support for security services is disabled). Default is 0.
10626 10 When this parameter is set to 1, ASE will not allow any user connections which are not using message confidentiality. Default value is 0.
10627 10 When this parameter is set to 1, ASE will not allow any user connections which are not using message integrity. Default value is 0.
10628 10 When set to 1, the Server will not allow any user connections which are not using message replay detection checks. Default value is 0.
When set to 0, the Server will allow connections which use message replay as well as those which don't.
10629 10 When set to 1, the Server will not allow any user connections which are not using message origin checks. Default value is 0. When set to 0, the Server will
allow connections which use message origin checks as well as those connections which don't.
10630 10 When set to 1, the Server will not allow any user connections which are not using message out of sequence detection checks. Default value is 0.
10631 10 Each character from this string that appears in the principal name is mapped into the DOLLAR sign.
This is required to take care of those characters that may be valid in an underlying security mechanism but not valid in the name space.
10632 10 This login will be used by ASE to let a user enter ASE as a secure default login if the user has already been authenticated by the
underlying security mechanism but does not have an entry in the syslogins table.
10633 10 Each character from this string that appears in the principal name is mapped into the POUND sign. This is required to take care of those
characters that may be valid in an underlying security mechanism but not valid in the ASE name space.
10634 10 Each character from this string that appears in the principal name is mapped into the UNDERSCORE sign. This is required to take care
of those characters that may be valid in an underlying security mechanism but not valid in the ASE name space.
10635 10 determines whether users can modify their curread when a cursor is open. The default is 1 (allow users to modify their curread when a cursor is open).
10636 10 enables/disables the grouping of stored procedures. The default is 1 (procedure grouping allowed).
10637 10 enables/disables granting select to public to the text column of the syscomments table. The default is 1 (grant select on syscomments.text to public).
10638 10 enables/disables the ability to send messages to internet addresses. The default is 0 (sendmsg not allowed).
10639 10 enables/disables auditing for the whole server. The default is 0 (auditing disabled).
10640 10 establishes where ASE writes audit records. Values can be 1 to 8, representing sysaudits_01 through sysaudits _08; 0 means to set
the current audit table to the next in sequence. The default is 1.
10641 10 controls what happens when the audit table becomes full. Values are (1) suspend the audit process and all auditable user processes (default),
and (0) truncate the next audit table and start using it as the current table.
10642 10 indicates the default port number for sending internet messages.
10643 10 enables/disables character conversion before sending to or receiving from the client. The default is 0 (ASE will convert characters before sending to or received from the client).
10645 16 Maximum dump conditions indicates the maximum number of shared memory dump conditions that can be configured on this server.
The value of this field may be from 10 to 100. The default value is 10.
10646 16 This configuration option enables/disables the bidirectional index scans
10647 10 enables/disables asynchronous prefetch server-wide. Sets the percentage of each buffer pool in which prefetched but unused pages can be stored.
If needed, this value can be overridden for a pool with local async prefetch limit
10648 10 disable disk mirroring is a toggle that allows the user to utilize ASE disk mirroring.
10649 10 A transaction descriptor is used for each transaction started in a database by a user connection. The number of transaction descriptors per
process times the number of user connections is the total number of transaction descriptors available.
10650 10 enables unicode-based character set conversions. When set to 1, enables conversions for character sets not already in syscharsets.
When set to 2, enables Unicode-based conversions for all connections. The default is 0 (off).
10651 10 size of unilib cache sets the size of memory (in bytes) to be set aside for additional Unicode-based conversions and collations.
10652 16 Configures cache partition server-wide. The global cache partition number must be power of 2, between 1 to 64 and the partitioned buffer pool size must be at least 256P.
10653 10 The value of 'number of ccbs' is the number of Configurable Action Point Control Blocks available to aid debugging.
10654 10 The value of 'caps per ccb' is the maximum number of Configurable Action Points that can be configured at any one time within one Configurable Action Point Control Block.
10655 10 The value of 'average cap size' is a guess at how many bytes of memory will be required to store the information associated with a typical Configurable Action Point.
10656 16 enable java specifies whether Java Services are loaded when the server is started. The default is 0 (not loaded).
10657 16 Size of object heap is the per-process memory used for allocating Java objects.
10658 16 Size of class heap is the memory used for Java classes and other such structures that are shared between all processes.
10659 10 The 'license information' configuration parameter sets the number of user logins for which Adaptive Server is licensed. When this count is exceeded,
an informational message is printed to the error log. Contact SAP to purchase additional licenses.
10660 10 This configuration option 'enable xact coordination' enables/disables Adaptive Server distributed transaction coordination services.
10661 10 The configuration option 'xact coordination interval' changes the distributed transaction recovery interval.
10662 10 The configuration option 'number of dtx participants' sets the maximum number of local and remote distributed transaction participants that can be active at any instance of time.
10663 10 The configuration option 'strict dtm enforcement' when enabled enforces that only participants that can be managed through Adaptive Server distributed
transaction management protocol(s) can participate in a distributed transaction.
10664 10 The configuration option 'dtm lock timeout period' sets the maximum time, in seconds, a distributed transaction participant waits on a lock request after
which the lock request is timed out.
10665 10 Allow the query optimizer to consider sort-merge join and Join Transitive Closure(JTC). The default is 0. By default, the optimizer does not
evaluate sort-merge join and join transitive closure, when generating query execution plans.
10666 16 Size of global fixed heap is the size of memory used by the Java subsystem for internal data structures and other needs that are shared by all processes.
10667 10 enable monitoring specifies whether the Adaptive Server will collect information for the Monitoring and Diagnostic System.
10668 10 autostart collector indicates whether the Adaptive Server will start the Q Diagnsotics Engine collector process on server startup.
10669 10 collector repository server specifies the name of the Q Diagnostics Engine repository server.
10670 10 collector application host specifies the name of the Q Diagnostics Engine Application Server host system.
10671 10 collector errorlog file specifies the directory in which the Q Diagnostics Engine Collector process should place its errorlog file.
10672 10 collector failover file specifies the directory in which the Q Diagnostics Engine Collector process should place it's failover file
10673 10 collection interval specifies the amount of time the Q Diagnostics Engine Collector process waits between each data collection cycle.
10674 10 sql text pipe active indicates whether the Adaptive Server will collect historical sql batch text information.
10675 10 sql text pipe max messages specifies the maximum number of messages that can be stored for historical sql text.
10676 10 plan text pipe active indicates whether the Adaptive Server will collect historical plan text monitoring information.
10677 10 plan text pipe max messages specifies the maximum number of messages that can be stored for historical plan text.
10678 16 statement pipe active indicates whether the Adaptive Server will collect historical statement level monitoring information.
10679 10 statement pipe max messages specifies the maximum number of messages that can be stored for historical statement text.
10680 10 errorlog pipe active indicates whether the Adaptive Server will collect historical errorlog monitoring information.
10681 10 errorlog pipe max messages specifies the maximum number of messages that can be stored for historical errorlog text.
10682 10 deadlock pipe active indicates whether the Adaptive Server will collect historical deadlock monitoring information.
10683 10 deadlock pipe max messages specifies the maximum number of messages that can be stored for historical deadlock data.
10684 10 wait event timing specifies whether the Adaptive Server will collect monitoring data for all wait events.
10685 10 process event timing specifies whether the Adaptive Server will collect monitoring data on wait events for individual processes.
10686 10 object lockwait timing specifies whether the Adaptive Server will collect timing data on lock requests.
10687 10 SQL batch capture indicates whether the Adaptive Server will collect sql batch text for each process.
10688 16 statement statistics active indicates whether ASE will collect ad-hoc statement monitoring information
10689 16 'text prefetch size' specifies the number of text pages to prefetch into the text read pipeline.
10690 10 The 'default exp_row_size percent' parameter reserves a specified percentage of page size for expanding updates in data-only-locked tables. The default value is 5.
10691 10 'enable housekeeper GC' is a toggle that enables the housekeeper task to perform space reclamation on data-only-locked tables. The default value is 1 (enabled).
10692 10 'enable rep agent threads' is a toggle that enables RepAgent threads within Adaptive Server. The default value is 0 (disabled).
10693 10 'lock scheme' sets the default locking scheme to be used by the create table and select into commands when a lock scheme is not specified in the command.
The default value is allpages.
10694 10 'lock wait period' limits the number of seconds that tasks wait to acquire a lock on a table, data page or data row. The default value is 2,147,483,647.
At the default value, all tasks wait indefinitely for locks.
10695 10 'max SQL text monitored' specifies the amount of memory allocated per user connection for saving SQL text to memory shared by Adaptive Server. The default value is 0.
10696 10 'read committed with lock' determines whether an Adaptive Server using transaction isolation level 1 (read committed) holds shared locks on rows or
pages of data-only-locked tables during select queries. The default value is 0 (off).
10697 0 This option specifies the number of consecutive failed login attempts permitted before the targeted login is locked. 'maximum failed logins' for the user is
set to zero after every successful login.
10698 0 This option specifies the minimum number of characters a password must have to be accepted for any new logins. Logins that were set up using the
previously set minimum password length can continue having fewer characters for their passwords.
10699 10 Setting configuration parameter 'check password for digit' to 1 checks newly set passwords for the presence of at least one digit. This parameter is off (set to 0) by default.