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.