The dbname operand specifies the database name, which must be unique. To make sure the database name is unique, use the hadbm list command to list existing database names. Use the default database name unless you need to create multiple databases. For example, to create multiple clusters with independent databases on the same set of HADB machines, use a separate database name for each cluster.
The hadbm create command writes error messages to the console, not log files.
Table 3–7 describes the special hadbm create command options. See General Options for a description of additional command options.
Table 3–7 hadbm create Options
Option(Short Form) |
Description |
Default |
---|---|---|
-a |
Number of data devices on each node, between one and eight inclusive. Data devices are numbered starting at 0. |
1 |
-d |
Path to the devices. There are four devices:
|
Solaris and Linux: /var/opt/SUNWhadb Windows: C:\Sun\AppServer\SUNWhadb\vers, where vers is the HADB version number. Default is specified by ma.server.dbdevicepath in management agent configuration file. For more details, see Configuration File |
-z |
Device size for each node. For more information, see Specifying Device Size. Increase the device size as described in Adding Storage Space to Existing Nodes |
1024MB Maximum size is lesser of maximum operating system file size or 256 GB. Minimum size is: (4 x LogbufferSize + 16MB) / n Where n is the number of data devices given by the option --datadevices. |
-t |
Path to the history files. This path must already exist and be writable. For more information on history files, see Clearing and Archiving History Files |
Default is specified by ma.server.dbhistorypath in management agent configuration file. For details, see Configuration File Solaris and Linux:/var/opt/SUNWhadb On Windows: REPLACEDIR (replaced by the actual URL at runtime.) |
-H |
Comma-separated list of host names or IP addresses (IPv4 only) for the nodes in the database. Use IP addresses to avoid dependence on DNS lookups. Host names must be absolute. You cannot use localhost or 127.0.0.1 as a host name. Host names See Specifying Hosts for more information. |
None |
--package=name -k |
Name of the HADB package (version). If the package is not found, a default package is registered. This option is deprecated. Use the hadbm registerpackage command to register a package in the domain. |
None |
--packagepath=path-L |
Path to the HADB software package. Use only if the package is not registered in the domain. This option is deprecated. Use the hadbm registerpackage command to register a package in the domain. |
None |
-b |
Port base number used for node 0. Successive nodes are automatically assigned port base numbers in steps of 20 from this number. Each node uses its port base number and the next five consecutively numbered ports. To run several databases on the same machine, have a plan for allocating port numbers explicitly. |
15200 |
-s |
Number of spare nodes. This number must be even and must be less than the number of nodes specified in the --hosts option. |
0 |
-S |
Comma-separated list of database configuration attributes in name =value format. For explanations of database configuration attributes, see Clearing and Archiving History Files |
None |
The following command is an example of creating a database:
hadbm create --spares 2 --devicesize 1024 --hosts n0,n1,n2,n3,n4,n5