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

## hadbm-refragment(1)

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

#### NAME

hadbm refragment– refragments the database schema

#### SYNOPSIS

`hadbm refragment` [`––dbpassword=password` | `––passwordfile=passwordfilename`] [`––adminpassword=password` | `––adminpasswordfile=filename`] [`––agent=ma_url`] [dbname]

#### DESCRIPTION

Refragmentation is needed to store the data on a newly created node. Run the `hadbm refragment` command after adding a node using the `hadbm addnodes` command with the `––no-refragment` option specified. If the `hadbm refragment` command fails, it can be retried. If it continues to fail, the database must be cleared, and the product-specific schemas must be reloaded. All the user tables are refragmented.

If a database is specified, the database must already exist and must be in an HA Fault Tolerant or Fault Tolerant state. If the database is not named, the default database is refragmented. The default database is `hadb`.

In interactive mode, the `hadbm refragment` command prompts for a confirmation before refragmenting the data.

#### OPTIONS

`-p` `––dbpassword`

  The password string for the system user of the database. The minimum length of the password must be 8 characters. You can identify either the database password, or for higher security, the password file where the password is defined.

`-P` `––dbpasswordfile`

  Identifies the file containing the password to be used for the system user of 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.

#### OPERANDS

dbname

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

#### EXAMPLES

##### Example 1 Using refragment

    hadbm refragment --dbpasswordfile=/home/hadb/dbpfile mydatabase
    This command will refragment the data on all active nodes.
    Type "yes" or "y" to confirm this operation, anything else to cancel:y
    Database successfully refragmented

#### EXIT STATUS

0

  command executed successfully

1

  error in executing the command

#### ERROR CODES

22002

  specified database does not exist

22041

  invalid database state

22042

  database could not be refragmented

22051

  node not responding

#### SEE ALSO

hadbm-clear(1), hadbm-create(1), hadbm-delete(1), hadbm-list(1), hadbm-restart(1), hadbm-start(1), hadbm-status(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