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