Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Reference Manual

## hadbm-status(1)

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 administration password.

`–W` `––adminpasswordfile`

  The file from which the passwords are 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),

J2EE SDK 1.4 Last Revised 31 Jan 2005

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

- © 2010, Oracle Corporation and/or its affiliates