Parameters are essential elements of any database instance. They help us achieve required performance goals or define the behaviour/characteristics of instance.

 

Some parameters can be tuned while the database instance is running and some need to be adjusted while the instance is down. Therefore, beforehand knowledge of these parameters tuning scope is a handy tool for a DBA (Database Administrator).

 

In OneDB, we can classify parameters as static or dynamic:

 

The static parameter must be set with the instance stopped, editing the onconfig  file, and starting the OneDB. If the onconfig is edited with the instance initialized, the parameter will only take effect after the database server is shut down and restarted.

 

However, dynamic parameters can be changed using the onmode utility while the server is online.

 

Dynamic parameters can be further classified as Persistent and non-persistent:

 

Persistent: can be changed in only onconfig (use onmode -wf only)
Non-persistent: can be changed in file and memory ( onmode -wf/wm both)

 

A picture containing polygon Description automatically generated

 

How to update parameters dynamically:

 

onmode -wf –> will update in onconfig and memory
onmode -wm –> will update only in memory

 

In OneDB we can check the nature of parameters by using onstat -g cfg

 

Here is the list of all the options of onstat -g cfg

 

cfg         == basic info: name and current value of all params
cfg <name> == basic info for the given parameter
cfg full    == all info, all params
cfg tunable == params that can be changed on the fly
cfg diff    == params that have been adjusted or modified
cfg msg     == params that generated a warning or error message

 

Regarding the onstat -g cfg :

- type, data type for the value.
- maxlen,  max length of the value.
- units, in which the value is expressed.
- rsvd,  indicates (with an asterisk) that the configuration parameter and its value are stored on the configuration reserved page.
- tunable, shows (with an asterisk) that the configuration parameter can be tuned dynamically, for example, with an onmode -wm or -wf command.
- min/max, the lower and upper limit that the value can be set.
- description, text explaining the parameter and the values it can have.

 

Below are the examples of using this utility.

 

  • To get list of all tunable parameters:

 

onstat -g cfg tunable

 

  • All details of an onconfig parameter –> onstat -g cfg full <parameter_name >

 

Static: (tunable –> blank)

 

Text Description automatically generated

 

Dynamic: Persistent (tunable –> persistent only)

 

Text Description automatically generated

 

Dynamic: Non-Persistent (tunable –> *)

 

Text Description automatically generated

 

Learn more about HCL OneDB here, or contact us!

Comment wrap
Further Reading
article-img
Data Management | February 14, 2022
Quick Tips: Successful Database Management Evaluation
Working in the tech industry, you’ve undoubtedly experienced sitting through a software demonstration that, to be generous, put you to sleep. The problem is that most demos focus solely on product features, and the audience is usually more concerned with their own specific needs. When considering a database management product, demonstrations are a chance to view features, determine a software’s intuitive capability, and garner the best understanding of how the tool will work within the scope of your data and business needs. To get the most from a demo, it is necessary to first identify what business needs you are looking to solve.
article-img
Cloud Native | January 28, 2022
HCL Software Enters Business Partnership with Four Js Development Tools to Modernize Applications in the Database Market
HCL Software announced the business partnership with Four Js Development Tools to collaborate on a campaign to modernize legacy mission-critical applications in the database market with the help of HCL Software’s product, HCL OneDB. 
article-img
Data Management | January 26, 2022
Duplicate your server using ifxclone utility
Use the ifxclone utility to clone a server with minimum setup or configuration or quickly add a new node to an existing ER replication domain. Read the blog to know more.
Close
Filters result by
Sort:
|