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
  • 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 Table (-basetable)
    • Base user index (-baseuserindex)
    • Base user table (-baseusertable)
    • Before-image Buffers (-bibufs)
    • 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)
    • Cluster Mode (-cluster)
    • 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)
    • Connection Retry Attempts (-ct)
    • Compile Warning List (-cwl)
    • Directory Size (-D)
    • Date Format (-d)
    • DataService (-DataService)
    • Physical Database Name (-db)
    • Database consistency check (-DbCheck)
    • Debugger (-debug)
    • Debug Alert (-debugalert)
    • Enable Attachable Debugging (-debugReady)
    • Default scrolling (-defaultscrolling)
    • 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)
    • 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)
    • 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)
    • 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)
    • Shared-memory Overflow Size (-Mxs)
    • User MUX Latches (-mux)
    • Number of Users (-n)
    • Nap Time (-nap)
    • Nap Maximum (-napmax)
    • 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)
    • 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)
    • 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)
    • 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)
    • 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)
    • 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)
    • Authorized Data Truncation(-SQLTruncateTooLarge)
    • Autonomous Schema Update (-SQLWidthUpdate)
    • Server-side join (-ssj)
    • TLS-based Connection (-ssl)
    • Strict Entity Resolution (-strictEntityResolution)
    • Stash Area (-stsh)
    • 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)
    • 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)
    • 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: October 30, 2020
  • 1 minute read
    • OpenEdge
    • Version 12.2
    • 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