• NAME
• SYNOPSIS
• DESCRIPTION
• OPTIONS
• OPERANDS
• EXAMPLES
• EXIT STATUS
• ERROR CODES
• SEE ALSO

NAME

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

SYNOPSIS

 hadbm get all | attribute_name_list [adminpassword=password | 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	true/false	false
CoreFile	true/false	false
DataBufferPoolSize	16-2047	200 MB
DatabaseName	n/a	hadb
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
InternalLoBbufferSize	4-128	12 MB
JdbcUrl	n/a	n/a
LogBufferSize	4-2047	48 MB
MaxTables	100-1100	1100
NumberOfDataDevices	1-8	1
NumberOfLocks	20000-1073741824	50000
NumberOfSessions	1-10000	100
PackageName	n/a	n/a
PortBase	10000-63000	15000
RelalgDeviceSize	32-262144	128 MB
SessionTimeout	0-2147483647	1800 seconds
SQLTraceMode	none/short/full	none
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 milliseconds

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

Wheredevice is one of:

DataDevice-datadevicenumber

RelalgDevice

NiLogDevice

NoManDevice

OPTIONS

w adminpassword

The actual HADBM administation password.

W adminpasswordfile

The file from which the HADBM administration password is read.

m agent

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

all

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

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

ERROR CODES

22002

specified database does not exist

22071

attribute names are not recognized

SEE ALSO

hadbm-addnodes(1), hadb-clear(1), hadbm-delete(1), hadb-list(1), hadbm-refragment(1), hadbm-restart(1), hadbm-set(1), hadbm-start(1), hadbm-stop(1)