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 | 162047 | 200 MB |
DataDeviceSize | 32262144 | 1024 MB |
DevicePath | n/a | n/a |
EagerSessionThreshold | 0100 | 50 (% of NumberOfSessions) |
Eager SessionTimeout | 02147483647 | 120 seconds |
EventBufferSize | 02097152 | 0 MB |
HistoryPath | n/a | n/a |
InternalLogBufferSize | 4128 | 12 MB |
LogBufferSize | 42047 | 48 MB |
MaxTables | 1001100 | 1100 |
NumberOfDataDevices | 18 | 1 |
NumberOfLocks | 200001073741824 | 50000 |
NumberOfSessions | 110000 | 100 |
PackageName | n/a | V4.x.x.x |
RelalgDeviceSize | 32262144 | 128 MB |
SQLTraceMode | none/short/full | none |
SessionTimeout | 02147483647 | 1800 seconds |
StartRepairDelay | 0100000 | 20 seconds |
StatInterval | 0600 | 600 seconds |
SyslogFacility | <facility> | local0 |
SyslogLevel | <level> | warning |
SyslogPrefix | <string> | hadb-<db_name> |
TakeoverTime | 50016000 | 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.