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

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.

  • No labels