Page tree
Skip to end of metadata
Go to start of metadata

No new writeups yet.

14400    10           number of HBC connections setts the maximum number of simultaneous Host Based Communication connections.
14401    10           This configuration option enables or disables capture compression statistics feature. The default value is 0 (disabled).
14402    10           The configuration option 'send doneinproc tokens' sets the level for doneinproc token transmission. A value of 0 means send doneinproc tokens only for 
                             SELECT statements, and 1 means always send doneinproc tokens.
14403    10           Enables XML functionality within ASE.
14404    10           Enables Web Services functionality within ASE.
14405    10           Enables Job Scheduler Task functionality within ASE.
14406    10           max repartition degree is the maximum degree to which a table can be partitioned for parallel execution of relational operations like scans, joins, aggregations etc.
14407    10           max resource granularity is the maximum percentage of resources in the system that can be allocated to a query.
14408    10           optimization goal is a hint to the query optimizer to generate plans targeted towards the specified goal. The default optimization goal is allrows_mix.
14409    10           messaging memory allocates memory for use by the Real Time Messaging Service. The memory pool is shared across all sessions.
14410    10           Enables Real Time Messaging Services within ASE.
14411    16           0 - LDAP authentication is disabled (default). 1 - Fails over syslogins authentication when LDAP fails. 2 - Strict LDAP authentication for logins that are setup to use LDAP.
14412    16           0 - PAM authentication is disabled (default). 1 - Fails over syslogins authentication when PAM fails. 2 - Strict PAM authentication for logins that are setup to use PAM.
14413    16           extended cache size
14414    10           The compression information pool size parameter indicates the amount of memory currently available to store table compression information.
14415    10           The configuration option enables or disables compression feature. The default value is 0 (disabled).
14416    10           query optimization timeout limit is the maximum percentage of estimated query execution time that may be allocated to the optimization of the query
14417    10           max concurrently recovered db sets the limit of the number of databases recovered concurrently. The default value is 0.
14418    10           Number of dump threads indicates the number of native threads used to dump the shared memory. It can be any value between 1 and 8.
14419    10           The value 'max number of native threads per engine' is the maximum of native threads that will be spawned per engine.
                            When this limit is reached, further attempts to spawn native threads are suspended until a different native thread completes.
14420    10           The value 'rtm thread idle wait period' is the idle wait timeout value (in seconds) for a real time messaging thread. When a timeout occurs, the native thread is faded out.
14421    10           0 - encrypted columns is disabled (default). 1 - encrypted columns is enabled.
14422    10           The value 'number of Q engines at startup' is the number of external engines for MQ messaging that are automatically started at server start-up.
14423    10           The value 'max online Q engines' is the maximum number of external Q engines that are allowed in a multiprocessor environment.
14424    10           The 'sysstatistics flush interval' parameter sets the minimum interval, in minutes, between sysstatistics flushes by housekeeper. 
                             A value of '0' disables sysstatistics flushing by housekeeper.
14425    16           enable semantic partitioning' lets you enable or disable range/hash/list partitioning in the Adaptive Server. The default value is 0 (disabled). This is a dynamic option.
14426    10           This value defines the size of the memory pool from which buffers are taken in order to read an archive database that has been loaded with a compressed dump. 
                             The memory pool is shared by all sessions.
14427    10           This option lets you enable or disable logins without sa_role before recovery of user databases is complete during boot time. 
                             Logins with sa_role are always allowed to login. The default value is 1 (enabled). This is a dynamic option.
14428    10           stored procedure optimization timeout limit is the maximum percentage of estimated execution time for a stored procedure that may be allocated to the 
                             optimization of the stored procedure
14429    10           The 'start xp server during boot' is to enable automatic start of the xp server during Adaptive Server boot. This is a static option. The default value is 0. 
                             When the parameter is set to 1, xp server is booted when Adaptive Server is booted.
14430    10           session tempdb log cache size specifies the size (in bytes) for each user's log cache for it's tempdb.
14431    10           The 'enable lock remastering' parameter enables or disables lock remastering in a cluster. By default, the parameter is disabled(0).
14432    10           The configuration parameter 'min pages for parallel scan' refers to a minimum number of pages required in a table or an index for it to be scanned in parallel.
14433    10           The configuration parameter 'prod-consumer overlap factor' refers to the percentage overlap between a producer and a consumer plan fragment in terms of parallelism.
14434    10           The configuration parameter 'enable literal autoparam' enables/disables the auto-parameterization of literals in ad-hoc queries. The default value is 1 (enabled).
14435    10           The 'workload manager cache size' parameter specifies the maximum amount of memory, in 2K units, that can be used by the workload manager.
14436    16           The value 0 allows the client to determine whether to use encryption, 1 requires use of one of the encryption algorithms, and 2 requires use of 
                             strong encryption of the password. 0 is the default.
14437    10           identity reserve size allows each ASE process to reserve a block of IDENTITY column values for inserts into tables that have an IDENTITY column.
14438    16           sort level for the default sortorder. 1 - enables fast comparison by assuming strings with different lengths are unequal. 2 - disables fast comparison when
                             strings with different lengths can be equal. 4 - enables Unicode 5.1.
14439    10           0 - restricted decrypt permission is disabled (default). 1 - restricted decrypt permission is enabled.
14440    10           ASE will maintain a baseline of good query plans and query execution metrics for all queries that have executed, and remember any bad query plans that have executed,
                             so that ASE can automatically avoid executing bad query plans (default 0).
14441    10           Only applicable when the 'auto query tuning' option is enabled and a best plan exists, this will limit the procedure cache used by a query compilation to
                             the 'max resource granualarity' percentage, and use the current best plan when this is exceeded.
14442    10           Only applicable when 'auto query tuning' option enabled and a best plan exists, this will limit a query compilation to the 'optimization timeout limit' percentage of
                             average execution time, and use the current best plan when this is exceeded.
14443    10           Only applicable when 'auto query tuning' option is enabled, this value determines the number of times a query plan is executed before it can be considered a
                             good query plan or a bad query plan (default 3).
14444    10           Configuration parameter 'enable merge join' can be used to enable/disable merge_join at server level. Default value of 'enable merge join' depends on
                             current optimization goal setting.
14445    10           If the logical IO of this query is less than value of this configuration parameter, then the query metrics associated with this query will not be written to the catalogs.
14446    10           If the physical IO of this query is less than value of this configuration parameter, then the query metrics associated with this query will not be written to the catalogs.
14447    10           If the elapsed time of this query is less than value of this configuration parameter, then the query metrics associated with this query will not be written to the catalogs.
14448    10           If the execution time of this query is less than value of this configuration parameter, then the query metrics associated with this query will not be written to the catalogs.
14449    10           The 'maximum buffers per lava operator' sets an upper bound on the number of buffers that can be claimed/allocated per sort-hash operator in a query statement.
                             This value can have a secondary effect on system resources.
14451    10           This option lets you enable or disable high availability backup server. Adaptive Server will start Backup Server automatically when enabled at 
                             dump / load command request. The default value is 1 (enabled). This is a dynamic option.
14452    10           The 'enable i/o fencing' parameter enables/disables I/O fencing functionality on all database devices. The default value is 0 (disable).
14453    10           The 'cluster heartbeat interval' parameter specifies the number of seconds between cluster heartbeats.
14454    10           The 'quorum heartbeat interval' parameter specifies the number of seconds between heartbeat writes to the cluster quorum device.
14455    10           The 'quorum heartbeat retries' parameter specifies the number of times Adaptive Server retries a failed quorum heartbeat before shutting down.
14456    10           The 'automatic cluster takeover' parameter enables or disables the Adaptive Server ability to automatically boot as a cluster coordinator following an abrupt cluster shutdown.
14457    10           The 'cluster heartbeat retries' parameter specifies the number of times Adaptive Server retries a failed cluster heartbeat before entering a voting phase.
14458    10           The 'cluster vote timeout' parameter specifies the maximum number of seconds Adaptive Server waits during the cluster voting phase.
14459    10           Configuration parameter 'mnc_full_index_filter' can be used to enable/disable mnc_full_index_filter at server level. Default value of 'mnc_full_index_filter' depends on
                             current optimization goal setting.
14460    10           Use the configuration parameter 'capture missing statistics' to enable or disable capturing of missing statistics information at the server level. The default value is 0 (disabled).
14461    10           This parameter enables or disables runtime compilation of procedural statements. Changing the current value may cause currently cached procedure plans to be recompiled.
14462    10           Enable or disable auto generation of statistics for temp tables at the first optimizable query after the table is populated with rows. The default value is 0 (disabled).
14463    10           This parameter indicates the Adaptive Server Enterprise optimizer version that will be used to perform query optimization.
14464    10           This parameter allows the search engine to expand its internal tick rate non-linearly. This is especially useful if the search space is likely to encounter many illegal plans
                             (ie Outer Joins). Configure it to 0 leave the increment linear.
14466    16           cluster redundancy level' is the maximum number of nodes that can simultaneously fail for recovery to proceed concurrently with other activity. 
                             The cluster shuts down if the failed number of nodes exceeds the maximum.
14467    10           The value of 'max query parallel degree' is the maximum number of worker processes allowed per query when forced to use abstract plans while the system is 
                             configured to run in serial mode.
14468    10           The value of 'number of backup threads' is the maximum number of user connections that Backup Server can consume to perform a dump or a load of an
                             in-memory database. The value must be equal to the number of stripes plus one.
14469    10           config file version is a unique number to track the latest copy of the configuration file. It is used when cluster runs under 'private' mode.
14470    10           The 'deferred name resolution' parameter determines whether dependent objects in a stored procedure are resolved when the procedure is created, or when it is executed.
14471    10           max transfer history' determines how many table transfer history records ASE retains for each table, for successful transfers and for failed transfers.
14472    10           number of threads controls the number of threads in a thread pool when that thread pool is created.
14473    10           enables/disables console logging. The default is 0 (console logging disabled).
14474    10           disk threads controls how many threads in the thread pool will be created to perform disk I/O polling. These threads are in addition to the threads defined in 
                             the number of threads configuration option for the thread pool.
14475    10           network threads determines the number of threads in the thread pool that should be used to perform network I/O polling. These threads are created in addition
                             to the threads created by setting the number of threads configuration variable.
14476    10           kernel mode controls the mode of kernel to use, this controls the use of seperate processes for each engine or native threads within a single process.
14477    10           Enable predicated privileges. Default is disabled.
14479    10           enable file access enables access through proxy tables to the External File System.
14480    10           cis bulk insert array size specifies the block size Open Client uses to transfer data. The default is 50 rows, and the property is dynamic, allowing it to be
                             changed without server reboot.
14481    10           enable full-text search enables the Enhanced Full-Text Search services.
14482    10           Enable granular permissions. Default is disabled.
14483    10           The 'job scheduler tasks' parameter sets the maximum number of jobs that can run simultaneously through Job Scheduler.
14484    10           The 'job scheduler interval' parameter sets the interval at which the Job Scheduler checks scheduled jobs that are due to be executed.
14485    10           The 'number of checkpoint tasks' parameter configures parallel checkpoints. The max value is limited by the value of 'number of engines at startup' and 
                              'number of open databases', with a max of 8. The default value is 1, which implies serial checkpoints.
14486    16           The pci memory size parameter indicates the amount of memory currently available for use as a data cache for the PCI subsystem.
14487    16           The max pci slots parameter specifies the maximum number of slots available to the PCI subsystem for additional PCA plug-in use.
14488    16           The pci enable parameter enables the PCI subsystem which can be used to run PCA plug-ins. By default, pci enable is disabled.
14489    16           The number of java sockets parameter indicates the number of network sockets available to the Kona Java VM.
14490    10           This parameter enables or disables Distributed Transaction Management (DTM) feature. When DTM is enabled, you can use Adaptive Server as 
                             a resource manager in X/Open XA, MSDTC, and ASTC systems.
14491    10           Capture query metrics to system catalogs.
14492    10           Cost of a single logical I/O (used in new optimizer cost model).
14493    10           Cost of a single physical I/O (used in new optimizer cost model).
14494    10           Cost of a single CPU unit (used in new optimizer cost model).
14495    10           Use ASE1254 optimizer and execution engine in preference to current optimizer and execution engine.
14496    10           The 'number of disk tasks' parameter specifies the number of tasks that poll and complete disk I/Os.
14497    10           Specifies whether a given I/O type is polled using a separate thread ('threaded') or as part of an engine thread during scheduling ('inline').
14498    10           The 'number of network tasks' parameter specifies the number of tasks that poll and complete network I/Os. This parameter is only applicable when
                              'network polling mode' is 'threaded'.
14499    10           The 'number of ctlib tasks' parameter specifies the number of tasks that poll and complete ctlib I/Os.

  • No labels