Getting the Status of the HADB

To display the status of the database or its nodes, use the hadbm status command. The syntax is as follows:

hadbm status [--nodes] [dbname]

For example:

hadbm status --nodes

The physical node number is associated with a specific database node and port number combination, and does not vary during the life of the database. The logical node number, on the other hand, can vary during the lifetime of the database. Initially, logical node numbers are identical to physical node numbers for active nodes used to store data. Logical node numbering can change if individual nodes are stopped (for example, for maintenance), and spare nodes take over.

The hadbm status --nodes command gives information about both physical and logical node numbers. All other hadbm subcommands deal with physical node numbers only. You only need to know about logical node numbers if you need to know which nodes are currently mirror nodes. This information is useful when you are performing maintenance on machines. See "Maintaining the HADB Machines".

The hadbm status command options are listed in the following table.

Table 0-16  hadbm status Options 

Long Form

Short Form

Default

Description

--nodes

-n

not present

If present, displays node status information. See "Node Status".

dbname

none

hadb

Specifies the database name.

Database Status

The possible states of a database are as follows:

If the database is Non Operational, clear the database using hadbm clear as described in "Clearing the HADB".

Node Status

If you specify the --nodes option, the following information is displayed for each node in the database:

A node’s role and state can change as described in these sections:

Roles of a Node

A node is assigned a role during its creation and can take any one of these roles:

States of a Node

A node can be in any one of the following states:


Legal Notices