Table 6-6 lists the organization of HiRDB system definitions. Figure 6-8 shows a configuration example of HiRDB system definition files. Figure 6-9 shows a configuration example of HiRDB system definition files when the HiRDB External Data Access facility is used.

Table 6-6 HiRDB system definitions (HiRDB/Parallel Server)

HiRDB system definition type	Storage file name	Description
System common definition	%PDDIR%\conf\pdsys	Defines the configuration of HiRDB and common information. This file is required for each unit. All units must have the same system common definition.
Unit control information definition	%PDDIR%\conf\pdutsys	Defines unit control information. This file is required for each unit.
Server common definition	%PDDIR%\conf\pdsvrc	Defines default values for individual server definition operands. This file is optional.
Front-end server definition	%PDDIR%\conf\server-name	Defines the execution environment for a front-end server. This file is required for each front-end server.
Dictionary server definition	%PDDIR%\conf\server-name	Defines the execution environment for a dictionary server. This file is required for each dictionary server.
Back-end server definition	%PDDIR%\conf\server-name	Defines the execution environment for a back-end server. This file is required for each backend server.
UAP environment definition	%PDDIR%\conf\pduapenv\any-name	Defines the execution environment for UAPs. This file is optional. You must create UAP environment definitions in a unit that contains a front-end server. If you have multiple front-end servers, define these definitions on the front-end server to which you wish to apply the UAP environment definitions. You can create a maximum of 4096 UAP environment definitions.
SQL reserved word definition	%PDDIR%\conf\pdrsvwd\any-name	Defines SQL reserved words. This file is required to use the SQL reserved word deletion facility. For details about the SQL reserved word deletion facility, see the HiRDB Version 8 UAP Development Guide.
Foreign server information definition	%PDDIR%\conf\foreign-server-name	Defines the connection environment for foreign servers. You must define these definitions in a unit that contains a back-end server for connecting to foreign servers. This file is needed when the HiRDB External Data Access facility is being used.
Hub optimization information definition	%PDDIR%\conf\any-name	Defines optimization information for the HiRDB External Data Access facility. This file is needed when the HiRDB External Data Access facility is being used. Identical hub optimization information definitions must be defined for each unit.

Figure 6-8 Example configuration of HiRDB system definition files (HiRDB/Parallel Server)

Figure 6-9 Example configuration of HiRDB system definition files (when the HiRDB External Data Access facility is being used)

Explanation

• A foreign server information definition file is created in a unit that contains a back-end server for connecting to foreign servers.
• Because this is a multiple front-end server environment, a hub optimization information definition file is created for each unit.