C.2 Data Node Configuration Parameters

Table C.2 Data Node Configuration Parameters

Parameter NameType or UnitsRestart TypeIn Version ... (and later)
Default Value
Minimum/Maximum or Permitted Values

Arbitration

enumerationNNDB 7.3.0
Default
Default, Disabled, WaitExternal

ArbitrationTimeout

millisecondsNNDB 7.3.0
7500
10 / 4294967039 (0xFFFFFEFF)

BackupDataBufferSize

bytesNNDB 7.3.0
16M
0 / 4294967039 (0xFFFFFEFF)

BackupDataDir

pathINNDB 7.3.0
FileSystemPath
...

BackupLogBufferSize

bytesNNDB 7.3.0
16M
0 / 4294967039 (0xFFFFFEFF)

BackupMaxWriteSize

bytesNNDB 7.3.0
1M
2K / 4294967039 (0xFFFFFEFF)

BackupMemory

bytesNNDB 7.3.0
32M
0 / 4294967039 (0xFFFFFEFF)

BackupReportFrequency

secondsNNDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

BackupWriteSize

bytesNNDB 7.3.0
256K
2K / 4294967039 (0xFFFFFEFF)

BatchSizePerLocalScan

integerNNDB 7.3.0
256
1 / 992

BuildIndexThreads

numericSNDB 7.3.0
0
0 / 128

CompressedBackup

booleanNNDB 7.3.0
false
true, false

CompressedLCP

booleanNNDB 7.3.0
false
true, false

ConnectCheckIntervalDelay

stringNNDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

CrashOnCorruptedTuple

booleanSNDB 7.3.0
true
true, false

DataDir

pathINNDB 7.3.0
.
...

DataMemory

bytesNNDB 7.3.0
80M
1M / 1024G

DefaultHashMapSize

LDM threadsNNDB 7.3.0
3840
0 / 3840

DictTrace

bytesNNDB 7.3.0
undefined
0 / 100

DiskCheckpointSpeed

bytesNNDB 7.3.0
10M
1M / 4294967039 (0xFFFFFEFF)

DiskCheckpointSpeedInRestart

bytesNNDB 7.3.0
100M
1M / 4294967039 (0xFFFFFEFF)

DiskIOThreadPool

threadsNNDB 7.3.0
2
0 / 4294967039 (0xFFFFFEFF)

Diskless

true|false (1|0)ISNDB 7.3.0
false
true, false

DiskPageBufferMemory

bytesNNDB 7.3.0
64M
4M / 1T

DiskSyncSize

bytesNNDB 7.3.0
4M
32K / 4294967039 (0xFFFFFEFF)

ExecuteOnComputer

nameSNDB 7.3.0
[none]
...

ExtraSendBufferMemory

bytesNNDB 7.3.0
0
0 / 32G

FileSystemPath

pathINNDB 7.3.0
DataDir
...

FileSystemPathDataFiles

filenameINNDB 7.3.0
[see text]
...

FileSystemPathDD

filenameINNDB 7.3.0
FileSystemPath
...

FileSystemPathUndoFiles

filenameINNDB 7.3.0
[see text]
...

FragmentLogFileSize

bytesINNDB 7.3.0
16M
4M / 1G

HeartbeatIntervalDbApi

millisecondsNNDB 7.3.0
1500
100 / 4294967039 (0xFFFFFEFF)

HeartbeatIntervalDbDb

millisecondsNNDB 7.3.0
5000
10 / 4294967039 (0xFFFFFEFF)

HeartbeatOrder

numericSNDB 7.3.0
0
0 / 65535

HostName

name or IP addressNNDB 7.3.0
localhost
...

Id

unsignedISNDB 7.3.0
[none]
1 / 48

IndexMemory

bytesNNDB 7.3.0
18M
1M / 1T

IndexStatAutoCreate

booleanSNDB 7.3.0
false
false, true

IndexStatAutoUpdate

booleanSNDB 7.3.0
false
false, true

IndexStatSaveScale

percentageINNDB 7.3.0
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatSaveSize

bytesINNDB 7.3.0
32768
0 / 4294967039 (0xFFFFFEFF)

IndexStatTriggerPct

percentageINNDB 7.3.0
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatTriggerScale

percentageINNDB 7.3.0
100
0 / 4294967039 (0xFFFFFEFF)

IndexStatUpdateDelay

secondsINNDB 7.3.0
60
0 / 4294967039 (0xFFFFFEFF)

InitFragmentLogFiles

[see values]INNDB 7.3.0
SPARSE
SPARSE, FULL

InitialLogFileGroup

stringSNDB 7.3.0
[see text]
...

InitialNoOfOpenFiles

filesNNDB 7.3.0
27
20 / 4294967039 (0xFFFFFEFF)

InitialTablespace

stringSNDB 7.3.0
[see text]
...

LateAlloc

numericNNDB 7.3.0
1
0 / 1

LcpScanProgressTimeout

secondNNDB 7.3.3
60
0 / 4294967039 (0xFFFFFEFF)

LockExecuteThreadToCPU

CPU IDNNDB 7.3.0
64K
0 / 64K

LockMaintThreadsToCPU

CPU IDNNDB 7.3.0
[none]
0 / 64K

LockPagesInMainMemory

numericNNDB 7.3.0
0
0 / 2

LogLevelCheckpoint

log levelNNDB 7.3.0
0
0 / 15

LogLevelCongestion

levelrNNDB 7.3.0
0
0 / 15

LogLevelConnection

integerNNDB 7.3.0
0
0 / 15

LogLevelError

integerNNDB 7.3.0
0
0 / 15

LogLevelInfo

integerNNDB 7.3.0
0
0 / 15

LogLevelNodeRestart

integerNNDB 7.3.0
0
0 / 15

LogLevelShutdown

integerNNDB 7.3.0
0
0 / 15

LogLevelStartup

integerNNDB 7.3.0
1
0 / 15

LogLevelStatistic

integerNNDB 7.3.0
0
0 / 15

LongMessageBuffer

bytesNNDB 7.3.5
64M
512K / 4294967039 (0xFFFFFEFF)

MaxAllocate

unsignedNNDB 7.3.0
32M
1M / 1G

MaxBufferedEpochs

epochsNNDB 7.3.0
100
0 / 100000

MaxBufferedEpochBytes

bytesNNDB 7.3.0
26214400
26214400 (0x01900000) / 4294967039 (0xFFFFFEFF)

MaxDiskWriteSpeed

numericSNDB 7.4.1
20M
1M / 1024G

MaxDiskWriteSpeedOtherNodeRestart

numericSNDB 7.4.1
50M
1M / 1024G

MaxDiskWriteSpeedOwnRestart

numericSNDB 7.4.1
200M
1M / 1024G

MaxDMLOperationsPerTransaction

operations (DML)NNDB 7.3.0
4294967295
32 / 4294967295

MaxLCPStartDelay

secondsNNDB 7.3.0
0
0 / 600

MaxNoOfAttributes

integerNNDB 7.3.0
1000
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentIndexOperations

integerNNDB 7.3.0
8K
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentOperations

integerNNDB 7.3.0
32K
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentScans

integerNNDB 7.3.0
256
2 / 500

MaxNoOfConcurrentSubOperations

unsignedNNDB 7.3.0
256
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfConcurrentTransactions

integerNNDB 7.3.0
4096
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfFiredTriggers

integerNNDB 7.3.0
4000
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalOperations

integerNNDB 7.3.0
UNDEFINED
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfLocalScans

integerNNDB 7.3.0
[see text]
32 / 4294967039 (0xFFFFFEFF)

MaxNoOfOpenFiles

unsignedNNDB 7.3.0
0
20 / 4294967039 (0xFFFFFEFF)

MaxNoOfOrderedIndexes

integerNNDB 7.3.0
128
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSavedMessages

integerNNDB 7.3.0
25
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSubscribers

unsignedNNDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfSubscriptions

unsignedNNDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfTables

integerNNDB 7.3.0
128
8 / 20320

MaxNoOfTriggers

integerNNDB 7.3.0
768
0 / 4294967039 (0xFFFFFEFF)

MaxNoOfUniqueHashIndexes

integerNNDB 7.3.0
64
0 / 4294967039 (0xFFFFFEFF)

MaxParallelScansPerFragment

bytesNNDB 7.3.0
256
1 / 4294967039 (0xFFFFFEFF)

MaxStartFailRetries

unsignedNNDB 7.3.0
3
0 / 4294967039 (0xFFFFFEFF)

MemReportFrequency

unsignedNNDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

MinDiskWriteSpeed

numericSNDB 7.4.1
10M
1M / 1024G

MinFreePct

unsignedNNDB 7.3.0
5
0 / 100

NodeGroup

 ISNDB 7.3.0
[none]
0 / 65536

NodeId

unsignedISNDB 7.3.0
[none]
1 / 48

NoOfFragmentLogFiles

integerINNDB 7.3.0
16
3 / 4294967039 (0xFFFFFEFF)

NoOfReplicas

integerISNDB 7.3.0
2
1 / 4

Numa

booleanNNDB 7.3.0
1
...

ODirect

booleanNNDB 7.3.0
false
true, false

RealtimeScheduler

booleanNNDB 7.3.0
false
true, false

RedoBuffer

bytesNNDB 7.3.0
32M
1M / 4294967039 (0xFFFFFEFF)

RedoOverCommitCounter

numericNNDB 7.3.0
3
0 / 4294967039 (0xFFFFFEFF)

RedoOverCommitLimit

secondsNNDB 7.3.0
20
0 / 4294967039 (0xFFFFFEFF)

ReservedSendBufferMemory

bytesNNDB 7.3.0
256K
0 / 4294967039 (0xFFFFFEFF)

RestartOnErrorInsert

error codeNNDB 7.3.0
2
0 / 4

SchedulerExecutionTimer

µsecNNDB 7.3.0
50
0 / 11000

SchedulerSpinTimer

µsecNNDB 7.3.0
0
0 / 500

ServerPort

unsignedNNDB 7.3.0
[none]
1 / 64K

SharedGlobalMemory

bytesNNDB 7.3.0
128M
0 / 64T

StartFailRetryDelay

unsignedNNDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

StartFailureTimeout

millisecondsNNDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

StartNoNodeGroupTimeout

millisecondsNNDB 7.3.0
15000
0 / 4294967039 (0xFFFFFEFF)

StartPartialTimeout

millisecondsNNDB 7.3.0
30000
0 / 4294967039 (0xFFFFFEFF)

StartPartitionedTimeout

millisecondsNNDB 7.3.0
60000
0 / 4294967039 (0xFFFFFEFF)

StartupStatusReportFrequency

secondsNNDB 7.3.0
0
0 / 4294967039 (0xFFFFFEFF)

StopOnError

booleanNNDB 7.3.0
1
0, 1

StringMemory

% or bytesSNDB 7.3.0
25
0 / 4294967039 (0xFFFFFEFF)

TcpBind_INADDR_ANY

booleanNNDB 7.3.0
false
true, false

TimeBetweenEpochs

millisecondsNNDB 7.3.0
100
0 / 32000

TimeBetweenEpochsTimeout

millisecondsNNDB 7.3.0
0
0 / 256000

TimeBetweenGlobalCheckpoints

millisecondsNNDB 7.3.0
2000
20 / 32000

TimeBetweenInactiveTransactionAbortCheck

millisecondsNNDB 7.3.0
1000
1000 / 4294967039 (0xFFFFFEFF)

TimeBetweenLocalCheckpoints

number of 4-byte words, as a base-2 logarithmNNDB 7.3.0
20
0 / 31

TimeBetweenWatchDogCheck

millisecondsNNDB 7.3.0
6000
70 / 4294967039 (0xFFFFFEFF)

TimeBetweenWatchDogCheckInitial

millisecondsNNDB 7.3.0
6000
70 / 4294967039 (0xFFFFFEFF)

TotalSendBufferMemory

bytesNNDB 7.3.0
256K
0 / 4294967039 (0xFFFFFEFF)

TransactionBufferMemory

bytesNNDB 7.3.0
1M
1K / 4294967039 (0xFFFFFEFF)

TransactionDeadlockDetectionTimeout

millisecondsNNDB 7.3.0
1200
50 / 4294967039 (0xFFFFFEFF)

TransactionInactiveTimeout

millisecondsNNDB 7.3.0
[see text]
0 / 4294967039 (0xFFFFFEFF)

TwoPassInitialNodeRestartCopy

booleanNNDB 7.3.0
false
true, false

UndoDataBuffer

unsignedNNDB 7.3.0
16M
1M / 4294967039 (0xFFFFFEFF)

UndoIndexBuffer

unsignedNNDB 7.3.0
2M
1M / 4294967039 (0xFFFFFEFF)

Table C.3 Multi-Threaded Data Node Configuration Parameters

Parameter NameType or UnitsRestart TypeIn Version ... (and later)
Default Value
Minimum/Maximum or Permitted Values

MaxNoOfExecutionThreads

integerISNDB 7.3.3
2
2 / 72

NoOfFragmentLogParts

numericINNDB 7.3.3
4
4, 8, 12, 16, 24, 32

ThreadConfig

stringISNDB 7.3.0
''
...