1.1.4 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 definitions, as shown below:

  1. Single server definition
  2. Server common definition
  3. Unit control information definition
  4. System common definition

A standard value can be specified in a definition that has a lower priority, and then that value can be changed by specifying a different value in a definition that has a higher priority.

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

(1) Relationship to client environment definition

The values of the HiRDB system definition operands shown in Table 1-3 can be modified for a client in its client environment definition.

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

HiRDB system definition operandClient environment definition operandOperand contents
pd_additional_optimize_levelPDADDITIONALOPTLVLSpecifies the SQL extension optimizing option.
pd_cwaittime_wrn_pntPDCWAITTIMEWRNPNTSpecifies 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_filePDDELRSVWDFILESpecifies the name of the SQL reserved word deletion file when using the SQL reserved word deletion facility.
pd_hash_table_sizePDHASHTBLSIZESpecifies 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_modePDHJHASHINGMODESpecifies the hashing method when hash join, subquery hash execution is specified as the SQL extension optimizing option.
pd_optimize_levelPDSQLOPTLVLSpecifies the SQL optimization option.
pd_space_levelPDSPACELVLSpecifies a space conversion level.
pd_uap_exerror_log_param_sizePDUAPEXERLOGPRMSZSpecifies the maximum data size for the parameter information to be output to the error log file or SQL error report file.
pd_uap_exerror_log_usePDUAPEXERLOGUSESpecifies whether to use the facility for output of extended SQL error information.
pd_watch_pc_client_timePDSWATCHTIMESpecifies the amount of time to wait for a request from a Windows-compatible HiRDB client.

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