SAP MaxDB Database Parameters (7.9.10.06, By Name)

• AbortHandlingMode
• AdditionalLogQueueIOLimitation
• AllocatorRegistryCheckLevel
• AutoLogBackupSize
• AutoTruncateBackupHistory
• CacheMemorySize
• CallStackLevel
• CatalogCacheSupply
• CheckAllocator
• CheckDataParallelServerTasks
• CheckLivecacheVersionSupport
• ClusterCompressionFillThreshold
• ClusterWriteThreshold
• CommandBufferSize
• Comment
• CompactMultiphaseOutputColumns
• CompressionLevel
• ConverterStripes
• ConverterVolumeIdLayout
• DataCacheIOAreaFlushThreshold
• DataCacheIOAreaSize
• DataCacheLRUAreaFlushThreshold
• DataCachePinAreaThreshold
• DataCacheStripes
• DataCacheSyncGranularity
• DateTimeFormat
• DeadlockDetectionLevel
• DeadlockDumpFilename
• DedicatedServerTaskUKTs
• DefaultCodePage
• DeferStackAllocation
• DeleteLeafsWithoutRead
• DenyAuthentication
• DeterministicFunctionExecution
• DiagnoseHistoryCount
• DiagnoseHistoryPath
• DisconnectAfterOmsStreamTimeout
• EarlyGarbageCollectionContainer
• EarlyGarbageCollectionInterval
• EarlyGarbageCollectionThreshold
• EnableAKDump
• EnableDataIOCluster
• EnableDataVolumeBalancing
• EnableDBSCommandStatistic
• EnableDeadlockLogging
• EnableDelayedRootPageCreation
• EnableExtendedShareLockStatistic
• EnableFaultTolerantCreateFunc
• EnableFetchReverseIndexOptim
• EnableFetchReverseOptimization
• EnableFileCounterInitialization
• EnableFirstRowAccessOptimization
• EnableGarbageCollTaskBalancing
• EnableIncompleteRecovery
• EnableIndexOnlyStrategy
• EnableIOTimeStatistic
• EnableJoinHashTableOptimization
• EnableJoinIntermediateSort
• EnableLiveCachePinArea
• EnableLockOverflowDump
• EnableLogBackupSavepoint
• EnableLogBackupToPipe
• EnableLogRedoMonitor
• EnableLogRestoreCompleteIndex
• EnableMinMaxAggregationOptimizer
• EnableNewCostFunction
• EnableOnePhaseJoin
• EnableOptimizedNetworkProcessing
• EnableOuterJoinOptimization
• EnableParallelFBMConstruction
• EnablePartitionedHashJoin
• EnablePreAllocateIOWorker
• EnableQualificationBypass
• EnableQualificationOnIndex
• EnableQueryRewrite
• EnableRemoveUndoOnTransactionEnd
• EnableSchedNoAgePolicy
• EnableServerTaskBalancing
• EnableSharedSQLForInternalSQL
• EnableStarJoinOptimization
• EnableSubTreeLock
• EnableSymbolDemangling
• EnableSymbolResolution
• EnableSynchronousTaskIO
• EnableVariableInput
• EnableVariableOutput
• EventFileName
• EventFileSize
• EventMailSynchronization
• ExclusiveLockEnqueueThreshold
• ExclusiveLockFavorPrioTasks
• ExclusiveLockRescheduleThreshold
• FileDirectorySpinlockPoolSize
• FloatingServiceTasks
• ForceSchedulePrioritizedTask
• ForceSchemaSpecification
• FormatDataVolume
• GarbageCollectors
• HashedResultsetCacheSize
• HashJoinSingleTableMemorySize
• HashJoinTotalMemorySize
• HighResolutionTimer
• HotStandbyDatabaseName?
• HotStandbyDelayTime?
• HotStandbyNodeName?
• HotStandbyStorageDLLPath
• HotStandbySyncInterval
• IndexLeafCachingLevel
• IndexlistsMergeThreshold
• InitialAllocatorSize
• InitialSQLLocks
• InternalLockStructureEntries
• InternalNumberRepresentation
• InternalOrderQualificationSize
• InternalOrderStackSize
• InterpreterWorkStackSize
• IOPoolIdleTimeout
• IOQueueFillingThreshold
• IOTicketQueueSynchronizationMode
• IOWorkerStackSize
• JoinHashMinimalRatio
• JoinSearchLevel
• JoinSearchTableThreshold4
• JoinSearchTableThreshold9
• JoinTableBufferSize
• KernelDumpBackup
• KernelDumpCatalogCache
• KernelDumpConfiguration
• KernelDumpConverter
• KernelDumpDataCacheControlBlock
• KernelDumpDataCachePages
• KernelDumpFileDirectory
• KernelDumpFileName
• KernelDumpGarbageCollector
• KernelDumpIOManager
• KernelDumpLocklist
• KernelDumpLockManager
• KernelDumpPageLocks
• KernelDumpRestartRecord
• KernelDumpSavepointSync
• KernelDumpTransactionManager
• KernelDumpTransformation
• KernelMessageFileSize
• KernelMessageHistoryCount
• KernelTraceFile
• LastUsedPasswords
• LoadBalancingCheckInterval
• LoadBalancingWorkloadDeviation
• LoadBalancingWorkloadThreshold
• LocalRedoLogBufferSize
• LockRescheduleInterval
• LogIOClusterSize
• LogQueues
• LogQueueSize
• LogRedoMonitorListLen
• MapRunTimeMemoryToFile
• MaxBackupMedia
• MaxCPUs
• MaxCreateIndexReadAheadRequests
• MaxDataAreaReadAheadRequests
• MaxDataAreaWriteRequests
• MaxDataVolumes
• MaxDropDataReadAheadRequests
• MaxEvents
• MaxExclusiveLockCollisionLoops
• MaxFloatingServiceTaskUKTs
• MaxGarbageCollectorTaskUKTs
• MaximumPasswordLifetime
• MaxIndexKeyPrefetchRequests
• MaxIOPoolWorkers
• MaxKernelMessageArchiveSize
• MaxLogQueues
• MaxLogVolumes
• MaxLogwriterDelay
• MaxLogWriterTasks
• MaxMessageListEntries
• MaxMonitorEntries
• MaxParallelLiveCacheTraceFiles
• MaxParameterStringLiteralSize
• MaxRetentionTime
• MaxSavepointTimeInterval
• MaxServerTasks
• MaxServerTaskStackSize
• MaxServerTaskUKTs
• MaxSpecialTaskStackSize
• MaxSpinlockHotLoops
• MaxSQLLocks
• MaxSQLSyntaxTreeNodes
• MaxTaskStackSize
• MaxTempFilesPerIndexCreation
• MaxTransactions
• MaxUserTasks
• MaxUtilityTasks
• MCODIndicator
• MicroSecondTimer
• MinimumPasswordLifetime
• MinIOPoolWorkers
• MinPasswordLength
• MinRetentionTime
• MonitorDataPageReadThreshold
• MonitorRunTimeThreshold
• MonitorSelectivityThreshold
• NetworkWorkerThreadCount
• OfficialNodeName
• OmsHeapBlockSize
• OmsHeapThreshold
• OmsMaxHeapCancelOmsVersion
• OmsMaxHeapSize
• OmsStreamTimeout
• OmsSubHeaps
• OmsVersionThreshold
• OracleConcatNULLYieldsNULL
• ParallelJoinMinThreshold
• ParallelJoinServerTasks
• PartitionedHashJoinMaxPinPages
• PasswordBlacklist
• PasswordLayout
• PreloadObjectsDuringRedo
• PreservedDBAnalyzerTasks
• PreservedEventTasks
• ReadAheadLobThreshold
• ReadAheadTableThreshold
• ReCompileTriggersInMigration
• ReCreateViewsInMigration
• RequestTimeout
• RequestUpdateStatisticsThreshold
• ReservedCommandBufferReplySize
• RestartVolumeGroupingMemorySize
• ResultsetStorageOptimization
• RetiredIOJobCount
• RowLockManagementStripes
• RowLocksPerTransactionThreshold
• RowLocksToTableLockThreshold
• RTEDumpFileName
• RunDirectoryPath
• RunTimeMemoryMapFileSize
• SavepointDeadlockDetection
• SchedNoAgePriority
• ScheduleInterval
• SequenceCacheSize
• SessionAllocatorBlockKeepCount
• SessionAllocatorSupplementSize
• SessionTimeout
• SharedSQLCleanupThreshold
• SharedSQLCommandCacheSize
• ShowDataAccessMaxStackUsage
• ShowMaxStackUsage
• SpinlockBackoffBase
• SpinlockBackoffFactor
• SpinlockBackoffMaximum
• TableLockManagementStripes
• TaskCommunicationRequestPriority
• TaskingMode
• TaskIOFinishedPriority
• TaskLockGrantRequestPriority
• TaskLockYieldPriority
• TaskNiceElevationValue
• TaskRequestPriorityAboveHigh
• TaskRequestPriorityAboveLow
• TaskRequestPriorityAboveNormal
• TaskRequestPriorityBelowHigh
• TaskRequestPriorityBelowNormal
• TaskRequestPriorityHigh
• TaskRequestPriorityLow
• TaskRequestPriorityNormal
• TaskResumeRequestPriority
• TaskRuntimeThreshold
• TaskSchedulerRetryLoops
• TaskSchedulerStartupTimeout
• TaskSpecificCatalogCacheMinSize
• TaskYieldRequestPriority
• TempResultsetPinPagesThreshold
• TraceBufferSizeALRTask
• TraceBufferSizeALWTask
• TraceBufferSizeFSTask
• TraceBufferSizeGCTask
• TraceBufferSizeIOCTask
• TraceBufferSizeLWTask
• TraceBufferSizeRRTask
• TraceBufferSizeSVPTask
• TraceBufferSizeSVTask
• TraceBufferSizeTITask
• TraceBufferSizeUSTask
• TraceBufferSizeUTTask
• TransactionHistorySize
• TransactionHistoryThreshold
• TransactionLockManagementStripes
• UKTCPUBinding
• UKTCPUBindingList
• UndoHistoryDistribution
• UnknownSessionContextYieldsNull
• UpdateStatParallelServerTask
• UpdateStatSampleAlgorithm
• UpdateStatTempFiles
• UseableCPUs
• UseableGarbageCollectorTaskUKTs
• UseableServerTaskUKTs
• UseableServerTaskUKTsInAdminMode
• UseAlternateAllocatorForServer
• UseAlterTableAddColOptimization
• UseAsynchronousIO
• UseAsynchronousLogTransport
• UseBackupCheck
• UseBackupSecurityDescriptor
• UseCheckIndexYield
• UseColumnCompression
• UseConverterStripesLockYielding
• UseDataCacheScanOptimization
• UseDDLTrigger
• UseDMLLocksForSelectForUpdate
• UseDynamicCommunicationSegments
• UseExtendedOracleSQLMode
• UseExtendedTimeMeasurement
• UseFilesystemCacheForBackup
• UseFineGranularSynchronization
• UseHashedResultset
• UseIndexKeyColumnCompression
• UseIOCompletionPort
• UseLobClustering
• UseMirroredLog
• UseMultiPhaseDropTable
• UseMultiVersionReadSupport
• UseParameterInfoForColumn
• UseQueryRewriteInDBProcedures
• UseReadAheadJoin
• UseReadAheadLob
• UseReadAheadUndoRedo
• UseReadCommittedForDMLSubquery
• UseRestrictedPredicatePushDown
• UseSelectFetchOptimization
• UseSevereCatalogLocking
• UseSharedSQL
• UseShareLockForForeignKey
• UseStrategyCache
• UseSystemTrigger
• UseTableWidthCheckDuringDDL
• UseUnicodeColumnCompression
• UseVectorIOSimulation
• UseVolumeLock
• VolumeFormattingMode
• VolumeIOQueuesForHighPriority
• VolumeIOQueuesForLowPriority
• VolumeIOQueuesForMediumPriority
• WriteRTEDumpDuringDBOffline