HCL OneDB - ALL THE KNOWLEDGE IS IN THE CONNECTIONS

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.

• 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.

• 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).

• OneDB Visualization and Administration

• 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

• 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.

• 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

• 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.

• System Reports

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

• Task Scheduler

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

• Auto Update Statistics

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

• 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

• 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)

• 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

• 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

• Summary

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.