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.
Administrator's ReferenceThe HCL OneDB™ Administrator's Reference includes comprehensive descriptions of HCL OneDB™ configuration parameters, the system-monitoring interface (SMI) tables in the sysmaster database, the syntax of database server utilities such as onmode and onstat, logical-log records, disk structures, event alarms, and unnumbered error messages.
Administrative Utilities
The onstat utilityThe onstat utility reads shared-memory structures and provides statistics about the database server at the time that the command runs.
onstat -g monitoring optionsThe options that you can use with onstat -g command are used for support and debugging only. You can include only one of these options in the onstat -g command.
onstat -g qst command: Print wait options for mutex and condition queues Use the onstat -g qst command to display the wait statistics for mutex queues and condition queues (queues of waiters for a mutex or a condition).

onstat -g qst command: Print wait options for mutex and condition queues

Use the onstat -g qst command to display the wait statistics for mutex queues and condition queues (queues of waiters for a mutex or a condition).

The QSTATS configuration parameter must be set to 1 to enable the collection of statistics. For more information, see QSTATS configuration parameter.

Figure 1: Syntax:

Example output

Figure 2: onstat -g qst command output


Mutex Queue Statistics
name     nwaits   avg_time max_time avgq maxq nservs   avg_time

ddh chai 1        1354863  1354863  1    1    56       1690    

Condition Queue Statistics
name     nwaits   avg_time max_time avgq maxq nservs   avg_time

arrived  1        110008   110008   1    1    0        0
logbf0   21       642      4431     1    2    0        0       
logbf1   15       475      2519     1    2    0        0       
logbf2   19       596      3274     1    2    0        0       
bp_cond  1        0        0        1    1    0        0

Output description

name (string): Name of the mutex or condition resource being waited for
nwaits (decimal): Number of times this resource was waited for
avg_time (decimal): Average time spent waiting (in microseconds)
max_time (decimal): Maximum time spent waiting (in microseconds)
avgq (decimal): Average length of the queue
maxq (decimal): Maximum length of the queue
nservs (decimal): Number of times this resource was acquired
avg_time (decimal, microsecond): Average time the resource was held per acquisition (in microseconds)

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.