IBM® Informix® Warehouse Accelerator, Version 12.10

ondwa status command

The ondwa status command shows information about the status of the accelerator server nodes, the cluster status, and the expected node count.

To run this command, log on to the computer where the accelerator server is installed either as user root or as user informix. For you to run the command as user informix, specific memory resources must be available. For more information, see Users who can run the ondwa commands.

Usage:
$ ondwa status
ID | Role        | Cat-Status | HB-Status | Hostname | System ID
---+-------------+------------+-----------+----------+------------
0  | COORDINATOR | ACTIVE     | Healthy   | leo      | 1
1  | WORKER      | ACTIVE     | Healthy   | leo      | 2
Cluster is in state : Fully Operational
Expected node count : 1 coordinator and 1 worker nodes
The following example output shows the status shows one accelerator server node is shut down:
$ ondwa status
ID | Role        | Cat-Status  | HB-Status | Hostname | System ID
---+-------------+-------------+-----------+----------+------------
0  | COORDINATOR | ACTIVE      | Healthy   | leo      | 1
1  | WORKER      | DEACTIVATED | Shutdown  | leo      | 2
Cluster is in state : Recovering
Expected node count : 1 coordinator and 1 worker nodes

The following example output shows the status of a cluster system:

ID   | Role        | Cat-Status  | HB-Status    | Hostname         | System ID
-----+-------------+-------------+--------------+------------------+------------
0    | COORDINATOR | ACTIVE      |   Healthy    | node0001         | 1
1    | WORKER      | ACTIVE      |   Healthy    | node0002         | 2
2    | WORKER      | ACTIVE      |   Healthy    | node0003         | 3
3    | WORKER      | ACTIVE      |   Healthy    | node0004         | 4

Cluster is in state    : Fully Operational
Expected node count    : 1 coordinator and 3 worker nodes

Columns in ondwa status command output

The Cat-Status column shows the status of all nodes in the accelerator server catalog. The Cat-Status column can have one of the following values:
ACTIVE
The accelerator server node is active. For a cluster system, ACTIVE indicates that the cluster node participates in the cluster.
DEACTIVATED
The accelerator server node is shut down or the accelerator server is not running.
FAILOVER
A failed accelerator server node that was set in ERROR state.

The HB-Status (heartbeat status) column can have one of the following values:

Initializing
The accelerator server node is initializing and loading data into memory.
Healthy
The initialization is complete and the accelerator server node is ready for queries.
QuiescePend
The accelerator server node is waiting to go into a quiesced state.
Quiesced
The accelerator server node is in a quiesced state.
Resuming
The accelerator server node is resuming after a quiesced or a maintenance state.
Maintenance
The accelerator server node is in maintenance state.
MaintPend
The accelerator server node is waiting to go into a maintenance state.
Missing
The accelerator server node has a missing heartbeat.
Shutdown
The accelerator server node is shutting down.


Examples exchange | Troubleshooting

To find the PDF, see Publications for IBM Informix Warehouse Accelerator 12.10.
For the release notes, see the Release Notes topic.
timestamp Release date: March 2015