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.

AGENTDISPLAYMESSAGELEVEL

AGENTLEASEEXPIRATIONTIME

AGENTLEASEMAXRETRYCOUNT

AGENTLEASERENEWALTIME

AGENTLOGMESSAGELEVEL

AGTSVRCONNECTIONS

AUTHENTICATIONMODULE

CALCLIMITFORMULARECURSION

DISPLAYMESSAGELEVEL

DLSINGLETHREADPERSTAGE

DLTHREADSPREPARE

ENABLE_DIAG_TRANSPARENT_PARTITION

ENABLESWITCHTOBACKUPFILE

EXCEPTIONLOGOVERWRITE

FORCEGRIDEXPANSION

GRIDEXPANSIONMESSAGES

HAMAXNUMCONNECTION

HAMAXNUMSQLQUERY

HAMEMORYCACHESIZE

HARAGGEDHIERARCHY

HARETRIEVENUMROW

HASOURCEDSNOS390

JVMMODULELOCATION

LOGINFAILUREMESSAGEDETAILED

LOGMESSAGELEVEL

NETBINDRETRYDELAY

NOMSGLOGGINGONDATAERRORLIMIT

NUMERICPRECISION

NUMBEROFSECFILEBACKUPS

OUTLINECHANGELOG

OUTLINECHANGELOGFILESIZE

PORTUSAGELOGINTERVAL

PRELOADUDANAMESPACE

SECFILEBACKUPINTERVAL

SECURITYFILECOMPACTIONPERCENT

SERVERLEASEEXPIRATIONTIME

SERVERLEASEMAXRETRYCOUNT

SERVERLEASERENEWALTIME

SERVERPORTBEGIN

SQLFETCHERRORPOPUP

SSOPTIMIZEDGRIDPROCESSING

TARGETTIMESERIESOPT

TRANSACTIONLOGDATALOADARCHIVE

TRANSACTIONLOGLOCATION

UNICODEAGENTLOG

The following settings apply only to block storage databases.

AGGRESSIVEBLKOPTIMIZATION

CALCCACHEDEFAULT

CALCLIMITFORMULARECURSION

CALCOPTFRMLBOTTOMUP

CALCREUSEDYNCALCBLOCKS

DATAEXPORTENABLEBATCHINSERT

DATAFILECACHESIZE

DELAYEDRECOVERY

DYNCALCCACHEBLKRELEASE

DYNCALCCACHEBLKTIMEOUT

DYNCALCCACHECOMPRBLKBUFSIZE

DYNCALCCACHEMAXSIZE

DYNCALCCACHEONLY

DYNCALCCACHEWAITFORBLK

FORCEALLDENSECALCON2PASSACCOUNTS

IBHFIXTHRESHOLD

MULTIPLEBITMAPMEMCHECK

PARCALCMULTIPLEBITMAPMEMOPT