Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Startup Command and Parameter Reference

OpenEdge Database Server parameters (DBS)

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Introduction
    • About startup commands
    • About startup parameters
    • About parameter files
      • About calling parameter files
        • Call a parameter file in a startup command
        • Call a parameter file in a CONNECT statement
        • Call multiple parameter files
      • Create and edit parameter files
      • Parameter file format
      • Generate parameter files
      • Rules for generating parameter files
      • Format of the generated parameter file
  • Client Startup Commands
    • Client startup command syntax
    • Tasks you can perform with startup and shutdown commands
    • Client startup command descriptions
      • BPRO command
      • MBPRO command
      • MPRO command
      • PRO command
      • PROWIN32/PROWIN command (Windows only)
  • Startup Parameter Usage Categories
    • Client Session parameters (CS)
      • Client performance parameters
      • Client product-type parameters
      • ABL parameters
      • Client internationalization parameters
      • Session statistics parameters
      • Windows session parameters
    • Client Connection parameters (CC)
      • Client database connection parameters
    • OpenEdge Database Server parameters (DBS)
      • Database server performance parameters
      • Database server-type parameters
      • Database server internationalization parameters
      • Database server statistics collection parameters
      • Database server consistency check parameters
      • Database server network parameters
    • DataServer parameters (DS)
    • OpenEdge SQL Broker parameters (SQL)
  • Startup Parameter Descriptions
    • Single-user Mode (-1)
    • AdminServer Group (-admingroup)
    • AdminServer Port (-adminport)
    • After-image File Management Archive Directory List (-aiarcdir)
    • After-image File Management Archive Directory Create (-aiarcdircreate)
    • After-image File Management Archive Interval (-aiarcinterval)
    • After-image Buffers (-aibufs)
    • After-image Stall (-aistall)
    • Area consistency check (-AreaCheck)
    • Assemblies (-assemblies)
    • Async Queue Size (-asyncqueuesize)
    • Auto Reconnect (-autoReconnect)
    • Blocks in Database Buffers (-B)
    • Blocks in Alternate Buffer Pool (-B2)
    • Batch (-b)
    • ADE R-code Location (-baseADE)
    • Base Index (-baseindex)
    • Registry Base Key (-basekey)
    • Base LOB (-baselob)
    • Base Table (-basetable)
    • Base user LOB (-baseuserlob)
    • Base user index (-baseuserindex)
    • Base user table (-baseusertable)
    • Before-image Buffers (-bibufs)
    • Before-image scan time (-biscantime)
    • Threshold Stall (-bistall)
    • Recovery Log Threshold (-bithold)
    • Private Read-only Buffers (-Bp)
    • Maximum Private Buffers per Connection (-Bpmax)
    • Bleeding Record Lock (-brl)
    • Browse Column Type (-browcoltype)
    • Number of Buffers for Temporary Tables (-Bt)
    • Index Cursors (-c)
    • Schema Cache File (-cache)
    • CDC cache size (-cdcsize)
    • Catch STOP (-catchStop)
    • Certificate store path (-certstorepath)
    • Check Double-byte Enabled (-checkdbe)
    • Check Width (-checkwidth)
    • SQL Server Java Classpath (-classpath)
    • Clear Log (-clearlog)
    • Client Logging (-clientlog)
    • .NET Common Language Runtime (-clrnetcore)
    • Client Database-Request Statement Caching Directory (-clstmtcachedir)
    • Collation-Sensitive Operator (-collop)
    • Combo-box Font (-combofont)
    • Compiler Options File (-compileroptionsfile)
    • Conversion Map (-convmap)
    • Communications Parameter File (-cp)
    • Case Table (-cpcase)
    • Collation Table (-cpcoll)
    • Internal Code Page (-cpinternal)
    • Log File Code Page (-cplog)
    • Print Code Page (-cpprint)
    • R-code in Code Page (-cprcodein)
    • R-code Out Code Page (-cprcodeout)
    • Stream Code Page (-cpstream)
    • Terminal Code Page (-cpterm)
    • Crash Recovery Status (-crStatus)
    • Crash Recovery Transaction Display (-crTXDisplay)
    • Cursor Size (-cs)
    • C stack print option (-cstackPrintopt)
    • Connection Retry Attempts (-ct)
    • Compile Warning List (-cwl)
    • Directory Size (-D)
    • Date Format (-d)
    • DataService (-DataService)
    • Physical Database Name (-db)
    • Alternate Database 1 (-dbalt1)
    • Alternate Database 2 (-dbalt2)
    • Database consistency check (-DbCheck)
    • Database Notification Operations (-dbnotifyops)
    • Database Notification Time (-dbnotifytime)
    • Debugger (-debug)
    • Debug Alert (-debugalert)
    • Enable Attachable Debugging (-debugReady)
    • Default scrolling (-defaultscrolling)
    • Default Untranslatable (-defuntrans)
    • Diagnostic directory (-diagDir)
    • Diagnostic events value (-diagEvent)
    • Diagnostic event level (-diagEvtLevel)
    • Diagnostic data format (-diagFormat)
    • Diagnostic field separator (-diagFS)
    • Diagnostic pause length (-diagPause)
    • Diagnostic prefix value (-diagPrefix)
    • Diagnostic process (-diagProc)
    • Disable Delete Trigger (-disabledeltrig)
    • Dictionary Expressions (-dictexps)
    • Direct I/O (-directio)
    • Domain (-domain)
    • DataServer Logging (-dslog)
    • Maximum Dynamic DataServer Port (-dsmaxport)
    • Minimum Dynamic DataServer (-dsminport)
    • DataServer (-Dsrv)
    • Database Type (-dt)
    • European Numeric Format (-E)
    • Encryption cache size (-ecsize)
    • Enforce Mm (-enforceMm)
    • Entity Expansion Limit (-entityExpansionLimit)
    • Error Stack (-errorstack)
    • Event Level (-evtlevel)
    • Expand Browse (-expandbrow)
    • Force Access (-F)
    • Schema Field Cache Size (-fc)
    • Filtering Asynchronous COM Events (-filterocxevents)
    • Field List Disable (-fldisable)
    • Before-image Truncate Interval (-G)
    • Group Delay (-groupdelay)
    • Host Name (-H)
    • Number of Databases (-h)
    • Hardlimit (-hardlimit)
    • Hash Table Entries (-hash)
    • Buffer Hash Latch Factor (-hashLatchFactor)
    • Host Name Aliasing (-hostnameAliasing)
    • No Crash Protection (-i)
    • Dynamics Parameter (-icfparam)
    • Index consistency check (-IndexCheck)
    • Index Range Size (-indexrangesize)
    • Initialization File (-ininame)
    • Input Characters (-inp)
    • Internet Protocol (-ipver)
    • Initial Value Segment No Convert (-isnoconv)
    • Keyword Forget List (-k)
    • Key Alias (-keyalias)
    • Key Alias Password (-keyaliaspasswd)
    • Keystore path (-keystorepath)
    • Lock Table Entries (-L)
    • Local Buffer Size (-l)
    • Logical Database Name (-ld)
    • Lock Governor (-LGovernor)
    • Log file archive enable (-lgArchiveEnable)
    • Log file archive directory (-lgArchiveDir)
    • Log file truncate frequency (-lgTruncateFrequency)
    • Log file truncate size (-lgTruncateSize)
    • Log file truncate time (-lgTruncateTime)
    • Limit log file payload (-limitLgPayload)
    • Literal Question (-literalquestion)
    • Lock Table Hash Size (-lkhash)
    • Lock release (-lkrela)
    • Lock Timeout (-lkwtmo)
    • Language (-lng)
    • LOB range (-lobrangesize)
    • Log Entry Types (-logentrytypes)
    • Logging Level (-logginglevel)
    • Log Threshold (-logthreshold)
    • LRU force skips (-lruskips)
    • LRU alternate buffer pool force skips (-lru2skips)
    • Auto Server (-m1)
    • Secondary Login Broker (-m3)
    • Maximum Clients Per Server (-Ma)
    • Maximum Area Number (-maxAreas)
    • Maximum Dynamic Server (-maxport)
    • Maximum JTA Transactions (-maxxids)
    • Network Message Compression (-mc)
    • Memory consistency check (-MemCheck)
    • Delayed BI File Write (-Mf)
    • Minimum Clients per Server (-Mi)
    • Minimum Dynamic Server (-minport)
    • Message Buffer Size (-Mm)
    • Maximum Memory (-mmax)
    • Maximum Servers (-Mn)
    • Servers per Protocol (-Mp)
    • Maximum Servers Per Broker (-Mpb)
    • Record Buffer Size (-Mr)
    • Multi-tenancy Partition Cache Size (-mtpmsize)
    • Shared-memory Overflow Size (-Mxs)
    • User MUX Latches (-mux)
    • Number of Users (-n)
    • Network Type (-N)
    • Nap Time (-nap)
    • Nap Maximum (-napmax)
    • Nap Time Steps (-napstep)
    • Nested Blocks (-nb)
    • Login Governor (-nGovernor)
    • No Lock (-NL)
    • Message Wait (-Nmsgwait)
    • No Auto Result-list (-noautoreslist)
    • No Domain Support With the CAN-DO Function (-nocandodomain)
    • No Check Temp-table Names (-nochkttnames)
    • No Common Language Runtime (-noclr)
    • No Colons for Side Labels (-nocolon)
    • No Dialog Dispose (-nodialogdispose)
    • No Evaluation of Properties (-noevalprops)
    • No Garbage Collection (-nogc)
    • No Host Verify (-nohostverify)
    • No Inactive Indexes (-noinactiveidx)
    • No Auto-Increment Warnings (-noincrwarn)
    • Index Hint (-noindexhint)
    • No INT64 (-noint64)
    • Server Join (-nojoinbysqldb)
    • No routine in WHERE Clause (-noroutineinwhere)
    • No Session Cache (-nosessioncache)
    • No Session Reuse (-nosessionreuse)
    • SELECT Pass Through Disable (-noSQLbyserver)
    • No UDF in WHERE Clause (-noudfinwhere)
    • No Z-order Grouping (-nozgrouping)
    • Number of checkpoint statistics (-numCheckpointStats)
    • Fractional Separator (-numdec)
    • Number of Log Files to Keep (-numlogfiles)
    • Thousands Separator (-numsep)
    • Printer (-o)
    • OpenTelemetry Configuration (-otelconfig)
    • Outer-join Mode (-ojmode)
    • Omit Log Messages (-omitLgMsgs)
    • Storage Object Cache Size (-omsize)
    • OS-COMMAND SILENT fix (-ossilentfix)
    • OS User (-OSUser)
    • Password (-P)
    • Startup Procedure (-p)
    • Parameter (-param)
    • Prompt for Passphrase (-Passphrase)
    • Pending Connection Time (-PendConnTime)
    • Parameter File (-pf)
    • Database Service Communication Area Size (-pica)
    • Database PICA Queue Nap Time (-picanap)
    • Prompt for Pin (Pin)
    • Pin Shared Memory (-pinshm)
    • PROLIB Memory (-plm)
    • PROLIB Swap (-pls)
    • Prefetch delay (-prefetchDelay)
    • Prefetch factor (-prefetchFactor)
    • Prefetch Num Recs (-prefetchNumRecs)
    • Prefetch Priority (-prefetchPriority)
    • Preload CLR (-preloadCLR)
    • Profiler (-profile)
    • Profile Memory (-profileMemory)
    • Configuration Properties File (-properties)
    • Proxy Host (-proxyhost)
    • Proxy Password (-proxyPassword)
    • Proxy Port (-proxyport)
    • Proxy Userid (-proxyUserid)
    • Quick Request (-q)
    • Non-reliable I/O (-r)
    • Alternate Random Number Generator (-rand)
    • Record free chain search depth factor (-recspacesearchdepth)
    • Require Username (-requireusername)
    • Reread Fields (-rereadfields)
    • Reread Nolock (-rereadnolock)
    • Retry Connect Set (-retryConnect)
    • Retry Connect Set Pause (-retryConnectPause)
    • Re-usable Objects Cache (-reusableObjects)
    • Run ABL Client (-rg)
    • Read-only Media (-RO)
    • Run Query Client (-rq)
    • Run Run-time Client (-rr)
    • Encrypted Compiler Mode (-rx)
    • Service Name (-S)
    • Stack Size (-s)
    • Schema Lock Wait Queue (-schlockwq)
    • Screen-value Mode (-scrvalmode)
    • Security cache size (-secsize)
    • Semaphore Sets (-semsets)
    • Server Group (-servergroup)
    • Type of Server to Start (-ServerType)
    • Session Timeout (-sessiontimeout)
    • Shared memory segment size (-shmsegsize)
    • Show PPU Error (-showppuerr)
    • Spin Lock Retries (-spin)
    • Autonomous Update Statistics (-SQLAutoStats)
    • SQL Open Cursors (-SQLCursors)
    • Lock Wait Timeout (-SQLLockWaitTimeout)
    • SQL rowid identifier(-SQLQuotedRowid)
    • SQL Stack Size (-SQLStack)
    • SQL Statement Cache Size (-SQLStmtCache)
    • SQL Sorting Memory (-SQLTempBuff)
    • SQL Sorting on Disk (-SQLTempDisk)
    • SQL Temp Table Data Page (-SQLTempPageSize)
    • Authorized Data Truncation(-SQLTruncateTooLarge)
    • Autonomous Schema Update (-SQLWidthUpdate)
    • Server-side join (-ssj)
    • TLS-based Connection (-ssl)
    • Strict Entity Resolution (-strictEntityResolution)
    • Stash Area (-stsh)
    • STS logging level (-stslogginglevel)
    • Suppress Warnings (-sw)
    • Suppress Warnings List (-swl)
    • Temporary Directory (-T)
    • Save Temp Files (-t)
    • Table consistency check (-TableCheck)
    • Table Range Size (-tablerangesize)
    • Speed Sort (-TB)
    • Threaded Server (-threadedServer)
    • Threaded Server Stack (-threadedServerStack)
    • Temp-table Schema Marshal (-ttmarshal)
    • Merge Number (-TM)
    • Temporary Table Database Block Size (-tmpbsize)
    • Token (-tok)
    • Trigger Location (-trig)
    • Temp-Table Base Index (-ttbaseindex)
    • Temp-Table Base Table (-ttbasetable)
    • Temp-table Index Range Size (-ttindexrangesize)
    • Temp-Table Table Range Size (-tttablerangesize)
    • Temp-Table Word Rule (-ttwrdrul)
    • Transaction End (TXE) Lock Retry Limit (-TXERetryLimit)
    • Transaction End (TXE) Lock Skip Limit (-TXESkipLimit)
    • UNDO, THROW Error Handling (-undothrow)
    • User ID (-U)
    • Unicode layout expansion factor (-ulayout)
    • Use OS Locale (-useOsLocale)
    • User index range (-userindexrangesize)
    • User Table Range (-usertablerangesize)
    • USE_MERGE Hint (-nojoinhint)
    • User LOB range (-userlobrangesize)
    • Database Client Notification (-usernotifytime)
    • Use SESSION:TIMEZONE (-useSessionTZ)
    • Use Widget ID (-usewidgetid)
    • Version 6 Colon (-v6colon)
    • Version 6 Query (-v6q)
    • Windows Passthrough Printing (-Wa -wpp)
    • Wide Character Convert (-widecharconv)
    • Windows Single Session (-wss)
    • Windows Exit - No Dialog (-wy)
    • Statistics (-y)
    • Statistics with CTRL+C (-yc)
    • Segment Statistics (-yd)
    • Four Digit Year Default (-yr4def)
    • Statistics With Cross-reference (-yx)
    • Century Year Offset (-yy)
Table of Contents

OpenEdge Database Server parameters (DBS)

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: July 5, 2024
  • 1 minute read
    • OpenEdge
    • Version 12.8
    • Documentation

The OpenEdge Database Server parameters are organized alphabetically by syntax in the following subcategories:

  • Database server performance parameters
  • Database server-type parameters
  • Database server internationalization parameters
  • Database server statistics collection parameters
  • Database server consistency check parameters
  • Database server network parameters
Previous topic: Client Connection parameters (CC)
Next topic: DataServer parameters (DS)
TitleResults for “How to create a CRG?”Also Available inAlert