Startup Parameters

Displays values of OpenEdge database startup parameters.

PROMON Startup Parameters Status display

The following shows a sample Startup Parameters Status display.

03/07/17        Status: Startup Parameters
20:15:46

              After-image Management Archival Directory List (-aiarcdir): Not Enabled
   Create After-image Management Archival Directory(s) (-aiarcdircreate): Not Enabled
               After-image Management Archival Interval (-aiarcinterval): -1
                                 Number of After-Image Buffers (-aibufs): 64
                                            After-Image Stall (-aistall): Not Enabled
                 Starting index number for statistics range (-baseindex): 1
                 Starting table number for statistics range (-basetable): 1
    Starting index number per user for statistics range (-baseuserindex): 1
    Starting table number per user for statistics range (-baseusertable): 1
                                Number of Before-Image Buffers (-bibufs): 64
                                      BI File Threshold Stall (-bistall): Disabled.
                                       BI File Threshold size (-bithold): 0.0   Bytes
                                         Database Blocksize (-blocksize): 4096
                                             BIW writer delay (-bwdelay): 0
                                              Allowed index cursors (-c): 84
                                               CDC cache size (-cdcsize): 200k bytes
                             SSL Certificate Store Path (-certstorepath): Not Enabled
                                             Character Set (-cpinternal): iso8859-1
                                            Physical Database Name (-db): jan28
                                         Diagnostic directory (-diagDir): Not Enabled
      Diagnostic events value (-diagEvent): LockTable:0,BiThold:0,SysErr:0
                                  Diagnostic event level (-diagEvtLevel): 0
                                    Diagnostic field separator (-diagFS): ' '
                                    Diagnostic data format (-diagFormat): csv
                                    Diagnostic pause length (-diagPause): 0
                                   Diagnostic prefix value (-diagPrefix): diagEvent_
                                        Diagnostic procedure (-diagProc): Not Enabled
                                                  Direct I/O (-directio): Not Enabled
                                                     Database Type (-dt): PROGRESS
                                         Encryption cache size (-ecsize): 1000
                                               Group delay (-groupdelay): 10
                                              Hash Table Entries (-hash): 887
                             Buffer hash latch factor (-hashLatchFactor): 10
                                                     Crash Recovery (-i): Enabled
   Number of indexes included in statistics collection (-indexrangesize): 50
                                                 TCP/IP Version (-ipver): Not Enabled
                                          SSL Key Alias Name (-keyalias): Not Enabled
                                    Lock table hash table size (-lkhash): 1237
                               Original Lock Release Algorithm (-lkrela): Not Enabled
                                   Number of LRU force skips (-lruskips): 100
                                 Number of LRU2 force skips (-lru2skips): 100
                                          Maximum Area Number (-maxArea): 32000
                                Size of JTA transaction table (-maxxids):  100
                                Maximum Port for Auto Servers (-maxport): 0
                                Minimum Port for Auto Servers (-minport): 0
                          Multi-tenancy partition cache size (-mtpmsize): 1024
                                                   Use muxlatches (-mux): 1
                                            Maximum Number of Users (-n): 21
                    Minimum time to nap at first -spin exhaustion (-nap): 10
                       Maximum time to nap at -spin exhaustion (-napmax): 250
                                      SSL No Host Verify (-nohostverify): Not Enabled
                                          Disable LRU mechanism (-nolru): Not Enabled
                                  SSL No Session Cache (-nosessioncache): Not Enabled
                                  SSL No Session Reuse (-nosessionreuse): Not Enabled
                                             Login Governor (-nGovernor): 0 of 21
         Number of checkpoint statistics to record (-numCheckpointStats): 32
                                     Storage object cache size (-omsize): 1024
                       Database Service Manager - IPC Queue Size (-pica): 131072  KBytes
                                 Database PICA queue nap time (-picanap): 1 ms
                                 Shared memory segments locked (-pinshm): Not Enabled
                      Use pollset mechanism for client/server (-pollset): Not Enabled
                           Delay first prefetch message (-prefetchDelay): Enabled
                      Prefetch message fill percentage (-prefetchFactor): 100
                      Minimum records in prefetch msg (-prefetchNumRecs): 64
                      Suspension queue poll priority (-prefetchPriority): 1
                   APW queue scan cycle time in milliseconds (-pwqdelay): 100
                         APW minimum queue length before write (-pwqmin): 1
                       APW buffer scan cycle time in seconds (-pwsdelay): 1
               APW maximum number of buffers to scan per cycle (-pwscan): 5
              APW maximum number of buffers to write per cycle (-pwwmax): 25
                                           Before-Image File I/O (-r -R): Reliable
            Record free chain search depth factor (-recspacesearchdepth): 5
                                          Security cache size (-secsize): 512
                                     Number of Semaphore Sets (-semsets): 3
                                   SSL Session Timeout (-sessiontimeout): 0
                        Maximum Shared Memory Segment Size (-shmsegsize): 0 Mb
                                         Current Spin Lock Tries (-spin): 24000
                            SSL Encryption for TCP/IP connections (-ssl): Not Enabled
                      STS Debug Logging Level default (-stslogginglevel): 0
    Number of tables included in statistics collection (-tablerangesize): 50
                                User Notification Time (-usernotifytime): 0 seconds
Number of indexes per user included in statistics collection (-userindexrangesize): 50
Number of tables per user included in statistics collection (-usertablerangesize): 50
                               Area block consistency check (-AreaCheck): Not Enabled
                                         Number of Database Buffers (-B): 3000
                              Number of Alternate Database Buffers (-B2): 0
                               Maximum private buffers per user (-Bpmax): 64
                             Database block consistency check (-DbCheck): Not Enabled
             Database Service Manager - Service(s) to start (-DBService): Not Enabled
                                          Enhanced Read-Only mode (-ERO): Not Enabled
                                                       Force Access (-F): Not Enabled
                                     Before-Image Truncate Interval (-G): 0
                                                          Host Name (-H): Not Enabled
                             Index block consistency check (-IndexCheck): Not Enabled
                                         Current Size of Lock Table (-L): 8192
                                              Lock Governor (-LGovernor): 0% 
                              Maximum Number of Clients Per Server (-Ma): 4
                                      Memory overwrite check (-MemCheck): Not Enabled
                                       Delay of Before-Image Flush (-Mf): 3
                                        Minimum Clients Per Server (-Mi): 0
                                               Message Buffer Size (-Mm): 8192
                                         Maximum Number of Servers (-Mn): 5
                                              Servers per Protocol (-Mp): 0
                                       Maximum Servers Per Broker (-Mpb): 0
                                        Excess Shared Memory Size (-Mxs): 26
                                                       Network Type (-N):
                            Server network message wait time (-Nmsgwait): 2
                    Pending client connection timeout (-PendConnTimeout): 0
                                                       Service Name (-S): 0
                               Broker server group support (-ServerType): BOTH
                               SQL Server Max Open Cursors (-SQLCursors): 0
                                       SQL Server Stack Size (-SQLStack): 0
                         SQL Server Statement Cache Size (-SQLStmtCache): 0
Size [1K byte units] of SQL Server temp table buffer (-SQLTempStoreBuff): 0
Size [1K byte units] of SQL Server temp table disk storage (-SQLTempStoreDisk): 0
Size [1K byte units] of SQL Server temp table data page (-SQLTempStorePageSize): 0
                       Authorized data truncation (-SQLTruncateTooLarge): OFF
                          SQL Autonomous Schema Update (-SQLWidthUpdate): OFF
                            Record block consistency check (-TableCheck): Not Enabled
                                   TXE Lock retry limit (-TXERetryLimit): 0
                              TXE Commit lock skip limit (-TXESkipLimit): 10000

                

The display contains every startup parameter in alphabetical order. See Database Startup Parameters .