SAP MaxDB Database Parameters (7.9.09.10, By Class)

• AUTHENTICATION
• AUTOMATIC
• BACKUPRECOVERY
• CHECK
• DATACACHE
• DBMANAGEMENT
• DIAGNOSTICS
• EVENTADMIN
• EVENTS
• EXTENDED
• GENERAL
• HIGHAVAILABILITY
• IOMANAGEMENT
• LOGGING
• MEMORY
• OPERATINGSYSTEM
• OPTIMIZATION
• PERSISTENCY
• SPECIALPURPOSES
• SUPPORT
• SYNCHRONISATION
• TASKING
• TRACE
• TRANSACTIONS
• VOLUMES

AUTHENTICATION

• AllowAuthentication
• EnableGenericSecurityService
• MinPasswordLength

AUTOMATIC

• DBAnalyzerDays
• UseDBAnalyzer
• UseLoadSystemTables

BACKUPRECOVERY

• CheckBackup
• EnableDataIOCluster
• EnableLogBackupToPipe
• EnableLogRedoMonitor
• EnableLogRestoreCompleteIndex
• LogRedoMonitorListLen
• MaxBackupMedia
• MaxLogWriterTasks
• TraceBackup
• UseAutomaticBadIndexRecreation
• UseBackupCheck
• UseConverterStripesLockYielding

CHECK

• CheckAllocator
• CheckBackup
• CheckCatalogCache
• CheckCommon
• CheckConverter
• CheckDataCache
• CheckDataIndex
• CheckDataLogpage
• CheckDataTempHashFile
• CheckDataTree
• CheckFreeBlockManager
• CheckHashedResultSet
• CheckIOManager
• CheckLogArea
• CheckLogHistory
• CheckLogPage
• CheckLogTransaction
• CheckQueryAnalysis
• CheckQueryRewrite
• CheckServerTask
• CheckSQLLock
• CheckTransactionManagement
• CheckTree
• TraceSQLLock

DATACACHE

• CacheMemorySize
• CheckDataCache
• DataCacheIOAreaFlushThreshold
• DataCacheIOAreaSize
• DataCacheLRUAreaFlushThreshold
• DataCachePinAreaThreshold
• DataCacheStripes
• DataCacheSyncGranularity
• EnableLiveCachePinArea
• TraceDataCache
• UseDataCacheScanOptimization
• UseFineGranularSynchronization

DBMANAGEMENT

• CheckBackup
• CheckCommon
• Comment
• DateTimeFormat
• DefaultCodePage
• EnableVariableInput
• EnableVariableOutput
• MCODIndicator
• TraceBackup
• UseColumnCompression
• UseDDLTrigger
• UseExtendedOracleSQLMode
• UseSystemTrigger
• UseTableWidthCheckDuringDDL
• UseVolumeLock

DIAGNOSTICS

• BacktraceOnError
• CallStackLevel
• DBAnalyzerDays
• DiagnoseHistoryCount
• DiagnoseHistoryPath
• EnableAKDump
• EnableExternalDumpRequest
• EnableFileCounterInitialization
• EnableSymbolDemangling
• EnableSymbolResolution
• FloatingServiceTasks
• KernelDumpFileName
• KernelMessageFileSize
• KernelMessageHistoryCount
• KernelTraceFile
• MapRunTimeMemoryToFile
• MaxKernelMessageArchiveSize
• MaxMessageListEntries
• MaxMonitorEntries
• MaxParallelLiveCacheTraceFiles
• MonitorDataPageReadThreshold
• MonitorRunTimeThreshold
• MonitorSelectivityThreshold
• PreservedDBAnalyzerTasks
• RTEDumpFileName
• RunTimeMemoryMapFileSize
• ShowDataAccessMaxStackUsage
• ShowMaxStackUsage
• TraceBufferSizeALRTask
• TraceBufferSizeALWTask
• TraceBufferSizeFSTask
• TraceBufferSizeGCTask
• TraceBufferSizeIOCTask
• TraceBufferSizeLWTask
• TraceBufferSizeRRTask
• TraceBufferSizeSVPTask
• TraceBufferSizeSVTask
• TraceBufferSizeTITask
• TraceBufferSizeUSTask
• TraceBufferSizeUTTask
• TraceMessage
• TraceStopErrorcode
• TraceTime
• TransactionHistorySize
• TransactionHistoryThreshold
• UseDBAnalyzer
• UseSharedSQL

EVENTADMIN

• EventFileName
• EventFileSize
• FloatingServiceTasks
• MaxEvents
• PreservedEventTasks

EVENTS

• ThrowDBFillingAboveLimitEvent
• ThrowDBFillingBelowLimitEvent
• ThrowLogAboveLimitEvent

EXTENDED

• AllowAuthentication
• CatalogCacheSupply
• CheckAllocator
• ClusterCompressionFillThreshold
• ClusterWriteThreshold
• Comment
• ConverterStripes
• ConverterVolumeIdLayout
• DataCacheStripes
• DateTimeFormat
• DeadlockDetectionLevel
• DefaultCodePage
• DeterministicFunctionExecution
• DiagnoseHistoryCount
• DiagnoseHistoryPath
• EnableGenericSecurityService
• EnableIndexOnlyStrategy
• EnableLogBackupToPipe
• EnableQueryRewrite
• ExclusiveLockEnqueueThreshold
• ExclusiveLockFavorPrioTasks
• ExclusiveLockRescheduleThreshold
• FileDirectorySpinlockPoolSize
• FormatDataVolume
• HashedResultsetCacheSize
• HashJoinSingleTableMemorySize
• HashJoinTotalMemorySize
• HighResolutionTimer
• HotStandbyDatabaseName?
• HotStandbyDelayTime?
• HotStandbyNodeName?
• HotStandbyStorageDLLPath
• HotStandbySyncInterval
• IndexlistsMergeThreshold
• JoinSearchLevel
• JoinSearchTableThreshold4
• JoinSearchTableThreshold9
• JoinTableBufferSize
• KernelMessageFileSize
• KernelMessageHistoryCount
• LoadBalancingCheckInterval
• LocalRedoLogBufferSize
• LogQueues
• LogQueueSize
• MaxEvents
• MaxExclusiveLockCollisionLoops
• MaxKernelMessageArchiveSize
• MaxLogWriterTasks
• MaxParallelLiveCacheTraceFiles
• MaxParameterStringLiteralSize
• MaxRetentionTime
• MaxServerTasks
• MicroSecondTimer
• MinRetentionTime
• OfficialNodeName
• OmsHeapBlockSize
• OmsHeapThreshold
• OmsSubHeaps
• OmsVersionThreshold
• OracleConcatNULLYieldsNULL
• PreloadObjectsInStandbyMode
• RequestTimeout
• RequestUpdateStatisticsThreshold
• RowLockManagementStripes
• RowLocksPerTransactionThreshold
• SequenceCacheSize
• SessionTimeout
• SharedSQLCleanupThreshold
• SharedSQLCommandCacheSize
• TableLockManagementStripes
• TraceBufferSizeALRTask
• TraceBufferSizeALWTask
• TraceBufferSizeFSTask
• TraceBufferSizeGCTask
• TraceBufferSizeIOCTask
• TraceBufferSizeLWTask
• TraceBufferSizeRRTask
• TraceBufferSizeSVPTask
• TraceBufferSizeSVTask
• TraceBufferSizeTITask
• TraceBufferSizeUSTask
• TraceBufferSizeUTTask
• TransactionHistorySize
• TransactionHistoryThreshold
• TransactionLockManagementStripes
• UpdateStatSampleAlgorithm
• UpdateStatTempFiles
• UseableCPUs
• UseAlterTableAddColOptimization
• UseBackupSecurityDescriptor
• UseDataCacheScanOptimization
• UseHashedResultset
• UseIndexKeyColumnCompression
• UseLobClustering
• UseParameterInfoForColumn
• UseQueryRewriteInDBProcedures
• UseSharedSQL
• UseUnicodeColumnCompression
• VolumeFormattingMode

GENERAL

• AutoLogBackupSize
• CacheMemorySize
• MaxBackupMedia
• MaxCPUs
• MaxDataVolumes
• MaxLogVolumes
• MaxSQLLocks
• MaxUserTasks
• MCODIndicator
• OmsMaxHeapSize
• RunDirectoryPath
• UseMirroredLog

HIGHAVAILABILITY

• HotStandbyStorageDLLPath
• HotStandbySyncInterval
• OfficialNodeName

IOMANAGEMENT

• CheckConverter
• CheckFreeBlockManager
• CheckIOManager
• CheckLogArea
• ClusterCompressionFillThreshold
• ClusterWriteThreshold
• EnableDataIOCluster
• EnableDataVolumeBalancing
• EnableLogBackupToPipe
• EnableOptimizedNetworkProcessing
• EnablePreAllocateIOWorker
• EnableSynchronousTaskIO
• IOPoolIdleTimeout
• IOQueueFillingThreshold
• IOTicketQueueSynchronizationMode
• IOWorkerStackSize
• LocalRedoLogBufferSize
• LogIOClusterSize
• LogQueues
• LogQueueSize
• MaxBackupMedia
• MaxCreateIndexReadAheadRequests
• MaxDataAreaReadAheadRequests
• MaxDataAreaWriteRequests
• MaxDropDataReadAheadRequests
• MaxIndexKeyPrefetchRequests
• MaxIOPoolWorkers
• MaxLogQueues
• MinIOPoolWorkers
• NetworkWorkerThreadCount
• ReadAheadLobThreshold
• ReadAheadTableThreshold
• RetiredIOJobCount
• TraceConverter
• TraceFreeBlockManager
• TraceIOManager
• TraceLogArea
• TraceVolume
• UseConverterStripesLockYielding
• UseFilesystemCacheForBackup
• UseIOCompletionPort
• UseLobClustering
• UseMirroredLog
• UseReadAheadJoin
• UseReadAheadLob
• UseReadAheadUndoRedo
• UseVectorIOSimulation
• VolumeIOQueuesForHighPriority
• VolumeIOQueuesForLowPriority
• VolumeIOQueuesForMediumPriority

LOGGING

• AdditionalLogQueueIOLimitation
• AutoLogBackupSize
• CheckDataLogpage
• CheckLogArea
• CheckLogHistory
• CheckLogPage
• CheckLogTransaction
• EnableLogBackupToPipe
• EnableLogRedoMonitor
• EnableLogRestoreCompleteIndex
• LocalRedoLogBufferSize
• LogIOClusterSize
• LogQueues
• LogQueueSize
• LogRedoMonitorListLen
• MaxLogQueues
• MaxLogVolumes
• MaxLogwriterDelay
• MaxSavepointTimeInterval
• ThrowLogAboveLimitEvent
• TraceLogAction
• TraceLogArea
• TraceLogHistory
• TraceLogPage
• TraceLogTransaction
• UseAsynchronousLogTransport
• UseAutomaticBadIndexRecreation
• UseMirroredLog

MEMORY

• CacheMemorySize
• CatalogCacheSupply
• CheckAllocator
• CommandBufferSize
• DeferStackAllocation
• EnableJoinHashTableOptimization
• FileDirectorySpinlockPoolSize
• FloatingServiceTasks
• GarbageCollectors
• HashedResultsetCacheSize
• HashJoinSingleTableMemorySize
• HashJoinTotalMemorySize
• InitialAllocatorSize
• InternalLockStructureEntries
• InternalOrderQualificationSize
• InternalOrderStackSize
• InterpreterWorkStackSize
• JoinTableBufferSize
• LocalRedoLogBufferSize
• LogQueues
• MapRunTimeMemoryToFile
• MaxLogQueues
• MaxLogWriterTasks
• MaxMessageListEntries
• MaxServerTasks
• MaxServerTaskStackSize
• MaxSpecialTaskStackSize
• MaxSQLSyntaxTreeNodes
• MaxTaskStackSize
• MaxTransactions
• MaxUserTasks
• OmsHeapBlockSize
• OmsHeapThreshold
• OmsMaxHeapCancelOmsVersion
• OmsMaxHeapSize
• OmsSubHeaps
• OmsVersionThreshold
• PreservedDBAnalyzerTasks
• PreservedEventTasks
• ReservedCommandBufferReplySize
• ResultsetStorageOptimization
• RunTimeMemoryMapFileSize
• SessionAllocatorBlockKeepCount
• SessionAllocatorSupplementSize
• SharedSQLCommandCacheSize
• ShowDataAccessMaxStackUsage
• ShowMaxStackUsage
• TaskSpecificCatalogCacheMinSize
• TempResultsetPinPagesThreshold
• TraceAllocator
• TraceBufferSizeALRTask
• TraceBufferSizeALWTask
• TraceBufferSizeFSTask
• TraceBufferSizeGCTask
• TraceBufferSizeIOCTask
• TraceBufferSizeLWTask
• TraceBufferSizeRRTask
• TraceBufferSizeSVPTask
• TraceBufferSizeSVTask
• TraceBufferSizeTITask
• TraceBufferSizeUSTask
• TraceBufferSizeUTTask
• TraceFrameControl
• TraceMemory
• TraceSharedSQL
• TraceTransaction
• UseHashedResultset
• UseSharedSQL

OPERATINGSYSTEM

• HighResolutionTimer
• IOTicketQueueSynchronizationMode
• MicroSecondTimer
• OfficialNodeName
• RunDirectoryPath
• UseFilesystemCacheForBackup

OPTIMIZATION

• CheckDataParallelServerTasks
• CheckQueryAnalysis
• CheckQueryRewrite
• EnableFetchReverseOptimization
• EnableFirstRowAccessOptimization
• EnableIndexOnlyStrategy
• EnableJoinHashTableOptimization
• EnableJoinIntermediateSort
• EnableMinMaxAggregationOptimizer
• EnableOnePhaseJoin
• EnableOuterJoinOptimization
• EnablePartitionedHashJoin
• EnableQualificationBypass
• EnableQualificationOnIndex
• EnableQueryRewrite
• EnableSharedSQLForInternalSQL
• EnableStarJoinOptimization
• HashJoinSingleTableMemorySize
• HashJoinTotalMemorySize
• IndexLeafCachingLevel
• IndexlistsMergeThreshold
• InternalNumberRepresentation
• JoinHashMinimalRatio
• JoinSearchLevel
• JoinSearchTableThreshold4
• JoinSearchTableThreshold9
• JoinTableBufferSize
• MaxCreateIndexReadAheadRequests
• MaxDataAreaReadAheadRequests
• MaxDataAreaWriteRequests
• MaxDropDataReadAheadRequests
• MaxIndexKeyPrefetchRequests
• MaxTempFilesPerIndexCreation
• ParallelJoinMinThreshold
• ParallelJoinServerTasks
• PartitionedHashJoinMaxPinPages
• ReadAheadLobThreshold
• ReadAheadTableThreshold
• RequestUpdateStatisticsThreshold
• SequenceCacheSize
• SharedSQLCleanupThreshold
• SharedSQLCommandCacheSize
• TraceAccessPlanOptimizer
• TraceInterpreter
• TraceJoin
• TraceJoinPlanOptimizer
• TraceOptimizer
• UpdateStatParallelServerTask
• UpdateStatSampleAlgorithm
• UpdateStatTempFiles
• UseDataCacheScanOptimization
• UseQueryRewriteInDBProcedures
• UseReadAheadJoin
• UseReadAheadLob
• UseReadAheadUndoRedo
• UseSelectFetchOptimization
• UseSharedSQL
• UseStrategyCache

PERSISTENCY

• CheckCatalogCache
• CheckDataIndex
• CheckDataLogpage
• CheckDataTempHashFile
• CheckDataTree
• CheckHashedResultSet
• CheckLogHistory
• CheckLogPage
• CheckTree
• EnableDelayedRootPageCreation
• EnableSubTreeLock
• HashedResultsetCacheSize
• IndexLeafCachingLevel
• ResultsetStorageOptimization
• TempResultsetPinPagesThreshold
• TraceAlterObject
• TraceDataChain
• TraceDataIndex
• TraceDataLob
• TraceDataPageAccessManager
• TraceDataTempHashFile
• TraceDataTree
• TraceFileDirectory
• TraceFreeObject
• TraceGetObject
• TraceLockManager
• TraceLogAction
• TraceLogHistory
• TraceLogPage
• TraceLogTransaction
• TraceMultiVersionRead
• TraceNewObject
• TraceObject
• TraceObjectContainer
• TraceTable
• UseColumnCompression
• UseHashedResultset
• UseMultiVersionReadSupport
• UseTableWidthCheckDuringDDL

SPECIALPURPOSES

• EnableClientSpecificOmsSchema
• EnableImplicitPrepareStatement
• InstanceName
• JavaHomePath
• JavaOptions
• Port
• UseFilesystemSynchronisation
• UseTasksInUKT

SUPPORT

• AbortHandlingMode
• AdditionalLogQueueIOLimitation
• CallStackLevel
• CheckDataParallelServerTasks
• CheckLivecacheVersionSupport
• CommandBufferSize
• CompactMultiphaseOutputColumns
• DataCacheIOAreaFlushThreshold
• DataCacheIOAreaSize
• DataCacheLRUAreaFlushThreshold
• DataCachePinAreaThreshold
• DataCacheSyncGranularity
• DeadlockDumpFilename
• DedicatedServerTaskUKTs
• DeferStackAllocation
• DeleteLeafsWithoutRead
• EarlyGarbageCollectionContainer
• EarlyGarbageCollectionInterval
• EarlyGarbageCollectionThreshold
• EnableAKDump
• EnableDataIOCluster
• EnableDataVolumeBalancing
• EnableDeadlockLogging
• EnableDelayedRootPageCreation
• EnableExtendedShareLockStatistic
• EnableFaultTolerantCreateFunc
• EnableFetchReverseOptimization
• EnableFileCounterInitialization
• EnableFirstRowAccessOptimization
• EnableGarbageCollTaskBalancing
• EnableIOTimeStatistic
• EnableJoinHashTableOptimization
• EnableJoinIntermediateSort
• EnableLiveCachePinArea
• EnableLockOverflowDump
• EnableLogRedoMonitor
• EnableLogRestoreCompleteIndex
• EnableMinMaxAggregationOptimizer
• EnableOnePhaseJoin
• EnableOptimizedNetworkProcessing
• EnableOuterJoinOptimization
• EnablePartitionedHashJoin
• EnablePreAllocateIOWorker
• EnableQualificationBypass
• EnableQualificationOnIndex
• EnableRemoveUndoOnTransactionEnd
• EnableSchedNoAgePolicy
• EnableServerTaskBalancing
• EnableSharedSQLForInternalSQL
• EnableStarJoinOptimization
• EnableSubTreeLock
• EnableSymbolDemangling
• EnableSymbolResolution
• EnableSynchronousTaskIO
• EnableVariableInput
• EnableVariableOutput
• EventFileName
• EventFileSize
• FloatingServiceTasks
• ForceSchedulePrioritizedTask
• ForceSchemaSpecification
• GarbageCollectors
• IndexLeafCachingLevel
• InitialAllocatorSize
• InternalLockStructureEntries
• InternalNumberRepresentation
• InternalOrderQualificationSize
• InternalOrderStackSize
• InterpreterWorkStackSize
• IOPoolIdleTimeout
• IOQueueFillingThreshold
• IOTicketQueueSynchronizationMode
• IOWorkerStackSize
• JoinHashMinimalRatio
• KernelDumpBackup
• KernelDumpCatalogCache
• KernelDumpConfiguration
• KernelDumpConverter
• KernelDumpDataCacheControlBlock
• KernelDumpDataCachePages
• KernelDumpFileDirectory
• KernelDumpFileName
• KernelDumpGarbageCollector
• KernelDumpIOManager
• KernelDumpLocklist
• KernelDumpLockManager
• KernelDumpPageLocks
• KernelDumpRestartRecord
• KernelDumpSavepointSync
• KernelDumpTransactionManager
• KernelDumpTransformation
• KernelTraceFile
• LoadBalancingWorkloadDeviation
• LoadBalancingWorkloadThreshold
• LockRescheduleInterval
• LogIOClusterSize
• LogRedoMonitorListLen
• MapRunTimeMemoryToFile
• MaxCreateIndexReadAheadRequests
• MaxDataAreaReadAheadRequests
• MaxDataAreaWriteRequests
• MaxDropDataReadAheadRequests
• MaxFloatingServiceTaskUKTs
• MaxGarbageCollectorTaskUKTs
• MaxIndexKeyPrefetchRequests
• MaxIOPoolWorkers
• MaxLogQueues
• MaxLogwriterDelay
• MaxMessageListEntries
• MaxMonitorEntries
• MaxSavepointTimeInterval
• MaxServerTaskStackSize
• MaxServerTaskUKTs
• MaxSpecialTaskStackSize
• MaxSpinlockHotLoops
• MaxSQLSyntaxTreeNodes
• MaxTaskStackSize
• MaxTempFilesPerIndexCreation
• MaxTransactions
• MinIOPoolWorkers
• MonitorDataPageReadThreshold
• MonitorRunTimeThreshold
• MonitorSelectivityThreshold
• NetworkWorkerThreadCount
• OmsMaxHeapCancelOmsVersion
• OmsStreamTimeout
• ParallelJoinMinThreshold
• ParallelJoinServerTasks
• PartitionedHashJoinMaxPinPages
• PreloadObjectsInStandbyMode
• PreservedDBAnalyzerTasks
• PreservedEventTasks
• ReadAheadLobThreshold
• ReadAheadTableThreshold
• ReCreateViewsInMigration
• ReservedCommandBufferReplySize
• RestartVolumeGroupingMemorySize
• ResultsetStorageOptimization
• RetiredIOJobCount
• RTEDumpFileName
• RunTimeMemoryMapFileSize
• SavepointDeadlockDetection
• SchedNoAgePriority
• ScheduleInterval
• SessionAllocatorBlockKeepCount
• SessionAllocatorSupplementSize
• ShowDataAccessMaxStackUsage
• ShowMaxStackUsage
• SpinlockBackoffBase
• SpinlockBackoffFactor
• SpinlockBackoffMaximum
• TaskCommunicationRequestPriority
• TaskingMode
• TaskIOFinishedPriority
• TaskLockGrantRequestPriority
• TaskLockYieldPriority
• TaskNiceElevationValue
• TaskRequestPriorityAboveHigh
• TaskRequestPriorityAboveLow
• TaskRequestPriorityAboveNormal
• TaskRequestPriorityBelowHigh
• TaskRequestPriorityBelowNormal
• TaskRequestPriorityHigh
• TaskRequestPriorityLow
• TaskRequestPriorityNormal
• TaskResumeRequestPriority
• TaskRuntimeThreshold
• TaskSpecificCatalogCacheMinSize
• TaskYieldRequestPriority
• TempResultsetPinPagesThreshold
• UKTCPUBinding
• UKTCPUBindingList
• UnknownSessionContextYieldsNull
• UpdateStatParallelServerTask
• UseableGarbageCollectorTaskUKTs
• UseableServerTaskUKTs
• UseableServerTaskUKTsInAdminMode
• UseAlternateAllocatorForServer
• UseAsynchronousLogTransport
• UseBackupCheck
• UseCheckIndexYield
• UseColumnCompression
• UseConverterStripesLockYielding
• UseDDLTrigger
• UseDMLLocksForSelectForUpdate
• UseDynamicCommunicationSegments
• UseExtendedOracleSQLMode
• UseExtendedTimeMeasurement
• UseFilesystemCacheForBackup
• UseFineGranularSynchronization
• UseIOCompletionPort
• UseMultiVersionReadSupport
• UseNewKeyFilling
• UseReadAheadJoin
• UseReadAheadLob
• UseReadAheadUndoRedo
• UseRestrictedPredicatePushDown
• UseSelectFetchOptimization
• UseShareLockForForeignKey
• UseStrategyCache
• UseSystemTrigger
• UseTableWidthCheckDuringDDL
• UseTenantBackupRegion
• UseVectorIOSimulation
• UseVolumeLock
• VolumeIOQueuesForHighPriority
• VolumeIOQueuesForLowPriority
• VolumeIOQueuesForMediumPriority
• WriteRTEDumpDuringDBOffline

SYNCHRONISATION

• ConverterStripes
• DataCacheStripes
• EnableLockOverflowDump
• EnableSubTreeLock
• ExclusiveLockEnqueueThreshold
• ExclusiveLockFavorPrioTasks
• ExclusiveLockRescheduleThreshold
• FileDirectorySpinlockPoolSize
• LocalRedoLogBufferSize
• LogQueues
• MaxExclusiveLockCollisionLoops
• MaxLogQueues
• MaxSpinlockHotLoops
• MaxSQLLocks
• RowLockManagementStripes
• RowLocksPerTransactionThreshold
• SpinlockBackoffBase
• SpinlockBackoffFactor
• SpinlockBackoffMaximum
• TableLockManagementStripes
• TraceStopErrorcode
• TransactionLockManagementStripes
• UseFineGranularSynchronization

TASKING

• CheckServerTask
• DedicatedServerTaskUKTs
• DeferStackAllocation
• EnableGarbageCollTaskBalancing
• EnablePreAllocateIOWorker
• EnableServerTaskBalancing
• FloatingServiceTasks
• ForceSchedulePrioritizedTask
• GarbageCollectors
• IOPoolIdleTimeout
• LoadBalancingCheckInterval
• LoadBalancingWorkloadDeviation
• LoadBalancingWorkloadThreshold
• LockRescheduleInterval
• MaxCPUs
• MaxFloatingServiceTaskUKTs
• MaxGarbageCollectorTaskUKTs
• MaxIOPoolWorkers
• MaxLogWriterTasks
• MaxServerTasks
• MaxServerTaskUKTs
• MaxUserTasks
• MinIOPoolWorkers
• PreservedDBAnalyzerTasks
• PreservedEventTasks
• RetiredIOJobCount
• ScheduleInterval
• TaskCommunicationRequestPriority
• TaskingMode
• TaskIOFinishedPriority
• TaskLockGrantRequestPriority
• TaskLockYieldPriority
• TaskNiceElevationValue
• TaskRequestPriorityAboveHigh
• TaskRequestPriorityAboveLow
• TaskRequestPriorityAboveNormal
• TaskRequestPriorityBelowHigh
• TaskRequestPriorityBelowNormal
• TaskRequestPriorityHigh
• TaskRequestPriorityLow
• TaskRequestPriorityNormal
• TaskResumeRequestPriority
• TaskRuntimeThreshold
• TaskYieldRequestPriority
• UKTCPUBinding
• UKTCPUBindingList
• UseableCPUs
• UseableGarbageCollectorTaskUKTs
• UseableServerTaskUKTs
• UseableServerTaskUKTsInAdminMode

TRACE

• CheckCatalogCache
• CheckCommon
• CheckConverter
• CheckDataCache
• CheckDataIndex
• CheckDataLogpage
• CheckDataTempHashFile
• CheckDataTree
• CheckFreeBlockManager
• CheckHashedResultSet
• CheckIOManager
• CheckLogArea
• CheckLogHistory
• CheckLogPage
• CheckLogTransaction
• CheckQueryAnalysis
• CheckQueryRewrite
• CheckServerTask
• CheckSharedSQL
• CheckSQLLock
• CheckTaskSpecificCatalogCache
• CheckTransactionManagement
• CheckTree
• TraceAccessPlanOptimizer
• TraceAK
• TraceAllocator
• TraceAlterObject
• TraceBackup
• TraceCatalog
• TraceCatalogCache
• TraceClientKernelCommunication
• TraceCommon
• TraceCommunication
• TraceConverter
• TraceDataAgent
• TraceDataCache
• TraceDataChain
• TraceDataIndex
• TraceDataLob
• TraceDataPageAccessManager
• TraceDataSource
• TraceDataTempHashFile
• TraceDataTree
• TraceDBProcedure
• TraceDefault
• TraceDelete
• TraceDML
• TraceDQE
• TraceDQEODBC
• TraceDQETPT
• TraceFileDirectory
• TraceFrameControl
• TraceFreeBlockManager
• TraceFreeObject
• TraceGetObject
• TraceGG
• TraceInsert
• TraceInternalSQL
• TraceInterpreter
• TraceInterProcessCommunication
• TraceIOManager
• TraceJoin
• TraceJoinPlanOptimizer
• TraceKB
• TraceLockManager
• TraceLogAction
• TraceLogArea
• TraceLogHistory
• TraceLogPage
• TraceLogTransaction
• TraceMemory
• TraceMessage
• TraceMonitor
• TraceMultiVersionRead
• TraceNewObject
• TraceObject
• TraceObjectContainer
• TraceOmsCacheFlush
• TraceOmsContainerDirectory
• TraceOmsContext
• TraceOmsError
• TraceOmsHeap
• TraceOmsInterface
• TraceOmsKey
• TraceOmsKeyRange
• TraceOmsLock
• TraceOmsMemory
• TraceOmsNewObject
• TraceOmsObject
• TraceOmsSession
• TraceOmsStream
• TraceOmsTransaction
• TraceOmsVarobject
• TraceOmsVersion
• TraceOptimizer
• TraceOrder
• TraceOrderStandard
• TracePlanExecution
• TraceQueryAnalysis
• TraceQueryRewrite
• TraceQuerySQLGeneration
• TraceRunTime
• TraceRunTimeDiagnose
• TraceSelect
• TraceServerTask
• TraceSharedSQL
• TraceSQLExecution
• TraceSQLLock
• TraceSQLManager
• TraceStopErrorcode
• TraceSynchronisation
• TraceSyntax
• TraceSystemView
• TraceTable
• TraceTime
• TraceTransaction
• TraceUpdate
• TraceValueExpression
• TraceVolume

TRANSACTIONS

• CheckLogHistory
• CheckLogTransaction
• CheckSQLLock
• CheckTransactionManagement
• DeadlockDetectionLevel
• DeadlockDumpFilename
• EnableLockOverflowDump
• GarbageCollectors
• InternalLockStructureEntries
• MaxRetentionTime
• MaxSQLLocks
• MaxTransactions
• MaxUserTasks
• MinRetentionTime
• OmsStreamTimeout
• RequestTimeout
• RowLockManagementStripes
• RowLocksPerTransactionThreshold
• SessionTimeout
• TableLockManagementStripes
• TraceSQLLock
• TransactionHistorySize
• TransactionHistoryThreshold
• TransactionLockManagementStripes
• UseMultiVersionReadSupport

VOLUMES

• ConverterVolumeIdLayout
• FormatDataVolume
• MaxDataVolumes
• MaxLogVolumes
• VolumeFormattingMode