Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
The onperf utility on UNIXThe onperf utility is a windowing environment that you can use to monitor the database server performance. The onperf utility monitors the database server running on the UNIX™ operating system.
Overview of the onperf utilityThe onperf utility is a graphical tool that you can use for displaying most of the same database server metrics that you can view on onstat utility reports.
onperf utility toolsThe onperf utility provides Motif windows, called tools, which display metric values.

onperf utility tools

The onperf utility provides Motif windows, called tools, which display metric values.

Table 1. **onperf** utility tools
Tool	Description
Graph tool	This tool allows you to monitor general performance activity. You can use this tool to display any combination of metrics that onperf supports and to display the contents of a history file. For more information, see Graph tool.
Query-tree tool	This tool displays the progress of individual queries. For more information, see Query-tree tool.
Status tool	This tool displays status information about the database server and allows you to save the data that is currently held in the data-collector buffer to a file. For more information, see Status tool.
Activity tools	These tools display specific database server activities. Activity tools include disk, session, disk-capacity, physical-processor, and virtual-processor tools. The physical-processor and virtual-processor tools, respectively, display information about all CPUs and VPs. The other activity tools each display the top 10 instances of a resource ranked by a suitable activity measurement. For more information, see Activity tools.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.