Name | Synopsis | Description | Options | Operands | Examples | Exit Status | Diagnostics | See Also
hadbm set [ -adminpasswordfile=filename] [-agent=ma_url] [-scrollprogress] {attribute_name_value_list} [dbname]
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 |
200–1200 |
1200 |
NationalCollation |
<collation> |
binary |
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 |
Valid values for NationalCollation (<collation>) are: binary/en_US/de_DE/fr_FR/zh_CN/ja_JA. Additionally, each of these values except "binary" may have a prefix "#ci", "#ai" or "#ci#ai" added to indicate case insensitivity, accent insensitivity or both.
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, an error message will be returned. Use the hadbm get command to view the list of default values.
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 file from which the administrator user password is read. Passwords can only be supplied interactively or through the password file.
Identifies the URL to the Management Agent. The default is localhost:1862.
If the -scrollprogress option is specified, the progress messages scroll down the screen, instead of being overwritten. The progress bar will not be displayed if the -––quiet option is specified. By default, progress messages are not specified.
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 | Diagnostics | See Also