![](../graphics/a.gif) |
|
|
NAME
hadbm status - shows the state of the database
SYNOPSIS
hadbm status [nodes] [adminpassword=password | adminpasswordfile=filename] [agent=ma_url] [dbname]
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.
- -n nodes
-
If specified, displays the node status information. The following information is displayed for each node in the database:
- 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.
-
dbname
-
The name of the database. The default database is hadb.
Example 1. Using status
hadbm status
Database Status
hadb HAFaultTolerant
- 0
-
command executed successfully
- 1
-
error in executing the command
- 22002
-
specified database does not exist
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 31 Jan 2005 |
Company Info
|
Contact
|
Copyright 2004 Sun Microsystems, Inc. All rights reserved.
Use is subject to license terms.
|