• 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)