For details about the BES connection holding facility, see the HiRDB Version 8 System Operation Guide.
- 57) PDBESCONHOLD YES | NO
- Specifies whether a foreign HiRDB uses the BES connection holding facility. Note that specification of this operand is ignored if the foreign HiRDB is connected to a HiRDB/Single Server.
- Y: The BES connection holding facility is used.
- N: The BES connection holding facility is not used.
- If this operand is omitted, the value of the pd_bes_connection_hold operand in the back-end server definition of the foreign HiRDB is used.
- The function and specification method of this operand are the same as those of the PDBESCONHOLD operand. For details about the PDBESCONHOLD operand, see the HiRDB Version 8 UAP Development Guide. If the HiRDB version number of the foreign server is different, see the manual for the correct version.
- 58) PDBESCONHTI back-end-server-connection-hold-time
<unsigned integer>((0-3600))(seconds)- When a foreign HiRDB uses the BES connection holding facility, this operand specifies the BES connection holding period in seconds.
- When the BES connection holding facility is used, HiRDB monitors the period between the termination of a transaction and the execution of the next transaction. If this period is within the specified value, the connection between the front-end server and the back-end server is maintained. However, if this period exceeds the specified value, the connection between the front-end server and the back-end server is terminated after the transaction is terminated.
- If 0 is specified for this operand, the period is not monitored. The connection between the front-end server and the back-end server is terminated only when the connection between the front-end server and a client is terminated by SQL DISCONNECT (xa_close if the XA library is being used) or because the value of the PDCWAITTIME operand is exceeded.
- The function and specification method of this operand are the same as those of the PDBESCONHTI operand in the client environment definition. For details about the PDBESCONHTI operand, see the HiRDB Version 8 UAP Development Guide. If the HiRDB version number of the foreign server is different, see the manual for the correct version.