Sun Java System Application Server 9.1 High Availability Administration Guide

Getting the Status of HADB

Use the hadbm status command to display the status of the database or its nodes. The command syntax is:

hadbm status  
[--adminpassword=password | --adminpasswordfile=file]  

The dbname operand specifies the database name. The default is hadb.

The --nodes option (short form -n) displays information on each node in the database. For more information , see Node Status. See General Options for a description of other command options.

For more information, see hadbm-status(1).

Example 3–15 Example of getting HADB status

For example:

hadbm status --nodes

Database States

A database’s state summarizes its current condition. The following table describes the possible database states.

Table 3–14 HADB States

Database State 


High-Availability Fault Tolerant (HAFaultTolerant) 

Database is fault tolerant and has at least one spare node on each DRU. 

Fault Tolerant 

All the mirrored node pairs are up and running. 


At least one node in each mirrored node pair is running. 

Non Operational 

One or more mirrored node pairs is missing both nodes. 

If the database is non-operational, clear the database as described in Clearing a database.


No nodes are running in the database. 


Cannot determine the state of the database. 

Node Status

Use the--nodes option to make the hadbm status command display the following information 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: