Table 0-17  Configuration Attributes 
      | 
Attribute
 | 
Default
 | 
Range
 | 
Description
 | 
      | 
ConfigPath | 
/etc/opt/SUNWhadb/dbdef | 
 
 | 
(getonly) Location of configuration files used internally by the HADB. | 
      | 
ConnectionTrace | 
FALSE | 
 
 | 
If true, records a message in the HADB history files when a client connection (JDBC, ODBC) is initiated or terminated.
 | 
      | 
CoreFile | 
FALSE | 
 
 | 
The default value should not be changed.
 | 
      | 
DatabaseName | 
hadb | 
 
 | 
(getonly) Name of the database. | 
      | 
DataBufferPoolSize | 
200 | 
16MB - 2GB
 | 
Size of the data buffer pool allocated in shared memory.
 | 
      | 
DataDeviceSize | 
none
 | 
Maximum is the smaller of 256 GB or the maximum operating system file size, minimum is:
 
(4 x LogbufferSize+ 16MB) /NumberOfDatadevices 
HADB uses this amount of space internally. Therefore, this space is not available for storing user data.
 | 
The size of each data device used by an HADB node. 
 
DataDeviceSizeis equal to: 
TotalDatadeviceSizePerNode/NumberOfDatadevices 
Therefore, TotalDatadeviceSizePerNodeandDataDeviceSizeare mutually dependent: changing one changes the other. 
The recommended size is four times the expected size of the user data, based on the number of users and the size of each user record.
 | 
      | 
DevicePath | 
/var/tmp | 
 
 | 
(getonly) Location of the devices. There are three devices: theDataDevice, theNiLogDevice(node internal log device), and theRelalgDevice(relational algebra query device). | 
      | 
EagerSessionThreshold | 
50(% ofNumberOfSessions) | 
0-100 | 
Determines whether normal or eager idle session expiration is used. 
 
In normal idle session expiration, sessions that are idle for more than SessionTimeoutseconds are expired. 
When the number of concurrent sessions exceeds the EagerSessionThresholdpercentage of the maximum number of sessions, sessions that are idle for more thanEagerSessionTimeoutseconds are expired. | 
      | 
EagerSessionTimeout | 
120 | 
0-2000000 | 
Amount of time a database connection can be idle before it expires when eager session expiration is used.
 | 
      | 
EventBufferSize | 
0 | 
0MB - 2GB
 | 
Size of the event buffer, where database events are logged. If set to 0, no event buffer logging is performed. 
During failures, the event buffer is dumped. This gives valuable information on the cause of the failures and is useful during trial deployment.
 
Writing events to memory has a performance penalty.
 | 
      | 
HistoryPath | 
/var/tmp | 
 
 | 
(getonly) Location of the HADB history files, which contain information, warnings, and error messages. | 
      | 
InstallPath | 
parent of the directory where hadbmresides: install_dir/SUNWhadb/4/ | 
 
 | 
(getonly) Location of the HADB executable files. | 
      | 
InternalLogbufferSize | 
12 | 
4MB - 128MB
 | 
Size of the node internal log device, which keeps track of operations related to storing data.
 | 
      | 
JdbcUrl | 
none
 | 
 
 | 
(getonly) The JDBC connection URL for the database. | 
      | 
LogbufferSize | 
48 | 
4MB - 2GB
 | 
Size of the log buffer, which keeps track of operations related to data.
 | 
      | 
ManagementProtocol | 
ssh | 
rsh,ssh | 
(getonly) Protocol used between thehadbmcommand and the database nodes. | 
      | 
MaxTables | 
1100 | 
100-1100 | 
Maximum number of tables allowed in an HADB database.
 | 
      | 
NumberOfDatadevices | 
1 | 
1-8 | 
(getonly) Number of data devices used by an HADB node. | 
      | 
NumberOfLocks | 
50000 | 
20000-2147483647 | 
Number of locks allocated by an HADB node.
 | 
      | 
NumberOfSessions | 
100 | 
1-10000 | 
Maximum number of sessions (database connections) that can be opened for an HADB node.
 | 
      | 
Portbase | 
15200 | 
10000-63000 | 
(getonly) Base port number used to create different port numbers for different HADB processes. | 
      | 
RelalgdeviceSize | 
128 | 
32MB - 2GB
 | 
Size of the device used in relational algebra queries.
 | 
      | 
SessionTimeout | 
1800 | 
0-2000000 | 
Amount of time a database connection can be idle before it expires when normal session expiration is used.
 | 
      | 
SQLTraceMode | 
NONE | 
NONE,SHORT,FULL | 
Amount of information about executed SQL queries written to the history files. 
 
If SHORT, login and logout of SQL sessions are recorded. IfFULL, all SQL queries being prepared and executed, including parameter values, are recorded. | 
      | 
StartRepairDelay | 
20 | 
0-100000 | 
Maximum time a spare node allows for a failed active node to perform a node recovery. If the failed node cannot recover within this time interval, the spare node starts copying data from the failed node’s mirror and becomes active. Changing the default value is not recommended.
 | 
      | 
StatInterval | 
600 | 
0-1000 | 
Interval at which an HADB node writes throughput and response time statistics to its history file. To disable, set to 0. 
An example statistics line is as follows:
 
"Req-reply time: # 123, 
min= 69 avg= 1160 max= 
9311 %=100.0"
The #is the number of requests serviced over theStatInterval. The next three numbers are the minimum, average, and maximum time in microseconds taken by transactions completed over theStatInterval. The%is the number of transactions completed successfully within 15 milliseconds over theStatInterval. | 
      | 
SyslogFacility | 
local0 | 
local0,local1,local2,local3,local4,local5,local6,local7,kern,user,mail,daemon,auth,syslog,lpr,news,uucp,cron,none | 
Facility used when reporting to syslog(seeman syslogfor details). Thesyslogdaemon should be configured (seeman syslogd.conffor details). 
Use a facility that is not in use by other applications running on the same machine.
 
Set to noneto disablesysloglogging. | 
      | 
SysLogging | 
TRUE | 
 
 | 
Set to true if an HADB node should write any information to the operating system’s syslogfiles. | 
      | 
SysLogLevel | 
warning | 
none,alert,error,warning,info | 
Lets you to fine tune which HADB messages are reported to the operating system’s syslogfiles. 
Higher levels include lower levels. For example, the errorlevel includesalertmessages, and theinfolevel includes all messages. | 
      | 
SyslogPrefix | 
HADB | 
 
 | 
Text string that is prepended to all syslogmessages written by the HADB. | 
      | 
TakeoverTime | 
10000(milliseconds) | 
500-16000 | 
Time between when a node fails and when its mirror takes over. Changing the default value is not recommended.
 | 
      | 
TotalDatadeviceSizePerNode | 
none
 | 
Maximum is the smaller of 256 GB or the maximum operating system file size, minimum is:
 
4 x LogbufferSize+ 16MB 
HADB uses this amount of space internally. Therefore, this space is not available for storing user data.
 | 
Sum of the sizes of all data devices used by an HADB node. 
 
TotalDatadeviceSizePerNodeis equal to: 
DataDeviceSizexNumberOfDatadevices 
Therefore, TotalDatadeviceSizePerNodeandDataDeviceSizeare mutually dependent: changing one changes the other. |