Relationships among HiRDB system definitions

If the same operand is defined in different definitions, HiRDB determines the value to be used on the basis of the priority order of the following definitions:

Front-end server definition, dictionary server definition, or back-end server definition
Server common definition
Unit control information definition
System common definition

A standard value can be specified in a definition of a lower priority, and then that value can be changed by specifying a different value in a definition of a higher priority. For example, a standard value can be specified in the system common definition and then this value can be changed by specifying values in the server definitions of individual servers.

Organization of this subsection: (1) Relationship to client environment definition

The values of the HiRDB system definition operands listed in the following table can be modified for each client in its client environment definition.

Table 1-6 Operands with specification values that can be modified in client environment definitions (HiRDB/Parallel Server)

HiRDB system definition operand	Client environment definition operand	Operand contents
pd_additional_optimize_level	PDADDITIONALOPTLVL	Specifies the SQL extension optimizing option.
pd_cwaittime_wrn_pnt	PDCWAITTIMEWRNPNT	Specifies the condition for outputting the SQL runtime warning information of the SQL runtime warning output facility as a percentage of the client's maximum wait time (value specified by the PDCWAITTIME operand in the client environment definition).
pd_delete_reserved_word_file	PDDELRSVWDFILE	Specifies the name of the SQL reserved word deletion file when using the SQL reserved word deletion facility.
pd_ha_transaction	PDHATRNQUEUING	Specifies whether to use the transaction queuing facility.
pd_hash_table_size	PDHASHTBLSIZE	Specifies the hash table size when hash execution of a hash join or a subquery is used as the SQL extension optimizing option.
pd_hashjoin_hashing_mode	PDHJHASHINGMODE	Specifies the hashing method when hash join, subquery hash execution is specified as the SQL extension optimizing option.
pd_optimize_level	PDSQLOPTLVL	Specifies the SQL optimization option.
pd_space_level	PDSPACELVL	Specifies a space conversion level.
pd_uap_exerror_log_param_size	PDUAPEXERLOGPRMSZ	Specifies the maximum data size of the parameter information to be output to the client error log file or to the SQL error report file.
pd_uap_exerror_log_use	PDUAPEXERLOGUSE	Specifies whether to use the facility for output of extended SQL error information.
pd_watch_pc_client_time	PDSWATCHTIME	Specifies the amount of time to wait for a request from a Windows-compatible HiRDB client.

To change the value for a client, the applicable operand is specified in the client's environment definition. For details about client environment definition, see the HiRDB Version 9 UAP Development Guide.

1.2.4 Relationships among HiRDB system definitions

(1) Relationship to client environment definition