5.2.2 Creating HiRDB system definitions (HiRDB/Parallel Server)

Organization of this subsection
(1) Creating system common definitions (HiRDB/Parallel Server)
(2) Creating unit control information definitions (HiRDB/Single Server)
(3) Creating single server definitions
(4) Creating front-end server definitions
(5) Creating dictionary server definitions
(6) Creating back-end server definitions
(7) UAP environment definition creation (optional)
(8) Creating an SQL reserved word definition (optional)
(9) Foreign server information definition creation
(10) Hub optimization information definition creation
(11) Configuring the HiRDB system definition files

(1) Creating system common definitions (HiRDB/Parallel Server)

For system common definitions, define the HiRDB configuration and common information. After you create the system common definitions, store them in the following file:

Create the same system common definitions for each server machine.

The system common definitions include the definitions of unit configuration, server configuration, and global buffer.

(2) Creating unit control information definitions (HiRDB/Single Server)

For unit control information definitions, define the unit's execution environment. Store the unit control information definitions created in the following file:

Create the unit control information definitions for each server machine.

The unit control information definitions include the definitions of status files for units.

(3) Creating single server definitions

For single server definitions, define the default values of the server-definition operands, which are explained in (4)-(6), below. Create the server common definitions for each server as required and store them in the following file:

The server common definitions are useful in the following cases:

The information specified in the server common definitions takes effect on all the servers defined in the corresponding server machine. If there are many definitions that are common to multiple servers, you should specify the common information in the server common definitions and the information unique to individual servers in the corresponding server definitions.

If you are sharing HiRDB system definition files, you should create the server common definitions.

(4) Creating front-end server definitions

For front-end server definitions, define the front-end server's execution environment. Save the front-end server definitions created in the following file:

Create the front-end server definitions in the server machine where the front-end server is defined. The following shows an example of items that can be specified in the front-end server definitions:

* Use the server name that is specified in the -s option of the pdstart operand in the system common definitions. For example, if your specification is pdstart -s f001, then store the front-end server definitions in the following file:
  • $PDDIR/conf/f001 file

(5) Creating dictionary server definitions

For dictionary server definitions, define the dictionary server's execution environment. Save the dictionary server definitions created in the following file:

Create the dictionary server definitions in the dictionary server machine where the dictionary server is defined. The following shows an example of items that can be specified in the dictionary server definitions:

* Use the server name that is specified in the -s option of the pdstart operand in the system common definitions. For example, if your specification is pdstart -s dic, then store the dictionary server definitions in the following file:
  • $PDDIR/conf/dic file

(6) Creating back-end server definitions

For back-end server definitions, define the back-end server's execution environment. Save the back-end server definitions created in the following file:

Create the back-end server definitions in the server machine where the back-end server is defined. The following shows an example of items that can be specified in the back-end server definitions:

* Use the server name that is specified in the -s option of the pdstart operand in the system common definitions. For example, if your specification is pdstart -s b001, then store the back-end server definitions in the following file:
  • $PDDIR/conf/b001 file

(7) UAP environment definition creation (optional)

Define UAP execution environments. Create UAP environment definitions as needed, and store them in the following file:

A UAP environment definition is created at the unit with the front-end server. If there are multiple front-end servers, the UAP environment definition can be defined at any of them, as appropriate.

The HiRDB administrator must grant to the users who will use a UAP environment definition the read privilege (r) and the execute privilege (x) for the $PDDIR/conf/pduapenv directory. Read (r) privilege must also be granted for the UAP environment definition file.

The following are examples of the items that can be specified in a UAP environment definition:

1 The file name must begin with an alphabetic character and must not exceed 8 characters in length.

(8) Creating an SQL reserved word definition (optional)

To use the SQL reserved word deletion facility, you must define the reserved words to be deleted for each UAP. You create an SQL reserved word definition as needed and store it in the following file:

Create the SQL reserved word definition on the unit where the front-end server is located. In the event of multiple front-end servers, define the SQL reserved word definition on the front-end server to which the UAP environment definition is to be applied.

The HiRDB administrator must grant to a user who uses the SQL reserved word definition the read (r) and execution (x) privileges for the $PDDIR/conf/pdrsvwd directory and the read privilege (r) for the SQL reserved word deletion file.

* The file name must be expressed as no more than eight alphanumeric characters beginning with an alphabetic character.

(9) Foreign server information definition creation

When the HiRDB External Data Access facility is used, foreign server information definition is required. This definition defines the linkage environment for a foreign server. You create and store a foreign server information definition in the following file:

A foreign server information definition must be created on the server machine where the back-end server that will link to the foreign server is defined.

Which operands you specify in a foreign server information definition depends on the type of foreign server to be linked; for details, see the manual HiRDB Version 8 System Definition.

(10) Hub optimization information definition creation

When the HiRDB External Data Access facility is used, Hub optimization information definition is required. This definition defines optimization information for the HiRDB External Data Access facility. You create and store a Hub optimization information definition in the following file:

A Hub optimization information definition must be created on the server machine where the front-end server is defined. If there are multiple front-end servers, the same Hub optimization information definition is required for each unit.

(11) Configuring the HiRDB system definition files

Figure 5-3 shows an example configuration of HiRDB system definition files.

Figure 5-4 shows an example configuration of HiRDB system definition files when the HiRDB External Data Access facility is used.

Figure 5-3 Configuration of HiRDB system definition files: HiRDB/Parallel Server

[Figure]

Notes
  • The system common definitions must be identical at all server machines.

    Figure 5-4 Configuration of HiRDB system definition files (when the HiRDB External Data Access facility is used)

    [Figure]

Notes
  • The system common definitions must be identical at all server machines.
  • The networked back-end server is the back-end server to be linked with the foreign server. A foreign server information definition file must be created at the unit where the back-end server to be linked to the foreign server is installed.
  • Because this is an environment with multiple front-end servers, a Hub optimization information definition file must be created on each unit.