HiRDB system definition creation procedure

The HiRDB administrator uses one of the following tools to create HiRDB system definitions:

simple setup tool
System generator (pdgen command)
OS text editor

Hint

Normally, you will use the simple setup tool to create the HiRDB system definitions.

The created HiRDB system definitions should be stored in the files listed in Table 1-5. These files are referred to collectively as HiRDB system definition files.

Table 1-5 Storage files for HiRDB system definitions (HiRDB/Parallel Server)

Definition type	Storage file name
System common definition	$PDDIR/conf/pdsys
Unit control information definition	$PDDIR/conf/pdutsys
Server common definition	$PDDIR/conf/pdsvrc
Front-end server definition	$PDDIR/conf/server-name^{1, 2}
Dictionary server definition	$PDDIR/conf/server-name^{1, 3}
Back-end server definition	$PDDIR/conf/server-name^{1, 4}
UAP environment definition	$PDDIR/conf/pduapenv/arbitrary-name⁵
SQL reserved word definition	$PDDIR/conf/pdrsvwd/arbitrary-name⁵
foreign server information definition	$PDDIR/conf/foreign-server-name
Hub optimization information definition	$PDDIR/conf/arbitrary-name

¹ A server name specified by the -s option of the pdstart operand of the system common definition is specified here.

² When the system generator is used to create the HiRDB system definitions, the file names are f001-fxxx, where xxx is a serial number in the range 1-999.

³ When the system generator is used to create the HiRDB system definitions, the file name is dic.

⁴ When the system generator is used to create the HiRDB system definitions, the file names are b001-bxxx, where xxx is a serial number in the range 1-999.

⁵

A file name must be an alphanumeric character string (a maximum of 8 characters) that begins with a letter.
Assign to the users who will use the UAP environment definition or SQL reserved word definition the reading privilege (r) and execution privilege (x) for the directory in which each file is stored. Also assign the reading privilege (r) for the file.

Note

Set and maintain the HiRDB system definition file permissions in such a manner that only the file owner (HiRDB administrator) has read and write permissions.

Organization of this subsection: (1) Using the simple setup tool; (2) Using the system generator (pdgen command); (3) Using an OS text editor

(1) Using the simple setup tool

When the simple setup tool is employed to create HiRDB system definitions, the simple setup tool itself sets up the HiRDB environment. The HiRDB system definitions are created automatically on the basis of information specified with the simple setup tool and are stored in the files listed in Table 1-5. If necessary, the HiRDB administrator can use the simple setup tool to modify the definition contents (operand specification values).

Note that the following definitions cannot be created using the simple setup tool:

UAP environment definition
SQL reserved word definition
Foreign server information definition
Hub optimization information definition

(2) Using the system generator (pdgen command)

When the system generator is employed to create HiRDB system definitions, the system generator itself sets up the HiRDB environment. The HiRDB system definitions are created automatically on the basis of information specified with the system generator and are stored in the files listed in Table 1-5. If necessary, the HiRDB administrator can use the OS text editor to modify the definition contents (operand specification values). For details about the operands created by the pdgen command, see G. Operands Created by the pdgen Command.

Note that the following definitions cannot be created using the system generator:

UAP environment definition
SQL reserved word definition
Foreign server information definition
Hub optimization information definition

1.2.2 HiRDB system definition creation procedure

(1) Using the simple setup tool

(2) Using the system generator (pdgen command)

(3) Using an OS text editor