1.2.2 HiRDB system definition creation procedure

The HiRDB administrator uses either of the following tools to create 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 typeStorage 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-name1
Dictionary server definition%PDDIR%\conf\server-name1
Back-end server definition%PDDIR%\conf\server-name1
UAP environment definition%PDDIR%\conf\pduapenv\arbitrary-name2
SQL reserved word definition%PDDIR%\conf\pdrsvwd\arbitrary-name2
foreign server information definition%PDDIR%\conf\foreign-server-name
Hub optimization information definition%PDDIR%\conf\arbitrary-name
1 A server name specified by the -s option of the pdstart operand of the system common definition is specified here.
2
  • A file name must be an alphanumeric character string (a maximum of 8 characters) that begins with a letter. The file name is not case sensitive. That is, A and a are considered the same, and file names ABC and abc are the same.
  • 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 a text editor such as Notepad

(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:

(2) Using a text editor such as Notepad

To set up a HiRDB environment using commands, you use a text editor such as Notepad to create HiRDB system definitions. Specify each HiRDB system definition operand as appropriate to the HiRDB execution environment.

Once the HiRDB system definitions have been created, use the pdconfchk command to check the integrity of the HiRDB system definition operands; for details about the operands that are checked, see F. Operands Checked by the pdconfchk Command.