No new writeups yet.
14001 10 per object statistics active determines whether the Adaptive Server will collect monitoring information on a per object basis
14002 16 The configuration option 'dtm detach timeout period' specifies the timeout period in minutes, for detached transactions. Transactions that are detached longer than this timeout period will be rolled back.
14003 10 The 'abstract plan load' option enables the server wide Abstract Plan LOAD mode from ap_stdin.
14004 10 The 'abstract plan dump' option enables the server wide Abstract Plan DUMP mode to ap_stout.
14005 10 The 'abstract plan replace' option enables the server wide Abstract Plan REPLACE sub-mode.
14006 10 The 'abstract plan cache' option enables the server wide Abstract Plan EXISTS CHECK cache sub-mode.
14007 10 'enable HA' lets you enable or disable HA services in Adaptive Server. The default value is 0 (disabled). This is a static option, meaning that you have to restart the server after changing the value.
14008 10 Enables Unicode data to be normalized, that is re-written in canonical form. Once disabled, cannot be re-enabled. Default is enabled.
14009 10 Changes the default sort order for Unicode (unichar/univarchar) data. Default is 'binary'.
14010 10 number of open partitions sets the maximum number of partitions that can be open at one time on Adaptive Server. The default value is 500.
14011 10 open partition hash spinlock ratio specifies the number of internal hash table for open partitions protected by one spinlock. The default value is 100.
14012 10 open partition spinlock ratio specifies the number of open partitions protected by one spinlock. The default value is 100.
14013 10 Enables processing of Unicode surrogates, guaranteeing the integrity of surrogate pairs. When disabled, surrogates are ignored. Default is disabled.
14014 16 max memory sets the maximum size of memory, in 2K units, that ASE can allocate.
14015 16 procedure cache size specifies the amount of memory allocated to the procedure cache.
14016 16 dynamic allocation on demand specifies whether ASE memory can be allocated on demand due to reconfiguration of dynamic configuration parameters.
14017 16 allocate max shared memory specifies whether ASE allocates all the memory specified by 'max memory' at any one time.
14018 16 number of engines at startup specifies the number of engines ASE brings online during the startup process.
14019 10 The amount of heap memory in bytes for each user connection.
14020 10 Enables row level access control facility. Default is disabled.
14021 10 Enables SSL facility. Default is disabled.
14022 16 total physical memory is a read-only parameter that indicates the size of the physical memory allocated by ASE so far. It is not user-configurable.
14023 10 The 'number of histogram steps' option specifies the default number of histogram steps for update statistics and create index.
14024 10 The 'sampling percent' option specifies the default percentage of a table's rows to be sampled by UPDATE STATISTICS of non-indexed columns and inner columns of composite indexes.
14025 10 Allows monitoring by the 'ASE Performance Monitoring Option' product. Default is disabled.
14026 10 Enables ASE super features. Default is disabled.
14028 10 i/o batch size sets the number of writes issued in a batch before the task goes to sleep. Once the batch is completed the task is woken up and the next batch of writes are issued.
14029 10 Statement cache size specifies the amount of memory Adaptive Server allocates to save the query plans of ad hoc SQL statements for reuse.
14030 16 The percentage of space in the sybmgmtdb database that may be used for storing job history.
14031 16 This value is a percentage of the space allowed for job history in the sybmgmtdb database. When sp_sjobclean is run or the threshold sp_js_history_thresh activated, job history is deleted so that this percentage of the space for job history is unused.
14032 16 The percentage of space in the sybmgmtdb database that may be used for job output.
14033 16 The maximum amount of job output that may be recorded by any running job. Output is discarded when the limit is reached.
14034 16 This value is a percentage of the space allowed for job output in the sybmgmtdb database. When sp_sjobclean runs or the threshold sp_js_history_thresh is activated, job output is deleted so that this percentage of the space for job output is unused.
14035 16 The size of the extended histogram is established by multiplying the number of steps with the 'histogram tuning factor' value. This is compressed to a regular histogram without affecting the high frequency cells.
14036 16 Changes the default sort order for unicode Xml data. Default is 'binary'.
14037 10 Enable/Disable statement cache monitoring. Default is 0.
14038 10 The 'enable sql debugger' enables or disables sql debugger services in Adaptive Server. The default value is 1 (enabled). This is a static option, meaning that the server have to be restarted after changing the config value to get the desired effect.
14039 10 The 'max nesting level' configuration parameter sets the maximum allowed nesting level for stored procedures and triggers.
14040 10 0 - automatic master key access is disabled (default). 1 - automatic master keyaccess is enabled.
14041 10 Enable FIPS 140-2 certified module for login password encryption. Default is disabled.
14042 10 Choose how string arguments are converted to dates in builtins. When 0, strings are converted to 'datetime'. When 1, strings are converted to 'bigdatetime'.
14043 16 GC free lock ratio defines the minumum pro-active free lock ratio to trigger pro-active GC. When the free lock ratio is less than this value, the pro-active GC will run. The default value is 25.
14044 10 The 'idle timeout' parameter specifies the number of microseconds idle threads in a thread pool will spin before going to sleep.
14045 10 The configuration parameter 'enable deferred parallel' enables/disables the deferred optimization mechanism to compile queries in parallel mode. The default value is 0 (disabled).
14046 16 CIPC regular message pool size : The parameter 'CIPC regular message pool size' indicates number of free messages in CIPC regular message pool.
14047 16 CIPC large message pool size : The parameter 'CIPC large message pool size' indicates number of free messages configured in 'CIPC large message pool
14048 16 DMA object pool size : The parameter 'DMA object pool size' indicates number of DMA messages in CIPC DMA object pool.
14049 10 CIS idle timeout specifies
14050 10 deadlock retries specifies the number of times a transaction will retry to acquire a lock after it has become a deadlock victim.
14051 10 Enable use of HP Posix asynchronous I/O. The default value is 0. This option takes effect only on HPUX platform. It will be ignored on other platforms.
14052 10 Enable the memory dump compression. Possible values are 0-9. 0 means dump without compression. 1-9 means dump with different compression level. Here, 1 means best speed and 9 means best compression.
14053 10 Execution time monitoring specifies whether the Adaptive Server will collect monitoring data for query categories execution time.
14054 10 Control ASE to boot with HugePages on Linux. Possible values are 0-2. 0 (DEFAULT) means use HugePages if possible, else use regular pages. 1 means only use regular pages. 2 means only use HugePages.
14055 10 Control ASE to boot with ISM on Solaris. Possible values are 0-2. 0 (DEFAULT) means use ISM if possible, else use regular shared memory. 1 means only use regular shared memory. 2 means only use ISM.
14056 10 This parameter allocates additional physical locks which are needed to prevent out of lock conditions. Configure it between 0 and 100 to either not allocate additional locks or to allocate up to the maximum additional physical locks needed.
14057 16 Solaris Async IO mode: 0) DEFAULT -- Solaris AIO using aiowait, 1) Solaris AIO using event port, requires OS patch with fix to BugID 15868517.
14058 10 Threshold event monitoring specifies whether the Adaptive Server will collect monitoring data for query threshold event.
14059 10 Threshold event max messages specifies the maximum number of messages that can be stored for threshold event.