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	Type	Default
ConnectionTrace	boolean	false
CoreFile	boolean	false
DataBufferPoolSize	integer	200 MB
DataDeviceSize	integer	1024 MB
DevicePath	string	n/a
EagerSessionThreshold	integer	50 (% of NumberOfSessions)
Eager SessionTimeout	integer	120 seconds
EventBufferSize	integer	0 MB
HistoryPath	string	n/a
InternalLogbufferSize	integer	12 MB
LogbufferSize	integer	48 MB
MaxTables	integer	1100
NumberOfLocks	integer	50000
NumberOfSessions	integer	100
PackageName	string	n/a
RelalgDeviceSize	integer	128 MB
SessionTimeout	integer	1800 seconds
SQLTraceMode	string	off
StartRepairDelay	integer	20 seconds
StatInterval	integer	600 seconds
SyslogFacility	string	local0
Sysloglevel	string	NONE, ALERT, ERROR, WARNING, INFO
SysLogging	boolean	true
SyslogPrefix	string	hadb-<db_name>
TakeoverTime	integer	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.

OPTIONS

–w ––adminpassword

The actual HADBM administation password.

–W ––adminpasswordfile

The file containing the HADBM administration password. The adminstration password is defined in the following form: HADBM_ADMINPASSWORD=password. Where password is the actual administrator password.

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

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