• 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	ture/false	false
CoreFile	true/false	false
DatabaseName		hadb
DataBufferPoolSize	162047	200 MB
DataDeviceSize	32262144	1024 MB
DevicePath	n/a	n/a
EagerSessionThreshold	0100	50 (% of NumberOfSessions)
Eager SessionTimeout	02147483647	120 seconds
EventBufferSize	02097152	0 MB
HistoryPath	n/a	n/a
InternalLogBufferSize	4128	12 MB
JdbcUrl	n/a	n/a
LogBufferSize	42047	48 MB
MaxTables	1001100	1100
NumberOfDataDevices	18	1
NumberOfLocks	200001073741824	50000
NumberOfSessions	110000	100
PackageName	n/a	V4.x.x.x
PortBase	1000063000	15000
RelalgDeviceSize	32262144	128 MB
SQLTraceMode	none/short/full	none
SessionTimeout	02147483647	1800 seconds
StartRepairDelay	0100000	20 seconds
StatInterval	0600	600 seconds
SyslogFacility	<facility>	local0
SyslogLevel	<level>	warning
SyslogPrefix	<string>	hadb-<db_name>
TakeoverTime	50016000	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 adminpassword

The actual HADBM administration password.

W adminpasswordfile

The file from which the passwords are read.

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

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)