Page tree
Skip to end of metadata
Go to start of metadata
Configration Help Errors (10600s)

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.

 

  • No labels