9.2 Initializing a database (creating data DB areas)

Use the adbinit command to execute database initialization and create data DB areas.

Example:: This example executes database initialization to create data DB areas (DBAREA01 and DBAREA02).

Procedure:

Log on to the OS from the HADB administrator's OS account.

Log on to the server machine's OS from the HADB administrator's OS account so that the HADB administrator can execute the adbinit command.

This step is not necessary if the HADB administrator is already logged on.
Create an initialization option file.
```
set adb_init_wrk_page_size = 32
set adb_init_wrk_blk_path = /dev/mapper/VolG00
adbinitdbarea -n DBAREA01 \
    -p 4 \
    -v /dev/mapper/VolG01,/dev/mapper/VolG02 \
    -q \
    -i 500M,2
adbinitdbarea -n DBAREA02 \
    -p 4 \
    -v /dev/mapper/VolG03,/dev/mapper/VolG04,/dev/mapper/VolG05 \
    -q \
    -i 1G,3
```
Create an initialization option file in which the initialization option is specified. The initialization option file created here becomes the input information for the adbinit command.

In this example, the created initialization option file is saved under /HADB/server/conf/adbinit.opt.

For details about the initialization option, see Format of initialization options in Specification format for the adbinit command under adbinit (Initialize the Database) in the manual HADB Command Reference.
Execute the adbinit command to initialize the database and create a data DB area.
```
adbinit -u ADBUSER01 -p '#HelloHADB_01'
        /HADB/server/conf/adbinit.opt
        /HADB/db
```
-u

Specifies an authorization identifier for the HADB user to be created.

-p

Specifies a password for the HADB user to be created.

/HADB/server/conf/adbinit.opt

Specifies the absolute path name of the initialization option file created in step 2.

/HADB/db

Specifies a DB directory name.

For details about the specification rules for authorization identifiers and passwords, see the following subsections:
- 9.4.2 Authorization identifier specification rules
- 9.4.3 Password specification rules

Note: The HADB user with the authorization identifier specified in the -u option is created as the first HADB user and is registered in the HADB server. This HADB user has both the DBA privilege and the CONNECT privilege.

To Page Top