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.
Configuring and monitoring HCL OneDB™
The sysmaster databaseThese topics describe the sysmaster database and provide reference information for the system-monitoring interface (SMI).
The System-Monitoring Interface TablesThe sysmaster database contains many tables that you can use to monitor your system.
sysha_type

sysha_type

The sysha_type table is a single row table that is used to describe the type of server that is connected.

Table 1. **sysha_type** table information
This table provides column, type, and description information for the **sysha_type** table.
Column	Type	Description
ha_type	integer	Server type (see table below)
ha_primary	char(128)	Server name (see table below)

Table 2. Descriptions for the values in the **sysha_type** tableThis table describes the values in the **sysha_type** table.
Value of ha_type	Value of ha_primary	Description
0	NULL	Not part of a high-availability environment
1	<primary server name>	Primary server
2	<primary server name>	HDR secondary server
3	<primary server name>	SD secondary server
4	<primary server name>	RS secondary server

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.