Hitachi

Hitachi Advanced Database Setup and Operation Guide


3.1.1 System configuration of the HADB server to be built

The machine environment for building a hands-on environment for an HADB server must have the following capacities:

The following figure shows the system configuration of the HADB server that will be built in the hands-on environment.

Figure 3‒2: System configuration of the HADB server to be built

[Figure]

Organization of this subsection

(1) Directory that stores the installation data

This is the directory to which you copy the HADB server installation data stored on the file system CD-ROM. The directory that stores the installation data stores the following two types of data:

Note:

$VR indicates the HADB version and release number.

(2) Server directory

The server directory is a directory that stores the definition files and various types of commands that are necessary for operating the HADB server.

During the installation of the HADB server, use the installation command (adbinstall command) to specify the directory to be used as the server directory (/home/adbmanager/server). The installation data (hitachi_advanced_data_binder_server-$VR.tar.gz file) is expanded under the server directory, which stores directories and files.

The following table lists and describes the files that are used to build a hands-on environment.

Table 3‒1: Files in the server directory that are used in a hands-on environment

No.

File name

Description

1

Server definition file

Definitions necessary for operating the HADB server are specified in this file.

2

Client definition file

Definitions necessary for executing applications and commands are specified in this file.

3

Initialization option file

Options necessary for creating DB areas are specified in this file.

4

Sample data file

The data to be stored in the tables in the hands-on environment is entered into this text file.

5

Import option file

Options necessary for storing data in tables are specified in this file.

(3) DB directory

The DB directory is where the DB areas are stored when they are created during database initialization. Before initializing the database, the user must create the DB directory (/home/adbmanager/db).

When the database is initialized, the five DB areas shown in the table below are created. The only DB area that the user explicitly creates is the data DB area. Other DB areas are created automatically.

Table 3‒2: List of DB areas that are created

No.

DB area name

Description

1

Data DB area

This DB area stores tables and indexes.

2

Work table DB area

This DB area stores the work tables created by HADB when executing SQL statements.

3

Master directory DB area

This DB area stores the system's internal information.

4

Dictionary DB area

This DB area stores dictionary tables and B-tree indexes of dictionary tables.

5

System-table DB area

This DB area stores system tables and B-tree indexes of system tables.

(4) Directories for storing communication-information files

Files of communication information that is necessary for operating the HADB server are stored in the directories for storing communication-information files.

Before the HADB server can be installed, a user must manually create directories that will store communication-information files. The directories that will store communication-information files differ depending on the OS version of the server machine.

If the server machine's OS is Red Hat Enterprise Linux Server 6 (64-bit x86_64)
  • /dev/HADB/pth

  • /lib/udev/devices/HADB/pth

If the server machine's OS is Red Hat Enterprise Linux Server 7 (64-bit x86_64)
  • /dev/HADB/pth

Note that if the OS is Red Hat Enterprise Linux Server 7, a user must also create the following configuration file:

  • /etc/tmpfiles.d/dev-HADB-pth.conf