NAME

Synopsis

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.