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

## 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 | ture/false | false
CoreFile | true/false | false
DataBufferPoolSize | 16–2047 | 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 | 1–8 | 1
NumberOfLocks | 20000–1073741824 | 50000
NumberOfSessions | 1–10000 | 100
PackageName | n/a | V4.x.x.x
RelalgDeviceSize | 32–262144 | 128 MB
SQLTraceMode | none/short/full | none
SessionTimeout | 0–2147483647 | 1800 seconds
StartRepairDelay | 0–100000 | 20 seconds
StatInterval | 0–600 | 600 seconds
SyslogFacility | <facility> | local0
SyslogLevel | <level> | warning
SyslogPrefix | <string> | hadb-<db_name>
TakeoverTime | 500–16000 | 10000 MS

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.

The `set` command can be used to do an online upgrade of the database. A pre-condition 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 do an online upgrade, modify the `packagename` attribute and set it to the name of the new package.

#### OPTIONS

`–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

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 Last Revised 31 Jan 2005

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

- © 2010, Oracle Corporation and/or its affiliates