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.

Getting familiar with HCL OneDB

The header takes the following form:

Version–Mode (Type)–(Checkpnt)–Up Uptime–Sh_mem Kbytes Getting familiar with HCL OneDB

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.

Getting familiar with HCL OneDB

5. onstat -d

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

Getting familiar with HCL OneDB

6. onstat -l

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

Getting familiar with HCL OneDB

7. onstat -u

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

Getting familiar with HCL OneDB

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

Getting familiar with HCL OneDB

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

Getting familiar with HCL OneDB Getting familiar with HCL OneDB

10. onstat -g ckp

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

Getting familiar with HCL OneDB

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  
Learn everything about the Configuration Parameters of OneDB Database with HCLSoftware & why they are essential elements of any database instance.
article-img
Data Management | February 14, 2022
Quick Tips: Successful Database Management Evaluation
Tips for database management of product and its demonstrations a chance to view features, determine software’s intuitive capability, and collect the best understanding.
article-img
Cloud Native | January 28, 2022
HCLSoftware Enters Business Partnership with Four Js Development Tools to Modernize Applications in the Database Market
Learn why HCLSoftware enters Business Partnership with Four Js Development Tools to Modernize Applications in the Database Market with HCL OneDB.
Close
Filters result by
Sort:
|