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)法語Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Startup Command and Parameter Reference

Database server-type parameters

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

Database server-type parameters

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

Use the parameters listed in the following table to start a particular type of server.

Syntax Parameter Purpose
-m1 Auto Server (-m1) Starts an auto server; used internally by the database broker
-m3 Secondary Login Broker (UNIX, Windows only) Starts a secondary broker
-ServerType [4GL|SQL|Both]
Type of Server to Start (-ServerType) Specifies whether to start an OpenEdge server, SQL server, or both
TitleResults for “How to create a CRG?”Also Available inAlert