Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Reference Manual

## hadbm-get(1)

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 | 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 | 100–1100 | 1100
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` `––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)

J2EE SDK 1.4 Last Revised 31 Jan 2005

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

- © 2010, Oracle Corporation and/or its affiliates