SAP MaxDB Database Parameters (7.9.10.07, By Class)

• AUTHENTICATION
• AUTOMATIC
• BACKUPRECOVERY
• CHECK
• DATACACHE
• DBM
• DBMANAGEMENT
• DIAGNOSTICS
• EVENTADMIN
• HIGHAVAILABILITY
• INDEX
• IOMANAGEMENT
• LIVECACHE
• LOGGING
• MEMORY
• OPERATINGSYSTEM
• OPTIMIZATION
• PERSISTENCY
• SPECIALPURPOSES
• SYNCHRONISATION
• TASKING
• TRANSACTIONS
• VOLUMES

AUTHENTICATION

• DenyAuthentication
• LastUsedPasswords
• MaximumPasswordLifetime
• MinimumPasswordLifetime
• MinPasswordLength
• PasswordBlacklist
• PasswordLayout

AUTOMATIC

• AutoTruncateBackupHistory

BACKUPRECOVERY

• AutoTruncateBackupHistory
• CompressionLevel
• EnableDataIOCluster
• EnableIncompleteRecovery
• EnableIOTimeStatistic
• EnableLogBackupSavepoint
• EnableLogBackupToPipe
• EnableLogRedoMonitor
• EnableLogRestoreCompleteIndex
• LogRedoMonitorListLen
• MaxBackupMedia
• MaxLogWriterTasks
• UndoHistoryDistribution
• UseBackupCheck
• UseBackupSecurityDescriptor
• UseConverterStripesLockYielding

CHECK

• CheckAllocator
• UseCheckIndexYield

DATACACHE

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

DBM

• AutoTruncateBackupHistory

DBMANAGEMENT

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

DIAGNOSTICS

• AbortHandlingMode
• CallStackLevel
• DiagnoseHistoryCount
• DiagnoseHistoryPath
• EnableAKDump
• EnableDBSCommandStatistic
• EnableDeadlockLogging
• EnableExtendedShareLockStatistic
• EnableFileCounterInitialization
• EnableIOTimeStatistic
• EnableSymbolDemangling
• EnableSymbolResolution
• FloatingServiceTasks
• KernelDumpBackup
• KernelDumpCatalogCache
• KernelDumpConfiguration
• KernelDumpConverter
• KernelDumpDataCacheControlBlock
• KernelDumpDataCachePages
• KernelDumpFileDirectory
• KernelDumpFileName
• KernelDumpGarbageCollector
• KernelDumpIOManager
• KernelDumpLocklist
• KernelDumpLockManager
• KernelDumpPageLocks
• KernelDumpRestartRecord
• KernelDumpSavepointSync
• KernelDumpTransactionManager
• KernelDumpTransformation
• KernelMessageFileSize
• KernelMessageHistoryCount
• KernelTraceFile
• MapRunTimeMemoryToFile
• MaxKernelMessageArchiveSize
• MaxMessageListEntries
• MaxMonitorEntries
• MaxParallelLiveCacheTraceFiles
• MonitorDataPageReadThreshold
• MonitorRunTimeThreshold
• MonitorSelectivityThreshold
• PreservedDBAnalyzerTasks
• RTEDumpFileName
• RunTimeMemoryMapFileSize
• SavepointDeadlockDetection
• ShowDataAccessMaxStackUsage
• ShowMaxStackUsage
• TraceBufferSizeALRTask
• TraceBufferSizeALWTask
• TraceBufferSizeFSTask
• TraceBufferSizeGCTask
• TraceBufferSizeIOCTask
• TraceBufferSizeLWTask
• TraceBufferSizeRRTask
• TraceBufferSizeSVPTask
• TraceBufferSizeSVTask
• TraceBufferSizeTITask
• TraceBufferSizeUSTask
• TraceBufferSizeUTTask
• TransactionHistorySize
• TransactionHistoryThreshold
• UseSharedSQL
• WriteRTEDumpDuringDBOffline

EVENTADMIN

• EventFileName
• EventFileSize
• EventMailSynchronization
• FloatingServiceTasks
• MaxEvents
• PreservedEventTasks

HIGHAVAILABILITY

• HotStandbyDatabaseName?
• HotStandbyDelayTime?
• HotStandbyNodeName?
• HotStandbyStorageDLLPath
• HotStandbySyncInterval
• OfficialNodeName
• PreloadObjectsDuringRedo

INDEX

• UseCheckIndexYield

IOMANAGEMENT

• 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
• UseAsynchronousIO
• UseConverterStripesLockYielding
• UseFilesystemCacheForBackup
• UseIOCompletionPort
• UseLobClustering
• UseMirroredLog
• UseReadAheadJoin
• UseReadAheadLob
• UseReadAheadUndoRedo
• UseVectorIOSimulation
• VolumeIOQueuesForHighPriority
• VolumeIOQueuesForLowPriority
• VolumeIOQueuesForMediumPriority

LIVECACHE

• CheckLivecacheVersionSupport

LOGGING

• AdditionalLogQueueIOLimitation
• AutoLogBackupSize
• EnableLogBackupToPipe
• EnableLogRedoMonitor
• EnableLogRestoreCompleteIndex
• EnableLogRestoreSavepoint
• LocalRedoLogBufferSize
• LogIOClusterSize
• LogQueues
• LogQueueSize
• LogRedoMonitorListLen
• LogRestoreSavepointDistance
• MaxLogQueues
• MaxLogVolumes
• MaxLogwriterDelay
• MaxSavepointTimeInterval
• UseAsynchronousLogTransport
• UseMirroredLog

MEMORY

• AllocatorRegistryCheckLevel
• CacheMemorySize
• CatalogCacheSupply
• CheckAllocator
• CommandBufferSize
• DeferStackAllocation
• EarlyGarbageCollectionContainer
• EnableFaultTolerantCreateFunc
• 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
• MaxUtilityTasks
• OmsHeapBlockSize
• OmsHeapThreshold
• OmsMaxHeapCancelOmsVersion
• OmsMaxHeapSize
• OmsSubHeaps
• OmsVersionThreshold
• PreservedDBAnalyzerTasks
• PreservedEventTasks
• ReservedCommandBufferReplySize
• RestartVolumeGroupingMemorySize
• ResultsetStorageOptimization
• RunTimeMemoryMapFileSize
• SessionAllocatorBlockKeepCount
• SessionAllocatorSupplementSize
• SharedSQLCommandCacheSize
• ShowDataAccessMaxStackUsage
• ShowMaxStackUsage
• TaskSpecificCatalogCacheMinSize
• TempResultsetPinPagesThreshold
• TraceBufferSizeALRTask
• TraceBufferSizeALWTask
• TraceBufferSizeFSTask
• TraceBufferSizeGCTask
• TraceBufferSizeIOCTask
• TraceBufferSizeLWTask
• TraceBufferSizeRRTask
• TraceBufferSizeSVPTask
• TraceBufferSizeSVTask
• TraceBufferSizeTITask
• TraceBufferSizeUSTask
• TraceBufferSizeUTTask
• UseAlternateAllocatorForServer
• UseDynamicCommunicationSegments
• UseHashedResultset
• UseSharedSQL

OPERATINGSYSTEM

• EnableSchedNoAgePolicy
• HighResolutionTimer
• HotStandbyNodeName?
• IOTicketQueueSynchronizationMode
• MicroSecondTimer
• OfficialNodeName
• RunDirectoryPath
• SchedNoAgePriority
• UseBackupSecurityDescriptor
• UseExtendedTimeMeasurement
• UseFilesystemCacheForBackup

OPTIMIZATION

• CheckDataParallelServerTasks
• CompactMultiphaseOutputColumns
• EnableFetchReverseIndexOptim
• EnableFetchReverseOptimization
• EnableFirstRowAccessOptimization
• EnableIndexOnlyStrategy
• EnableJoinHashTableOptimization
• EnableJoinIntermediateSort
• EnableMinMaxAggregationOptimizer
• EnableNewCostFunction
• EnableOnePhaseJoin
• EnableOuterJoinOptimization
• EnableParallelFBMConstruction
• 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
• ReCompileTriggersInMigration
• ReCreateViewsInMigration
• RequestUpdateStatisticsThreshold
• SequenceCacheSize
• SharedSQLCleanupThreshold
• SharedSQLCommandCacheSize
• UpdateStatParallelServerTask
• UpdateStatSampleAlgorithm
• UpdateStatTempFiles
• UseAlterTableAddColOptimization
• UseDataCacheScanOptimization
• UseIndexKeyColumnCompression
• UseQueryRewriteInDBProcedures
• UseReadAheadJoin
• UseReadAheadLob
• UseReadAheadUndoRedo
• UseSelectFetchOptimization
• UseSharedSQL
• UseStrategyCache
• UseUnicodeColumnCompression

PERSISTENCY

• DeleteLeafsWithoutRead
• EarlyGarbageCollectionInterval
• EarlyGarbageCollectionThreshold
• EnableDelayedRootPageCreation
• EnableSubTreeLock
• HashedResultsetCacheSize
• IndexLeafCachingLevel
• ResultsetStorageOptimization
• TempResultsetPinPagesThreshold
• UseColumnCompression
• UseHashedResultset
• UseIndexKeyColumnCompression
• UseMultiPhaseDropTable
• UseMultiVersionReadSupport
• UseTableWidthCheckDuringDDL
• UseUnicodeColumnCompression

SPECIALPURPOSES

• DeterministicFunctionExecution
• EnableFaultTolerantCreateFunc
• ForceSchemaSpecification
• MaxParameterStringLiteralSize
• OracleConcatNULLYieldsNULL
• UnknownSessionContextYieldsNull
• UseParameterInfoForColumn
• UseReadCommittedForDMLSubquery
• UseRestrictedPredicatePushDown
• UseShareLockForForeignKey

SYNCHRONISATION

• ConverterStripes
• DataCacheStripes
• EnableExtendedShareLockStatistic
• EnableLockOverflowDump
• EnableSubTreeLock
• ExclusiveLockEnqueueThreshold
• ExclusiveLockFavorPrioTasks
• ExclusiveLockRescheduleThreshold
• FileDirectorySpinlockPoolSize
• InitialSQLLocks
• LocalRedoLogBufferSize
• LogQueues
• MaxExclusiveLockCollisionLoops
• MaxLogQueues
• MaxSpinlockHotLoops
• MaxSQLLocks
• RowLockManagementStripes
• RowLocksPerTransactionThreshold
• RowLocksToTableLockThreshold
• SpinlockBackoffBase
• SpinlockBackoffFactor
• SpinlockBackoffMaximum
• TableLockManagementStripes
• TransactionLockManagementStripes
• UseDMLLocksForSelectForUpdate
• UseFineGranularSynchronization
• UseSevereCatalogLocking

TASKING

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

TRANSACTIONS

• DeadlockDetectionLevel
• DeadlockDumpFilename
• DisconnectAfterOmsStreamTimeout
• EarlyGarbageCollectionContainer
• EarlyGarbageCollectionInterval
• EarlyGarbageCollectionThreshold
• EnableLockOverflowDump
• EnableRemoveUndoOnTransactionEnd
• GarbageCollectors
• InitialSQLLocks
• InternalLockStructureEntries
• MaxRetentionTime
• MaxSQLLocks
• MaxTransactions
• MaxUserTasks
• MaxUtilityTasks
• MinRetentionTime
• OmsStreamTimeout
• RequestTimeout
• RowLockManagementStripes
• RowLocksPerTransactionThreshold
• RowLocksToTableLockThreshold
• SessionTimeout
• TableLockManagementStripes
• TransactionHistorySize
• TransactionHistoryThreshold
• TransactionLockManagementStripes
• UseMultiVersionReadSupport

VOLUMES

• ConverterVolumeIdLayout
• EnableIOTimeStatistic
• FormatDataVolume
• MaxDataVolumes
• MaxLogVolumes
• RestartVolumeGroupingMemorySize
• VolumeFormattingMode