Lets you modify specific database startup parameters while the database is online.

PROMON Adjust Startup Parameters display

The following shows a sample display of the PROMON utility menu when 16 is invoked from the R&D Advanced Options menu followed by 4 from the Administrative Functions menu.

          OpenEdge Release 13 Monitor (R&D)
          Adjust Startup Parameters

          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
          After-Image Stall (-aistall): Not Enabled
          Starting index number for statistics range (-baseindex): 1
          Starting LOB number for statistics range (-baselob): 1
          Starting table number for statistics range (-basetable): 1
          Starting index number per user for statistics range (-baseuserindex): 1
          Starting LOB number per user for statistics range (-baselob): 1
          Starting table number per user for statistics range (-baseusertable): 1
          BI Scan Time (-biscantime): 0 seconds
          BI File Threshold Stall (-bistall): Disabled.
          BI File Threshold size (-bithold): 0.0   Bytes
          BIW writer delay (-bwdelay): 0
          C stack print option (-cstackPrintopt): 0
          Number of DB Notification Operations (-dbnotifyops): 16
          DB Notification Time (-dbnotifytime): 30 seconds
          Diagnostic directory (-diagDir): Not Enabled
          Diagnostic events value (-diagEvent): LockTable:0,BiThold:0,SysErr:0
          Diagnostic event level (-diagEvtLevel): 0         
                                                  
Enter a parameter name, <return>, R, P, T, or X (? for help):

Perform the following steps to modify a database startup parameter while the database is online:

  1. Enter the parameter keyword including the dash (-) as in the example below.
                                                      
Enter a parameter name, <return>, R, P, T, or X (? for help): -aistall
  2. An error message is returned if the parameter is not valid.
                                                      
Invalid parameter name. Please try again.

Enter a parameter name, <return>, R, P, T, or X (? for help):

    Else if valid, PROMON will return the current value of the parameter in shared memory. Enter a new value for the parameter in the prompt as in the example below. 

                                                     
Current After-Image Stall (-aistall): Not Enabled

Enter a new value for -aistall (0 to 1): 1
  3. If valid, PROMON returns a confirmation of the update to show the new value as in the example below.
                                                     
Enter a new value for -aistall (0 to 1): 1

New After-Image Stall (-aistall): Enabled

Notes

  • Only specific startup parameters may be modified while the database is online. For more information on a specific parameter, see Change database parameters while the database is running.
  • PROMON lists those database startup parameters that are modified online. The full range is not displayed on one screen. You may scroll through the list of parameters and current values using <return> or else adjust the display line per PROMON menu to display all the parameters on one screen.
  • Use R to return to the first page of parameters while scrolling.
  • For database startup parameters that possess a range of values between a minimum and maximum, PROMON displays this range when prompting the user to enter a new value. For more information on these values, see Change database parameters while the database is running.
  • When entering the name of a parameter to be changed, the parameter name must match exactly and include the dash (-), or PROMON returns an error.
  • Any valid parameter name may be entered from any of the Adjust Startup Parameters menu pages. There is no need to be on the current page of the menu when entering a parameter name.
  • Use (CTRL+C) at the prompt to cancel the operation.