Parameter management

The users can view and manage the parameters required for the usersr database setup in OwlDB. For multi-cluster configurations, the management history is reflected in bulk. If the database operation status is not Running or the instance status is Recovery or Disconnect, the users cannot modify parameters.

Figure 1. Parameter Management

Veiwing Parameters

1. Navigate to the OwlDB Console screen > Administration > Parameters> setting menu.

2. Click DB Alias, Instance Alias drop-down buttons to pull down the database and instance for which the users want to set parameters.

3. View the list of parameters.

• The users can filter by data type and whether it is a dynamic parameter.

• The users can search and view the name and parameter value directly

Item	Description
Name	Parameter name
Data type	Parameter data type
Default Value	Parameter default value
Current Value	The current value of the parameter as set by the user
Config Value	Parameter value to be applied on restart (currently temporarily applied)
Dynamic Parameter	Whether the parameter is dynamic

---

Setting parameter (modify)

1. Navigate to the OwlDB Console screen > Administration > Parameters> setting menu.

2. Click the DB Alias, Instance Alias drop-down buttons to pull down the database and instance for which the users want to set the parameter.

3. Click the Edit button.

4. Modify parameter values.

• The users can filter by data type and whether it is a dynamic parameter.

• The users can search for and edit the name and parameter value directly.

Note

The parameter name highlighted in blue is the value the users are currently modifying.

1. Click the Import button to pull down the templates saved in 'Parameter Templates' to apply.

2. Click the Save button.

Note

If the users are modifying only dynamic parameters, the users can pull down the Save option.

• Clicking the Save button will apply the modified values immediately without restarting the database.

• If the users click the Save Temporarily button, the modifications will be applied temporarily. They will be restored to the Config Value value on a subsequent database restart.

Caution

If the users make modifications including static parameters, the database must be restarted for the modified values to take effect. Upon restart, all currently connected sessions will be terminated. It may take a few minutes before they are reactivated.

---

Parameter templates

Figure 2. Parameter templates

1. Navigate to the OwlDB console screen > Administration > Parameters > Templates menu.

2. Click the DB Alias, Instance Alias drop-down buttons to pull down the database and instance for which the users want to view parameter templates.

3. Check the list of parameter templates.

Item	Descriptio
OLTP	Template designed to cope with fast processing speed and high transaction frequency
OLAP	Template optimized for large-scale data analysis and complex queries

1. Click the 'Parameter template name' to see the detailed parameter values.

• The users can filter by data type and whether it is a dynamic parameter.

• The users can search for names and parameter values directly.

1. Click the Apply button to apply the parameter template.

Caution

The database must be restarted for the modifications to take effect. Upon restart, all currently connected sessions will be terminated. It may take a few minutes before they are reactivated.Parameter Revision History

---

Parameter Revision History

Figure 3. Parameter modification history

1. Navigate to OwlDB Console screen > Administration > Parameters > Modification History menu.

2. Click the DB Alias, Instance Alias drop-down buttons to pull down the database and instance for which the users want to check the parameter modification history.

3. Check the parameter modification history.