sun.com | docs.sun.com |  | How To Buy | My Sun | Worldwide Sites |

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

User Commands | 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 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),

J2EE SDK 1.4 | Go To Top | Last Changed 22 Dec 2004

Company Info | Contact | Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms.