OneDB is a flexible database server that manages traditional relational, object-relational and dimensional databases. OneDB database server runs on Unix, Linux, and Windows operating systems.

OneDB Explore is a modernized tool for monitoring and managing your OneDB database servers. It imparts performance management capabilities, examines how key performance metrics are changing with time, and tracks how efficiently OneDB is working even when you are away from your screen. It notifies about issues arising on one of your OneDB database server instances via email, Twilio or PagerDuty.

OneDB Explore is a focal point for graphical monitoring, alerting and administration of your OneDB database servers.

After logging in to OneDB Explore, you will be directed to group dashboard for the root group. This dashboard contains zero servers and zero groups.

  • Adding Servers and Group
  • Click the Add Server button to add connection information for your OneDB database server instances.
  • Provide monitoring and admin credentials.
    • The monitoring credentials are used by OneDB Explore server and agent to gather data from OneDB database server instance.
    • The admin credentials are used for administration action performed on the database server, for example create a dbspace, edit an onconfig parameter, or deploy an agent.
  • Click the Add Group button to create group of servers that makes it easier to monitor and manage multiple servers.

HCL OneDB

  • Monitoring
  • OneDB Explore has built in, customizable sensors for monitoring database servers.
  • The agent is facilitated to monitor database server status automatically.
  • Whenever a change is detected, it immediately notifies as a “status” update.
  • The sensors to be monitored in the UI are defined by the user.
  • For gathering monitoring data, agent runs the sensor metrics classes by –
    • Running queries against the sysmaster database
    • Running onstat commands
    • Running OS command for host machine monitoring
  • Monitoring data is stored into a repository database that is configured by the user.

HCL OneDB

  • Alerting

Alerts are fully customizable. You can decide on what you want to be alerted on or the condition that triggers an alert. Group level alerts simplify the process of managing the alerts for multiple servers. You can modify or disable an inherited alert. If an alerting condition is met, an alerting incident is created.

  • In the OneDB Explore when an alerting condition is defined, OneDB Explore server subscribes the sensor’s data from the agent.
  • Through monitoring profile, agent gathers monitoring data for the sensor from the OneDB database server.
  • Every time a new monitoring data point is gathered, the agent sends a web socket message to the OneDB Explore server.
  • The new monitoring data point is evaluated against the defined alerting condition rule by OneDB Explore server.
  • If the alerting condition proves to be true, the OneDB Explore server creates an alerting incident.
  • OneDB Explore users that are subscribed to alerting notifications, OneDB Explore server will send alerting incident message (email,Twilio,PagerDuty).

HCL OneDB

HCL OneDB

  • OneDB Visualization and Administration

HCL OneDB

  • Enterprise Replication
  • It enables the visualization of ER domain.
  • ER node list consists of –
    • Member servers (stand-alone vs. cluster)
    • Node type (root, non-root, leaf)
    • Server version
  • ER node statistics consists of –
    • Capture, apply and network status
    • Number of connection nodes
    • Pages until block
    • Spooled and pending transactions
    • Disk usage
    • Average latency
    • Fail rate
    • ATS/RIS file count

HCL OneDB

HCL OneDB

  • High Availability
  • It enables the visualization of high availability cluster
    • Cluster topology
    • Details of primary and secondary server status
    • SMX status
  • Provide feasibility to view and edit HA onconfig parameters.
  • Performance of the cluster can be monitored.
  • Agent sensors for monitoring HA status and performance for –
    • HA connection status
    • HA CPU workload %
    • HA transaction latency
    • HA lag time for each server in the cluster
    • HA logical log rate (log records processed per second)
    • HA log backlog
  • The history of the metrics can be viewed graphically in the UI.

HCL OneDB

HCL OneDB

  • Schema Manager

The Schema Manager allows you to browse and view detailed information about the various tables and indexes in OneDB databases.

  • It can be used to –
    • View detailed information about databases
    • View detailed information about tables
    • Create a database
    • Create a demo database
    • Drop a database
    • Create an Index
    • Delete an Index

HCL OneDB

HCL OneDB

  • Storage – Tables and Indexes
  • Enables the analysis of storage characteristics of the table and indexes in OneDB databases.
    • Estimated compression savings
    • Page usage
  • Achieve storage optimization actions by –
    • Compress and uncompress
    • Shrink
    • Repack
    • Defragment
    • Remove in-place alters
  • Manages the storage optimization policies.

HCL OneDB

HCL OneDB

  • System Reports

Feature reports on various aspects of OneDB database server’s performance.

HCL OneDB

HCL OneDB

  • Task Scheduler
  • Manages and customizes sysadmin tasks for OneDB database server.
  • Features Ad-hoc task executions.

HCL OneDB

HCL OneDB

  • Auto Update Statistics
  • Manages the automatic update statistics policies.
  • Ensures that the queries run efficiently as your data changes over time.

HCL OneDB

HCL OneDB

  • Connection Manager (CM)

It allows you to visualize and manage CM unit, SLA and FOC for any CM.

  • View all connection units
  • View/add/modify/delete SLA within connection units
  • View/add/modify FOC within connection units
  • View or get alerts for number of SLA connections

HCL OneDB HCL OneDB

HCL OneDB

  • Privileges
  • It allows you to view and manage privileges on OneDB database server.
    • Database level privileges
    • Table level privileges
    • SQL Admin API privileges
    • Internal users (mapped users)

HCL OneDB

HCL OneDB

  • Memory Manager and Backups
  • It allows you to visualize and monitor your database server’s memory usage.
  • It allows you to build Low Memory Manager configuration.
  • Backup supports –
    • View backup status
    • Configure regular backups
    • Run ad-hoc backups
    • View backup logs

HCL OneDB

HCL OneDB

  • Custom Dashboard
  • It allows you to import & export custom dashboard.
  • It allows you to graph for custom query.
  • Panels for visualization –
    • Bar Chart
    • Pie Chart
    • Tabular

HCL OneDB

HCL OneDB

HCL OneDB

  • Summary

HCL OneDB

In this competitive world, OneDB has created a new vision for the customers, hence creating connections across the globe proving that all the knowledge is in the connections.

Thus, HCL OneDB has obtained credibility by making its audience content.

  • Author Biography

          Gaurav Sinha | Lead Engineer

Gaurav is a Lead Engineer and joined HCL about 2 years ago. He works as a UI developer for HCLSoftware and has years of expertise in front-end technologies.

 

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
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
HCLSoftware 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:
|