1.1.2 HiRDB system definition creation procedure

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

Store the created HiRDB system definitions in the files listed in the table below. 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 definition#1%PDDIR%\conf\pdsvrc
Single server definition%PDDIR%\conf\server-name#2
UAP environment definition%PDDIR%\conf\pduapenv\any-name#3
SQL reserved word definition%PDDIR%\conf\pdrsvwd\any-name#3
#1
If a batch file is used to create a HiRDB system definition, the server common definition is not created. If a server common definition is needed, we recommend that the HiRDB administrator use a text editor such as Notepad to create it.
#2
This must be the server name specified in the -s option of the pdstart operand in the system common definition.
If the simple setup tool or a batch file is used to create the HiRDB system definition, the file name is sds01.
#3
  • A file name is an alphanumeric character string (a maximum of eight 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.
  • Make sure that the all users who will use the UAP environment definition or SQL reserved word definition are assigned read privilege (r) and execution privilege (x) for the directory in which each file is stored. Also make sure that each file is assigned read privilege (r).
    Note
    Set and maintain the permissions for the HiRDB system definition files so that only the file owner (HiRDB administrator) has read and write privileges.
Organization of this subsection
(1) Using the simple setup tool
(2) Using the batch file SPsetup.bat
(3) Using a text editor such as Notepad

(1) Using the simple setup tool

When the simple setup tool is used to create HiRDB system definitions, the simple setup tool itself sets up the HiRDB environment. The HiRDB system definitions are created automatically based on information specified by using the simple setup tool and are stored in the files listed in Table 1-2 Storage files for HiRDB system definitions (HiRDB/Single Server). If necessary, the HiRDB administrator can use the simple setup tool to modify the definition contents (the values specified for the operands).

Note that a UAP environment definition or an 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 an 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, 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 E. Operands Checked by the pdconfchk Command.