1.1.2 HiRDB system definition creation procedure

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

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

Table 1-2 Storage files for HiRDB system definitions (HiRDB/Single Server)

Definition typeStorage file name
System common definition%PDDIR%\conf\pdsys
Unit control information definition%PDDIR%\conf\pdutsys
Server common definition1%PDDIR%\conf\pdsvrc
Single server definition%PDDIR%\conf\server-name2
UAP environment definition%PDDIR%\conf\pduapenv\arbitrary-name3
SQL reserved word definition%PDDIR%\conf\pdrsvwd\arbitrary-name3
1 A server common definition is not created when the batch file is used to create the HiRDB system definitions. If a server common definition is needed, the HiRDB administrator must use a text editor such as Notepad to create it.
2 This must be the server name specified in the pdstart operand of the system common definition.
If the simple setup tool or the batch file is used to create the HiRDB system definitions, the file name is sds01.
3
  • 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) simple setup tool
(2) Using the batch file SPsetup.bat
(3) Using a text editor such as Notepad

(1) 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-2. If necessary, the HiRDB administrator can use the simple setup tool to modify the definition contents (operand specification values).

Note that a UAP environment definition or SQL reserved word definition cannot be created using the simple setup tool.

(2) Using the batch file SPsetup.bat

When the batch file is used to set up a HiRDB environment, HiRDB automatically creates HiRDB system definitions (which are stored in the files shown in Table 1-2). If necessary, the HiRDB administrator can use a text editor such as Notepad to modify the definition contents (operand specification values).

Note that a UAP environment definition or SQL reserved word definition cannot be created in a batch file.

(3) 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.