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:
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.
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 configuration)
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.