Name | Synopsis | Description | Options | Operands | Examples | Exit Status | Diagnostics | See Also
hadbm get -all | attribute_name_list [––adminpasswordfile=filename] [-agent=ma_url] [dbname]
Use the get command to get the value of the named configuration attribute. If the command is run without any attributes, and with the -all option, all the supported variables and their values are retrieved. If an attribute is unrecognized, an exception is thrown on the unrecognized attribute name, and the variables and values of the recognized attributess are returned.
The readable configuration attributes are as follows:
Variable |
Range |
Default |
---|---|---|
ConnectionTrace |
ture/false |
false |
CoreFile |
true/false |
false |
DatabaseName |
hadb |
|
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 |
JdbcUrl |
n/a |
n/a |
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 |
PortBase |
10000–63000 |
15000 |
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 |
Heterogenous attributes:
Node-nodeno.HistoryPath=path_to_history_files
Node-nodeno.DevicePath=default_path_for_devices_on_node
Node-nodeno.device.DevicePath=path_for_device_on_node
Where device is one of:
DataDevice-datadevicenumber
RelalgDevice
NiLogDevice
NoManDevice
If specified, gets all the supported valiables and their values.
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.
A comma or space separated list of variables whose values have been retrieved.
The name of the database. The default database is hadb.
hadbm get "takeoverTime numberOfLocks jdbcURL" mydatabase Attribute Value takeoverTime 10000 numberofLocks 10000 JdbcUrl com:sun:hadb:royal:15000,polo:15020 |
hadbm-addnodes(1), hadbm-clear(1), hadbm-delete(1), hadbm-list(1)hadbm-refragment(1), hadbm-restart(1), hadbm-set(1), hadbm-start(1), hadbm-stop(1)
Name | Synopsis | Description | Options | Operands | Examples | Exit Status | Diagnostics | See Also