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.
The onperf user interfaceWhen you invoke the onperf utility, it displays an initial graph-tool window. From this graph-tool window, you can display additional graph-tool windows as well as the query-tree, data-collector, and activity tools.
Activity toolsActivity tools are specialized forms of the graph tool that display instances of the specific activity, based on a ranking of the activity by some suitable metric.

Activity tools

Activity tools are specialized forms of the graph tool that display instances of the specific activity, based on a ranking of the activity by some suitable metric.

You can choose from among the following activity tools:

The disk-activity tool, which displays the top 10 activities ranked by total operations
The session-activity tool, which displays the top 10 activities ranked by ISAM calls plus PDQ calls per second
The disk-capacity tool, which displays the top 10 activities ranked by free space in megabytes
The physical-processor-activity tool, which displays all processors ranked by nonidle CPU time
The virtual-processor-activity tool, which displays all VPs ranked by VP user time plus VP system time

The activity tools use the bar-graph format. You cannot change the scale of an activity tool manually; onperf always sets this value automatically.

The Graph menu provides you with options for closing, printing, and exiting the activity tool.