Below are some basic HCL OneDB commands which might help you get familiar with the database.

  1. oninit -vy

oninit -vy is to start the engine where ‘v’ means in verbose mode and ‘y’ is for yes. There are many other options to start the engine in different modes. You can explore the options using oninit – command for help

2. onmode -kuy

onmode -kuy is used to stop the engine where ‘k’ means kill, ‘u’ means user sessions and ‘y’ means yes. There are many options where onmode utility is used. You can run onmode – for the utility help

3. onstat –

The onstat – command displays only the output header and the value that is returned from this command indicates the database server mode.

The header takes the following form:

Version–Mode (Type)–(Checkpnt)–Up Uptime–Sh_mem Kbytes 複製碼

Version

Product name and version number

Mode

Current operating mode

(Type)

If the database server uses High-Availability Data Replication, it indicates whether the type is primary or secondary. If the database server is not involved in data replication, this field does not appear. If the type is primary, the value P appears. If the type is secondary, the value S appears.

(Checkpoint)

Checkpoint flag

If it is set, the header might display two other fields after the mode if the timing is appropriate:

(CKPT REQ)

Indicates that a user thread has requested a checkpoint.

(CKPT INP)

Indicates that a checkpoint is in progress. During the checkpoint, access is limited to read only. The database server cannot write or update data until the checkpoint ends.

Uptime

Indicates how long the database server has been running.

If the system time is manually changed to the past and the server start-up time is later than the current system time, the uptime is not available. In this situation, the header displays the text  Uptime Unavailable.

Sh_mem

The size of database server shared memory expressed in kilobytes

A sample header for the database server follows:

If the database server is blocked, the onstat header output includes an extra line.

4. onstat -m

Use the onstat -m command to display the 20 most recent lines of the system message log. You can use the onstat -m command option with the database server in any mode, including offline.

Output from this command lists the full pathname of the message log file and the 20 file entries. A date-and-time header separates the entries for each day. A time stamp prefaces single entries within each day. The name of the message log is specified as MSGPATH in the ONCONFIG file.

5. onstat -d

Use the onstat -d command to show information about chunks in each storage space

6. onstat -l

Use the onstat -l command to display information about the physical logs, logical logs, and temporary logical logs.

7. onstat -u

Use the onstat -u command to display a profile of user activity.

8. Onstat -g sql

Use the onstat -g sql command to display SQL-related information about a session.

onstat -g sql session_id

Displays SQL information for a specific session

9. Onstat -g ses

Use the onstat -g ses command to display information about the session.

onstat -g ses

Displays a one-line summary for each session

onstat -g ses session_id

Displays information for a specific session

10. onstat -g ckp

Use the onstat -g ckp command to print checkpoint history and show configuration recommendations if a suboptimal configuration is detected.

For more options and other OneDB utilities please visit below URL:

https://help.hcltechsw.com/onedb/1.0.0.0/1infocenter/administering.html

Comment wrap
Further Reading
article-img
Data Management | February 23, 2022
All About the Configuration Parameters of OneDB Database  
Parameters are essential elements of any database instance. They help us achieve required performance goals or define the behaviour/characteristics of instance.
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. 
Close
Filters result by
Sort:
|