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 osi: Print operating system informationUse the onstat -g osi command to display information on your operating system resources and parameters, including shared memory and semaphore parameters, the amount of memory currently configured on the computer, and the amount of memory that is unused.

onstat -g osi: Print operating system information

Use the onstat -g osi command to display information on your operating system resources and parameters, including shared memory and semaphore parameters, the amount of memory currently configured on the computer, and the amount of memory that is unused.

The onstat -g osi command also displays statistics on the hardware processors on your computer.

Use this command when the server is not online.

Example Output

Figure 1: onstat -g osi Command Output

Machine Configuration....
OS Name                              Linux
OS Release                           2.6.9-34.ELsmp
OS Node Name                         idas
OS Version                           #1 SMP
OS Machine                           x86_64
Number of processors                 4
Number of online processors          4
System memory page size              4096 bytes
System memory                        7970 MB
System free memory                   1536 MB
Number of open files per process     1024
shmmax            33554432
shmmin            1
shmids            4096
shmNumSegs        2097152
semmap            << UnSupported >>
semids            128
semnum            32000
semundo           << UnSupported >>
semNumPerID       250
semops            32
semUndoPerProc    << UnSupported >>
semUndoSize       20
semMaxValue       32767

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.