This option enables you to 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 Administrative Functions menu menu. To get to the Administrative Functions menu, open proenv and enter promon database-name followed by R&D. This opens the R&D Advanced Options menu. In the R&D Advanced Options menu, select option 4. Administrative Functions menu. Choose option 16. Adjust Startup Parameters of Administrative Functions menu to open the Adjust Startup Parameters menu. Form the Adjust Startup Parameters menu, you can modify the database startup parameters.

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

          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 File Threshold Stall (-bistall): Disabled.
          BI File Threshold size (-bithold): 0.0   Bytes
          BIW writer delay (-bwdelay): 0
          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
                                                  
Enter a parameter name, <return>, R, P, T, or X (? for help):

Modify Database Parameters

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. See Change database parameters while the database is running for more information on a specific parameter.
  • 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.