Aggregate Storage and Block Storage Settings Comparison

The following settings apply only to aggregate storage databases.

The following settings apply to aggregate storage databases and to block storage databases.

AGENTDELAY

AGENTDISPLAYMESSAGELEVEL

AGENTLEASEEXPIRATIONTIME

AGENTLEASEMAXRETRYCOUNT

AGENTLEASERENEWALTIME

AGENTLOGMESSAGELEVEL

AGENTPORT

AGENTTHREADS

AGTSVRCONNECTIONS

AUTHENTICATIONMODULE

CALCLIMITFORMULARECURSION

CALCPARALLEL

CLEARLOGFILE

CRASHDUMP

DATAERRORLIMIT

DELIMITEDMSG

DELIMITER

DISPLAYMESSAGELEVEL

DLSINGLETHREADPERSTAGE

DLTHREADSPREPARE

ENABLE_DIAG_TRANSPARENT_PARTITION

ENABLESWITCHTOBACKUPFILE

EXCEPTIONLOGOVERWRITE

FAILOVERMODE

FORCEGRIDEXPANSION

GRIDEXPANSION

GRIDEXPANSIONMESSAGES

HAENABLE

HAMAXNUMCONNECTION

HAMAXNUMSQLQUERY

HAMAXQUERYROWS

HAMAXQUERYTIME

HAMEMORYCACHESIZE

HARAGGEDHIERARCHY

HARETRIEVENUMROW

HASOURCEDSNOS390

JVMMODULELOCATION

LOGINFAILUREMESSAGEDETAILED

LOGMESSAGELEVEL

MAXLOGINS

NETBINDRETRYDELAY

NETDELAY

NETRETRYCOUNT

NOMSGLOGGINGONDATAERRORLIMIT

NUMERICPRECISION

NUMBEROFSECFILEBACKUPS

OUTLINECHANGELOG

OUTLINECHANGELOGFILESIZE

PIPEBUFFERSIZE

PORTINC

PORTUSAGELOGINTERVAL

PRELOADUDANAMESPACE

QRYGOVEXECTIME

SECFILEBACKUPINTERVAL

SECURITYFILECOMPACTIONPERCENT

SERVERLEASEEXPIRATIONTIME

SERVERLEASEMAXRETRYCOUNT

SERVERLEASERENEWALTIME

SERVERPORTBEGIN

SERVERPORTEND

SERVERTHREADS

SILENTOTLQUERY

SQLFETCHERRORPOPUP

SSAUDITR

SSLOGUNKNOWN

SSOPTIMIZEDGRIDPROCESSING

SSPROCROWLIMIT

SUPNA

TARGETTIMESERIESOPT

TIMINGMESSAGES

TRANSACTIONLOGDATALOADARCHIVE

TRANSACTIONLOGLOCATION

TRIGMAXMEMSIZE

UNICODEAGENTLOG

The following settings apply only to block storage databases.

AGGRESSIVEBLKOPTIMIZATION

CALCCACHE

CALCCACHEHIGH

CALCCACHEDEFAULT

CALCCACHELOW

CALCLIMITFORMULARECURSION

CALCLOCKBLOCK

CALCMODE

CALCNOTICE

CALCOPTFRMLBOTTOMUP

CALCREUSEDYNCALCBLOCKS

CALCTASKDIMS

CCTRACK

DATACACHESIZE

DATAEXPORTENABLEBATCHINSERT

DATAFILECACHESIZE

DELAYEDRECOVERY

DEXPSQLROWSIZE

DIRECTIO

DISKVOLUMES

DLTHREADSWRITE

DYNCALCCACHEBLKRELEASE

DYNCALCCACHEBLKTIMEOUT

DYNCALCCACHECOMPRBLKBUFSIZE

DYNCALCCACHEMAXSIZE

DYNCALCCACHEONLY

DYNCALCCACHEWAITFORBLK

EXCLUSIVECALC

FORCEALLDENSECALCON2PASSACCOUNTS

EXPORTTHREADS

IBHFIXTHRESHOLD

INCRESTRUC

INDEXCACHESIZE

LOCKTIMEOUT

LROONSHAREDMBR

MULTIPLEBITMAPMEMCHECK

PARCALCMULTIPLEBITMAPMEMOPT

QRYGOVEXECBLK

RESTRUCTURETHREADS

SSAUDIT

UPDATECALC

VLBREPORT