hadbm-get(1)

NAME | Synopsis | Description | Options | Operands | Examples | Exit Status | Diagnostics | See Also

NAME

hadbm-get – gets the value of the specified configuration attribute

Synopsis

hadbm get  -all | attribute_name_list [––adminpasswordfile=filename]
 [-agent=ma_url] [dbname]

Description

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

Options

-all

If specified, gets all the supported valiables and their values.

-W --adminpasswordfile

The file from which the administrator user password is read. Passwords can only be supplied interactively or through the password file.

-m -agent

Identifies the URL to the Management Agent. The default is localhost:1862.

Operands

attribute_name_list

A comma or space separated list of variables whose values have been retrieved.

dbname

The name of the database. The default database is hadb.

Examples

---

Example 1 Using get




hadbm get "takeoverTime numberOfLocks jdbcURL" mydatabase Attribute Value takeoverTime 10000 numberofLocks 10000 JdbcUrl com:sun:hadb:royal:15000,polo:15020

---

Exit Status

0

command executed successfully

1

error in executing the command

Diagnostics

22002

specified database does not exist

22071

attribute names are not recognized

See Also

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