sun.com | docs.sun.com |  | How To Buy | My Sun | Worldwide Sites |

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

User Commands | 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 | 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`

> Where`device` 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)

J2EE SDK 1.4 | Go To Top | Last Changed 22 Dec 2004

Company Info | Contact | Copyright 2004 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms.