NAME | SYNOPSIS | DESCRIPTION | OPTIONS | OPERANDS | EXAMPLES | EXIT STATUS | ERROR CODES | SEE ALSO
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.
The actual HADBM administration password.
The file from which the passwords are read.
Identifies the URL to the Management Agent. The default is localhost:1862.
A list of variables with values to be set. All the attribute names must be supported attributes.
The name of the database. The default database is hadb.
hadbm set "connectiontrace=true numberOfLocks=110000" Database attributes successfully set. |
specified database does not exist
invalid value set for attributes
attributes are not recognized
attribute is not writeable
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