• NAME
• SYNOPSIS
• DESCRIPTION
• OPTIONS
• OPERANDS
• EXAMPLES
• EXIT STATUS
• ERROR CODES
• SEE ALSO

NAME

 hadbm status - shows the state of the database

SYNOPSIS

 hadbm status [nodes] [adminpassword=password | adminpasswordfile=filename] [agent=ma_url] [dbname]

DESCRIPTION

Use the hadbm status command to get the current state of the database. The state can be one of the following:

HA Fault Tolerant (HAFT)

The database has at least one spare node on each DRU.

Fault Tolerant (FT)

All mirrored node pairs are up and running.

Operational (O)

One node in each mirrored node pair is up and running.

Non-operational (NO)

One or more mirrored node pair is missing both nodes. An arbitrary SQL transaction may not succeed.

Stopped (S)

No nodes are running.

Unknown (U)

Unable to determine the state of the database.

If a database is named, it must already exist. If a database is not named, the default database is used. The default database is hadb.

OPTIONS

-n nodes

If specified, displays the node status information. The following information is displayed for each node in the database:

• Node number

• Name of the machine where the node is running

• Port number of the node

• Role of the node

• State of the node

• Number of the corresponding mirror node

w adminpassword

The actual HADBM administation password.

W adminpasswordfile

The file from which the HADBM administration password is read.

m agent

Identifies the URL to the Management Agent. The default is localhost:1862.

OPERANDS

dbname

The name of the database. The default database is hadb.

EXAMPLES

Example 1. Using status

hadbm status
Database Status
hadb HAFaultTolerant

EXIT STATUS

0

command executed successfully

1

error in executing the command

ERROR CODES

22002

specified database does not exist

SEE ALSO

hadbm-clear(1), hadbm-clearhistory(1), hadbm-delete(1), hadbm-list(1), hadbm-restart(1), hadbm-resourceinfo(1), hadbm-start(1), hadbm-stop(1),