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