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-set(1)

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

## NAME

> hadbm set - sets the value of the specified configuration attributes to the identified values

## SYNOPSIS

> `hadbm set` [adminpassword=password | adminpasswordfile=filename] [agent=ma_url] attribute_name_value_list [dbname]

## DESCRIPTION

> The `hadbm set` command is used to reconfigure the database. Multiple configuration attributes can be modified in one single set operation. You can use a comma or space separated list of name=value pairs. If using a space separated list, use quotation marks to preserve the spaces. The writeable configuration attributes are as follows:

> Variable | Range | Default
> --- | --- | ---
> ConnectionTrace | true/false | false
> CoreFile | true/false | false
> DataBufferPoolSize | 162047 | 200 MB
> DataDeviceSize | 32-262144 | 1024 MB
> DevicePath | n/a | n/a
> EagerSessionThreshold | 0-100 | 50 (% of NumberOfSessions)
> Eager SessionTimeout | 0-2147483647 | 120 seconds
> EventBufferSize | 0-2097152 | 0 MB
> HistoryPath | n/a | n/a
> InternalLogbufferSize | 4-128 | 12 MB
> LogbufferSize | 4-2047 | 48 MB
> MaxTables | 100-1100 | 1100
> NumberOfDatadevices | 18 | 1
> NumberOfLocks | 20000-1073741824 | 50000
> NumberOfSessions | 100-1100 | 100
> PackageName | n/a | n/a
> RelalgDeviceSize | 32-262144 | 128 MB
> SessionTimeout | 0-2147483647 | 1800 seconds
> SQLTraceMode | none/short/full | none
> StartRepairDelay | 0-100000 | 20 seconds
> StatInterval | 0-600 | 600 seconds
> SyslogFacility | facility | local0
> Sysloglevel | level | warning
> SysLogging | 32-262144 | true
> SyslogPrefix | string | hadb-db_name
> TakeoverTime | 500-16000 | 10000 milliseconds

> The set command can be used to do an online upgrade of the database. A precondition for online upgrade is that the new version of the HADB software has been installed on all the hosts, and is registered in the domain.

> To perform an online upgrade, modify the `packagename` attribute, and set it to the name of the new package.

> The values of the configuration attributes will be set into the database configuration. Use the `hadbm get` command to get the new value of an attribute. When the value part of an attribute is missing, the attribute is set to the default value.

> Setting the database attribute may require the system to do a rolling restart of the hadb nodes. The database must be in Fault Tolerant or HA Fault Tolerant state before using the `hadbm set` command.

> The`JdbcUrl` cannot be set with either the `hadbm set` or `hadbm create` commands. However, the `hadbm create` or `hadbm addnodes` commands derive the `JdbcUrl` value from values given for hosts and portbase options. So, there is no need to set this variable.

## OPTIONS

> 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

> attribute_name_value_list

>   A list of variables with values to be set. All the attribute names must be supported attributes.

> dbname

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

## EXAMPLES

> Example 1. Using set

> > >     hadbm set "connectiontrace=true numberOfLocks=110000"
> > >     Database attributes successfully set.

## EXIT STATUS

> 0

>   command executed successfully

> 1

>   error in executing the command

## ERROR CODES

> 22002

>   specified database does not exist

> 22033

>   invalid value set for attributes

> 22071

>   attributes are not recognized

> 22072

>   attribute is not writeable

## SEE ALSO

> `hadbm-addnodes`(1), `hadbm-get`(1), `hadbm-clear`(1), `hadbm-delete`(1), `hadbm-list`(1), `hadbm-start`(1), `hadbm-restart`(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.