- 153) pd_service_port = port-number-for-high-speed-connection-from-client
<unsigned integer>((5001-65535))- Specifies the port number for high-speed connection. This operand is specified when the high-speed connection facility is used. The following rules apply to the port number that is specified:
- The port number must be unique within the host
- A port number that is different from the port number specified in pd_name_port must be specified
- For details about the high-speed connection facility, see the HiRDB Version 8 Installation and Design Guide.
- Operation method
- Specify the port number specified with this operand in the client environment definition (PDSERVICEPORT operand) of the client to which the high-speed connection facility is to be applied.
- If the mutual system switchover facility is used, a different port number must be specified for each HiRDB instance.
- If multiple HiRDB systems or multiple HiRDB units will be started on the same machine, a different port number must be specified for each HiRDB instance.
- If a firewall is installed in the HiRDB server, you need to fix the port number for client connection. By specifying this operand, you can fix the port number for client connection. The following client connection method is used in this case:
- If a firewall and NAT are installed in the HiRDB server, use a setting that uses the high-speed connection facility.
- Specify this operand if only a firewall is installed in the HiRDB server. There is no need to specify the client environment definition (PDSERVICEPORT operand).
- For details about how to set the HiRDB environment when a firewall or NAT is installed in the HiRDB server, see the HiRDB Version 8 Installation and Design Guide.
- Notes
- If the port number specified in the pd_name_port operand is specified in pd_service_port, this specification is invalid, and the high-speed connection facility will not be used.
- If the pd_name_port operand is omitted, 20000 must not be specified in pd_service_port.
- Specify a number that is not within the range of port numbers assigned automatically by the OS. The range of port numbers assigned automatically by the OS depends on the OS.
- If a port number is specified that is within the range of port numbers assigned automatically by the OS, that number may be being used by another program. If so, the HiRDB server will not start.
- If a mutual system switchover configuration is used, specify this operand in the unit control information definition. Specify a different port number in the unit control information definition for each unit. If the same port numbers are specified, system switchover will fail in one of the units during a switching attempt.
- If the high-speed connection facility is used to concurrently issue a number of connection requests that exceeds the value specified for the pd_max_users operand, a shortage occurs in the number of active front-end servers and single servers for extracting connection requests from the message queue. Consequently, connection requests cannot be extracted from the message queue, and the message queue monitoring facility may stop the unit. Therefore, make sure that the number of concurrent connection requests generated does not exceed the value specified for the pd_max_users operand. For details about the message queue monitoring facility, see the HiRDB Version 8 System Operation Guide.
- 154) pd_change_clt_ipaddr = 0 | 1
- Specifies the network to be used by the HiRDB server to communicate with HiRDB clients.Normally, this operand need not be specified.
- 0:
- Communication from the HiRDB server to HiRDB clients uses the network in which the IP address specified in the PDCLTRCVADDR operand of the client environment definition is located. If the PDCLTRCVADDR operand is omitted, the IP address of the standard host is assumed.
- 1:
- For communication from the HiRDB server to HiRDB clients, the network used for communication from HiRDB clients to the HiRDB server is used.
- Relationship to other operands
- If v6compatible or v7compatible is specified in the pd_sysdef_default_option operand, the default value for this operand is 0.
- 155) pd_registered_port ="port-number-reservation-range" [,"port-number-reservation-range"]...
<character string>- Specifies ranges of port numbers to be used for communication by the HiRDB server.
- HiRDB reserved port facility is valid only for server-to-server communication. This facility need not be used if the number of ports to be used is small.
- Operand specification example
- This example provides the following 35,000 port numbers: 6000 to 8999, 12500 to 29999, and 30500 to 44999:
- set pd_registered_port = "6000:8999","12500:29999","30500:44999"
- Advantages
- The port numbers to be used for communication between HiRDB servers are assigned automatically by the OS. If the communication volume increases significantly, a shortage of port numbers may cause an interruption of processing or may adversely affect the communication processing by other programs. Using this operand, specify a range of port numbers to be used exclusively by HiRDB can prevent such problems.
- Specification guidelines
- The range of port numbers that can be specified is from 5001 through 49151.
- For the number of ports used by HiRDB, see the HiRDB Version 8 Installation and Design Guide.
- Specification value tuning method
- As a guideline, the value obtained from the following formula is the total number of ports that will be needed:
- a + b + 100
- a: Number of HiRDB reserved ports that are being used (# OF REGISTERED PORTS)
- b: Number of ports being used that were assigned automatically by the OS because all HiRDB reserved ports were in use (# OF ASSIGNED PORTS)
- These values can be determined from the statistical information related to system operation obtained by executing the statistics analysis utility.
- Operand rules
- Up to 10 ranges of port numbers can be specified.
- If more than one range is specified, ensure that there is no overlap in the port numbers included in the various ranges.
- An ending port number must be greater than the paired starting port number.
- Notes
- Make sure that the port number reservation ranges specified in this operand do not overlap the port numbers listed below; if there is any overlap, a problem such as a HiRDB startup error may occur:
Port numbers specified by the pd_name_port operand
Port numbers specified by the pd_service_port operand
Port numbers specified by the -p option of the pdunit operand
Port numbers registered in %windir%\system32\drivers\etc\services
The port number specified by the PDCLTRCVPORT operand in the HiRDB client environment definition (provided that the HiRDB exists on the same server machine).
Port numbers being used by other programs
Port numbers assigned automatically by the OS
- If multiple HiRDB servers reside on the same server machine (for example, in a multi-HiRDB structure or when the system switchover facility is used), ensure that the port number reservation ranges of the individual HiRDB servers do not overlap.
- This facility is valid only for server-to-server communication.
- Specify port numbers that are outside the range of port numbers assigned automatically by the OS. The range of port numbers assigned automatically by the OS depends on the OS.
- In the case of a port that does not support the HiRDB reserved port facility, specification of its port number in this operand is ignored. For the scope of the HiRDB reserved port facility, see the pd_registered_port_level operand.
- 156) pd_registered_port_check = Y | N | C | W
- Specifies whether or not checking is to be performed for overlapping port numbers in the ranges of port numbers specified in the pd_registered_port operand and in the port numbers registered in
- %windir%\system32\drivers\etc\services (definition location in a DNS environment).
- Y:
- Check for overlap. If an overlap is found, the KFPS00348-E message is output and HiRDB activation is canceled.
- N:
- Do not check for overlap.
- C:
- Check for overlap. The HiRDB reserved port facility is not applied to any overlapping port number.
- W:
- Check for overlap. If an overlap is found, the KFPS00354-W message is output. The HiRDB reserved port facility is not applied to any overlapping port number.
- Condition
- The pd_registered_port operand must be specified.
- Specification guidelines
- If an overlap in port numbers is detected, HiRDB communication may be affected adversely, resulting for example in the receipt of wrong messages or message send failures.
- If Y, C, or W is specified, process server activation in a DNS environment may slow down.
- Remarks
- When HiRDB starts, it checks for overlap between the port numbers included in the pd_registered_port operand's range specification and the port numbers specified in the operands listed below. If an overlapping port number is detected, HiRDB displays the KFPS00348-E message and cancels the startup processing.
- pd_name_port operand
- -p option of the pdunit operand
- pd_service_port operand
- Note that overlap checking is not performed on port numbers specified in any other operands.
- 157) pd_registered_port_level = 0 | 1
- Specifies the target range for the HiRDB reserved port facility.
- Condition
- The pd_registered_port operand must be specified.
- Specification guidelines
- The following shows the target range depending on the value of this operand (0 or 1):
Port numbers used by HiRDB | Value of pd_registered_port_level |
---|
0 | 1 |
---|
Ports used by HiRDB server | Send port number for server-to-server communication | Y | Y |
Receive port number for server-to-server communication | Y | Y |
Port number specified in pd_name_port, pd_service_port, or pdunit -p operand | N | N |
Send port number for command | N | N |
Receive port number for command | N | N |
Send port number for client | N | Y |
Receive port number for client | Y | Y |
Service port number for communication port | N | N |
Port number used for lock control | N | N |
Ports used by HiRDB client | Send port number | N | N |
Receive port number | N | N |
- Legend:
- Y: Subject to the HiRDB reserved port facility. A port number specified in the pd_registered_port operand is used.
- N: Not subject to the HiRDB reserved port facility.
- 158) pd_ipc_send_retrycount = process-to-process-send-retries-count
<unsigned integer>((1-32767))<<200>>(Times)- Specifies the number of times process-to-process communication can be attempted. This operand is related to the pd_ipc_send_retrysleeptime operand.
- Examples
- pd_ipc_send_retrycount = 500
- pd_ipc_send_retrysleeptime = 2
- When the operands are specified in this way, send is attempted up to 500 times and a 2-second sleep occurs between attempts.
- Specification guidelines
- Normally, this operand need not be specified.
- Specifying too large a value for this operand increases the CPU lock rate.
- 159) pd_ipc_send_retrysleeptime = process-to-process-send-retry-sleep-time
<unsigned integer>((0-60)) <<0>> (seconds)- Specifies the sleep time between process-to-process send retries.
- This operand is related to the pd_ipc_send_retrycount operand.
- Examples
- pd_ipc_send_retrycount = 500
- pd_ipc_send_retrysleeptime = 2
- When the operands are specified in this way, send is attempted up to 500 times and a 2-second sleep occurs between attempts.
- Specification guidelines
- Normally, this operand need not be specified.
- Specifying too large a value for this operand increases communication completion time.
- 160) pd_ipc_send_count = server-to-server-send-retries-count
<unsigned integer>((1-32767)) <<60>>- Specifies the number of times a server-to-server send can be performed before the send is completed. A send occurs for up to 5 seconds at each retry. With the default value, send will be performed for up to 60
5 seconds = 300 seconds. - Specification guideline
- Normally, this operand need not be specified. If transmission timeouts occur frequently, increase this operand's value.
- 161) pd_ipc_recv_count = server-to-server-receive-retries-count
<unsigned integer>((1-32767)) <<120>>- Specifies the number of times a server-to-server receive can be performed before receive is completed. Receive occurs for up to 5 seconds at each retry. With the default value, receive is performed for up to 120
5 seconds = 10 minutes. - Specification guideline
- Normally, this operand need not be specified.
- 162) pd_ipc_conn_nblock = Y | N
- Specifies whether to establish connection in the non-block mode for HiRDB server-to-server communication (communication between units).
- Y: Establishes the connection in the non-block mode.
- N: Establishes the connection in the block mode.
- Advantage
- When you specify Y for this operand, you can issue connect() system calls in the non-block mode for HiRDB server-to-server communication (communication between units). As a result, the duration for which connect() system calls block processes during a LAN error, which used to last dozens of seconds (depending on the OS), can now be shortened to the time specified in the pd_ipc_conn_nblock_time operand.
- Relationship to other operands
- This operand is related to the following operands:
- pd_ipc_conn_nblock_time
- pd_ipc_conn_interval
- pd_ipc_conn_count
- pd_host_watch_interval
- Specification guidelines
- Normally, there is no need to specify this operand.
- Remarks
- For establishing communication connection between a client and a server, specify the necessary parameter in the client environment definition (PDNBLOCKWAITTIME operand).
- 163) pd_ipc_conn_nblock_time = connection-establishment-monitoring-time-in-non-block-mode
<unsigned integer>((1-120))<<8>>(seconds)- Specifies whether or not connection is to be established in the non-block mode for HiRDB server-to-server communication (communication between units).
- Condition
- This operand is valid when Y is specified for the pd_ipc_conn_nblock operand.
- Advantage
- If unreasonable communication errors occur frequently, increasing the value specified for this operand may reduce the number of communication errors.
- Specification guidelines
- Normally, there is no need to specify this operand.
- If unreasonable communication errors occur frequently, use the ping command of the OS, for example, to measure the communication time between HiRDB servers. If that time is greater than the value specified for this operand, specify a value greater than that communication time for this operand.
- Note
- Increasing the specification value for this operand increases the timeout duration when communication is disabled. Consequently, other processes may be adversely affected.
- Relationship to other operands
- This operand is related to the following operands:
- pd_ipc_conn_nblock
- pd_ipc_conn_interval
- pd_ipc_conn_count
- Remarks
- HiRDB communicates with other units at a given interval (the value of the pd_host_watch_interval operand; the default value is 10 seconds) to monitor the operating status of other units.
- If a LAN error occurs immediately after a monitoring-target unit has responded, HiRDB tries to communicate with that unit after a certain wait time (the value of the pd_host_watch_interval operand). Thereafter, communication retry is carried out for the duration specified by the pd_ipc_conn_nblock_time operand (the default value is 8 seconds). Therefore, the time until the abnormal termination of the monitoring-target unit is detected is the time combining the values of the two operands.
- The following figure shows the time line until HiRDB detects the abnormal termination of the monitoring-target unit.
![[Figure]](figure/zu020015.gif)
- 164) pd_ipc_conn_interval = connection-establishment-retry-interval
<unsigned integer>((0-50))<<1>>- Specifies the retry interval for establishing connection for sending data. Connection establishment retries are made in the following cases:
- A connection timeout has occurred.
- A shortage has occurred in the Listen queue.
- Specification guidelines
- Normally, there is no need to specify this operand.
- When specifying this operand, make sure that the following condition is satisfied:
value-specified-for-this-operand < value-of-pd_ipc_conn_nblock_time-and-PDNBLOCKWAITTIME-in-client-environment-definition
- Relationship to other operands
- This operand is related to the following operands:
- pd_ipc_conn_count
- pd_ipc_conn_nblock
- pd_ipc_conn_nblock_time
- Remarks
- The following figure shows examples of retries in non-block mode and block mode communication.
![[Figure]](figure/zu020016.gif)
Explanation
With the following specifications, non-block mode connection establishment is retried for 8 seconds at 1-second intervals.
pd_ipc_conn_nblock_time = 8
pd_ipc_conn_interval = 1
![[Figure]](figure/zu020017.gif)
Explanation
With the following specifications, non-block mode connection establishment is retried 5 times at 10-second intervals.
pd_ipc_conn_interval = 10
pd_ipc_conn_count = 5
- 165) pd_ipc_conn_count = connection-establishment-retry-count
<unsigned integer>((0-600))<<50>>- Specifies the number of retries for establishing connection for sending data. Connection establishment retries are made in the following cases:
- A connection timeout has occurred.
- A shortage has occurred in the Listen queue.
- This operand is related to the pd_ipc_conn_interval operand.
- Example
- pd_ipc_conn_interval = 10
- pd_ipc_conn_count = 5
- With these specifications, connection establishment is retried every 10 seconds up to 5 times.
- Specification guidelines
- Normally, there is no need to specify this operand.
- Note
- For non-block mode connection establishment, the specification of this operand is invalid.
- Non-block mode connection establishment is executed when the following conditions are satisfied:
- Y is specified for the pd_ipc_conn_nblock operand.
- The PDNBLOCKWAITTIME operand in the client environment definition is specified.
- 166) pd_ipc_inet_bufsize = send-receive-buffer-size-for-server-unit-to-unit-communication
<unsigned integer>((0-262144)) <<16384>> (bytes)- Specifies as a multiple of 4096 a size for the send/receive buffer to be used for unit-to-unit communication within a server (TCP NET domain).
- Specification guideline
- Normally, this operand need not be specified.
- Notes
- If 0 is specified, the value set by the OS is used.
- The maximum TCP buffer size depends on the OS.
- The specified buffer size may not be valid. In this case, the value set by Windows is used.
- 167) pd_tcp_inet_bufsize = send-receive-buffer-size-for-communication-with-HiRDB-client-outside-host-where-HiRDB-server-reside
<unsigned integer>((0-262144))<<0>>(bytes)- Specifies as a multiple of 4096 a maximum size for the send/receive buffer to be used for communication with a HiRDB client connected from outside the host where the HiRDB server resides (TCP INET domain).
- Specification guidelines
- Normally, this operand need not be specified. Specify this operand if one of the following occurs:
- Resending of the data to be sent/received between a HiRDB server and a HiRDB client is observed (specifying this operand can suppress resending)
- The data arrival speed is slower than the data read speed on the receiving side (specifying this operand can prevent the delay caused by waiting for data arrival even when the data volume increases)
- Specify for this operand the same value as the buffer size to be used for communication.
- Notes
- If 0 is specified, the value set by the OS is used.
- The maximum TCP buffer size depends on the OS.
- The specified buffer size may not be valid. In this case, the value set by Windows is used.
- 168) pd_utl_buff_size = utility-communication-buffer-size
<unsigned integer>((8-64))<<32>>(KB)- Specifies in kilobytes the size of each sector of the buffers used for communication by the following utility processes:
- Database load utility
- Database reorganization utility (with -g option specified)
- Database recovery utility
- Database copy utility
- Specification guidelines
- communication-buffer-size =
(page-size*
2)
1024
(KB) - * Maximum page size of RDAREAs to be processed by the utility.
- Operand rules
- Specify a multiple of 4. If the specified value is not a multiple of 4, it is rounded up automatically to a multiple of 4.
- If the specified value is smaller than 32, it will be increased automatically to 32 when the database recovery utility or database copy utility is executed.
- 169) pd_sql_send_buff_size = buffer-size-for-inter-server-communication-for-SQL-execution
<unsigned integer>((4-32))<<4>>(KB)- This operand is applicable only to a HiRDB/Parallel Server.
- Specify the size of each communication buffer (in KB) to be used for sending search result data between HiRDB servers.
- Specification guidelines
- communication-buffer-size =
page-size*
1024
(Units: KB) - * page-size = row-size
communication-count-per-case - For the data size of variable-length data, use the actual size.
- Because LOB columns and abstract data type columns are excluded, do not include them in the page size.
- Note
- Increasing the specification value of this operand may increase the amount of memory used.