10.3.7 Operands related to communication processing

8) pd_registered_port_level = 0 | 1
Operand default value
  • Default value in recommended mode: 1
  • Default value in 0904 compatibility mode: 0
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 HiRDBValue of pd_registered_port_level
01
Ports used by HiRDB serverSend port number for server-to-server communicationYY
Receive port number for server-to-server communicationYY
Port number specified in pd_name_port operandNN
Port number specified in -p option of pdunit operandNN
Port number specified in pd_service_port operandNN
Port number specified in pd_scd_port operandNN
Port number specified in -s option of pdunit operandNN
Port number specified in pd_trn_port operandNN
Port number specified in -t option of pdunit operandNN
Port number specified in pd_mlg_port operandNN
Port number specified in -m option of pdunit operandNN
Port number specified in pd_alv_port operandNN
Port number specified in -a option of pdunit operandNN
Send port number for commandNN
Receive port number for commandNN
Send port number for clientNY
Receive port number for clientYY
Ports used by HiRDB clientSend port numberNN
Receive port numberNN
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.
9) pd_inet_unix_bufmode = os | conf
Operand default value
  • Default value in recommended mode: os
  • Default value in 0904 compatibility mode: The default value is shown below.
    For Linux and Solaris: os
    For AIX and HP-UX: conf
Specifies the size of the send/receive buffer to be used for communication with HiRDB.
os: Use the value set by the OS.
If a send/receive buffer size is specified in any of the following operands, that value is ignored and the value set by the OS is used:
  • pd_tcp_inet_bufsize operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
conf: Use the value specified by the following operands:
  • pd_tcp_inet_bufsize operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
Specification guidelines
  • Normally, specify os in this operand to use the value set by the OS.
  • There are advantages and disadvantages of specifying conf, as described below. If you specify conf, perform a thorough evaluation including a verification of the machine's performance capabilities.
    [Figure]If the send/receive buffer size is small and large data such as BLOB data is sent and received, data resend operations occur. This might adversely affect the communication performance and CPU usage rate. In this case, you can improve the communication performance and reduce the CPU usage rate by increasing the send/receive buffer size.
    [Figure]If the send/receive buffer size is large and small data, such as numeric data, is sent and received, ACK might not be returned quickly (delayed ACK) when data is received depending on how TCP/IP is configured. This might result in poor performance.
Note
The send/receive buffer size, OS settings, how to change the size, and the supported size range depend on the OS. For details, see the OS documentation.
Relationship to other operands
This operand is related to the following operands:
  • pd_tcp_inet_bufsize operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
  • pd_listen_socket_bufset operand
  • pd_inet_unix_utl_bufmode operand
  • pd_utl_buff_size operand
The tables below list the send/receive buffer sizes that depend on the combination of the value specified for this operand and the values of the operands related to this operand. Tables 10-2, 10-3, and 10-4 list the send/receive buffer size for communication with clients and with servers in the TCP INET domain, and Tables 10-5, 10-6, and 10-7 list the send/receive buffer size for communications with clients and with servers in the TCP UNIX domain.
[Figure]Communications in the TCP INET domain

Table 10-2 Communication with clients in the TCP INET domain

No.Value of the pd_inet_unix_bufmode operandValues of related operandsSend/receive buffer size that is set
pd_tcp_inet_bufsizepd_inet_unix_utl_bufmodepd_listen_socket_bufsetpd_ipc_inet_bufsize
1os--------
  • connect, accept, and listen sockets:
    OS setting
2conf000
  • connect, accept, and listen sockets:
    OS setting
3Other than 0
  • connect and listen sockets:
    OS setting
  • accept socket:
    Value of the pd_ipc_inet_bufsize operand
410
  • connect, accept, and listen sockets:
    OS setting
5Other than 0
  • connect socket:
    OS setting
  • accept and listen sockets:
    Value of the pd_ipc_inet_bufsize operand
6Other than 000
  • connect socket:
    Value of the pd_tcp_inet_bufsize operand
  • accept and listen sockets:
    OS setting
7Other than 0
  • connect socket:
    Value of the pd_tcp_inet_bufsize operand
  • accept socket:
    Value of the pd_ipc_inet_bufsize operand
  • listen socket:
    OS setting
810
  • connect socket:
    Value of the pd_tcp_inet_bufsize operand
  • accept and listen sockets:
    OS setting
9Other than 0
  • connect socket:
    Value of the pd_tcp_inet_bufsize operand
  • accept and listen sockets:
    Value of the pd_ipc_inet_bufsize operand
Legend:
--: Ignored if specified.

Table 10-3 Communication with servers in the TCP INET domain (communication without using the pd_utl_buff_size operand)

No.Value of the pd_inet_unix_bufmode operandValues of related operandsSend/receive buffer size that is used
pd_tcp_inet_bufsizepd_inet_unix_utl_bufmodepd_listen_socket_bufsetpd_ipc_inet_bufsize
1os--------
  • connect, accept, and listen sockets:
    OS setting
2conf00
  • connect, accept, and listen sockets:
    OS setting
3Other than 0
  • connect and accept sockets:
    Value of the pd_ipc_inet_bufsize operand
  • listen socket:
    OS setting
410
  • connect, accept, and listen sockets:
    OS setting
5Other than 0
  • connect, accept, and listen sockets:
    Value of the pd_ipc_inet_bufsize operand
Legend:
--: Ignored if specified.

Table 10-4 Communication with servers in the TCP INET domain (communication using the pd_utl_buff_size operand)

No.Value of the pd_inet_unix_bufmode operandValues of related operandsSend/receive buffer size that is used
pd_tcp_inet_bufsizepd_inet_unix_utl_bufmodepd_listen_socket_bufsetpd_ipc_inet_bufsize
1os--------
  • connect, accept, and listen sockets:
    OS setting
2confconf00
  • connect, accept, and listen sockets:
    OS setting
3Other than 0
  • connect and accept sockets:
    Value of the pd_ipc_inet_bufsize operand
  • listen socket:
    OS setting
410
  • connect, accept, and listen sockets:
    OS setting
5Other than 0
  • connect, accept, and listen sockets:
    Value of the pd_ipc_inet_bufsize operand
6auto00
  • connect and accept sockets:
    Value automatically calculated from the pd_utl_buff_size operand value
  • listen socket:
    OS setting
7Other than 0
  • connect and accept sockets:
    Value automatically calculated from the pd_utl_buff_size operand value
  • listen socket:
    OS setting
810
  • connect and accept sockets:
    Value automatically calculated from the pd_utl_buff_size operand value
  • listen socket:
    OS setting
9Other than 0
  • connect and accept sockets:
    Value automatically calculated from the pd_utl_buff_size operand value
  • listen socket:
    Value of the pd_ipc_inet_bufsize operand
Legend:
--: Ignored if specified.
[Figure]Communications in the TCP UNIX

Table 10-5 Communication with clients in the TCP UNIX

No.Value of the pd_inet_unix_bufmode operandValues of related operandsSend/receive buffer size that is used
pd_tcp_unix_bufsizepd_inet_unix_utl_bufmodepd_listen_socket_bufsetpd_ipc_unix_bufsize
1os--------
  • connect, accept, and listen sockets:
    OS setting
2conf000
  • connect, accept, and listen sockets:
    OS setting
3Other than 0
  • connect and listen sockets:
    OS setting
  • accept socket:
    Value of the pd_ipc_unix_bufsize operand
410
  • connect, accept, and listen sockets:
    OS setting
5Other than 0
  • connect and listen sockets:
    OS setting
  • accept socket:
    Value of the pd_ipc_unix_bufsize operand
6Other than 000
  • connect socket:
    Value specified for pd_tcp_unix_bufsize
  • accept and listen sockets:
    OS setting
7Other than 0
  • connect socket:
    Value specified for pd_tcp_unix_bufsize
  • accept socket:
    Value of the pd_ipc_unix_bufsize operand
  • listen socket:
    OS setting
810
  • connect socket:
    Value specified for pd_tcp_unix_bufsize
  • accept and listen sockets:
    OS setting
9Other than 0
  • connect socket:
    Value specified for pd_tcp_unix_bufsize
  • accept socket:
    Value of the pd_ipc_unix_bufsize operand
  • listen socket:
    OS setting
Legend:
--: Ignored if specified.

Table 10-6 Communication with servers in the TCP UNIX domain (communication without using the pd_utl_buff_size operand)

No.Value of the pd_inet_unix_bufmode operandValues of related operandsSend/receive buffer size that is used
pd_tcp_unix_bufsizepd_inet_unix_utl_bufmodepd_listen_socket_bufsetpd_ipc_unix_bufsize
1os--------
  • connect, accept, and listen sockets:
    OS setting
2conf00
  • connect, accept, and listen sockets:
    OS setting
3Other than 0
  • connect and accept sockets:
    Value of the pd_ipc_unix_bufsize operand
  • listen socket:
    OS setting
410
  • connect, accept, and listen sockets:
    OS setting
5Other than 0
  • connect, accept, and listen sockets:
    Value of the pd_ipc_unix_bufsize operand
Legend:
--: Ignored if specified.

Table 10-7 Communication with servers in the TCP UNIX domain (communication using the pd_utl_buff_size operand)

No.Value of the pd_inet_unix_bufmode operandValues of related operandsSend/receive buffer size that is used
pd_tcp_unix_bufsizepd_inet_unix_utl_bufmodepd_listen_socket_bufsetpd_ipc_unix_bufsize
1os--------
  • connect, accept, and listen sockets:
    OS setting
2confconf00
  • connect, accept, and listen sockets:
    OS setting
3Other than 0
  • connect and accept sockets:
    Value of the pd_ipc_unix_bufsize operand
  • listen socket:
    OS setting
410
  • connect, accept, and listen sockets:
    OS setting
5Other than 0
  • connect and accept sockets:
    Value of the pd_ipc_unix_bufsize operand
  • listen socket:
    OS setting
6auto00
  • connect and accept sockets:
    Value automatically calculated from the pd_utl_buff_size operand value
  • listen socket:
    OS setting
7Other than 0
  • connect and accept sockets:
    Value automatically calculated from the pd_utl_buff_size operand value
  • listen socket:
    OS setting
810
  • connect and accept sockets:
    Value automatically calculated from the pd_utl_buff_size operand value
  • listen socket:
    OS setting
9Other than 0
  • connect and accept sockets:
    Value automatically calculated from the pd_utl_buff_size operand value
  • listen socket:
    OS setting
Legend:
--: Ignored if specified.
10) pd_ipc_inet_bufsize = send-receive-buffer-size-for-server-unit-to-server-unit-communication
~<unsigned integer>((0-262144))<<16384>> (bytes)
Specifies, as a multiple of 4,096 bytes, the maximum size of the send/receive buffer to be used for server unit-to-server unit communication (TCP INET domain).
Specification guidelines
  • Normally, there is no need to specify this operand. Specify os in the pd_inet_unix_bufmode operand and use the value set by the OS.
  • If you specify conf in the pd_inet_unix_bufmode operand, use this operand to specify the send/receive buffer size used for HiRDB communication processing.
Notes
  • If 0 is specified, the value set by the OS is used.
  • The maximum TCP buffer size depends on the OS.
Relationship to other operands
This operand is related to the following operands:
  • pd_inet_unix_bufmode operand
  • pd_tcp_inet_bufsize operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_unix_bufsize operand
  • pd_listen_socket_bufset operand
  • pd_inet_unix_utl_bufmode operand
  • pd_utl_buff_size operand
11) pd_ipc_unix_bufsize = send-receive-buffer-size-for-communication-within-server-unit
~<unsigned integer>((0-262144))<<16384>> (bytes)
Specifies, as a multiple of 4,096, the size of the send/receive buffer to be used for communication within a server unit (TCP UNIX domain).
Specification guidelines
  • Normally, there is no need to specify this operand. Specify os in the pd_inet_unix_bufmode operand and use the value set by the OS.
  • If you specify conf in the pd_inet_unix_bufmode operand, use this operand to specify the send/receive buffer size used for HiRDB communication processing.
Notes
  • If 0 is specified, the value set by the OS is used.
  • The maximum TCP buffer size depends on the OS.
Relationship to other operands
This operand is related to the following operands:
  • pd_inet_unix_bufmode operand
  • pd_tcp_inet_bufsize operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_listen_socket_bufset operand
  • pd_inet_unix_utl_bufmode operand
  • pd_utl_buff_size operand
12) pd_tcp_inet_bufsize = send-receive-buffer-size-for-communication-with-HiRDB-client-outside-host-where-HiRDB-server-resides
~<unsigned integer>((0-262144))<<0>> (bytes)
Specifies, as a multiple of 4,096 bytes, the maximum size of the send/receive buffer to be used for communication (TCP INET domain) with HiRDB clients connected from a host outside the host where the HiRDB server resides.
Specification guidelines
  • Normally, this operand does not need to be specified. Specify os in the pd_inet_unix_bufmode operand and use the value set by the OS.
  • If you specify conf in the pd_inet_unix_bufmode operand, use this operand to specify the send/receive buffer size used for HiRDB communication processing.
Notes
  • If 0 is specified, the value set by the OS is used.
  • The maximum TCP buffer size depends on the OS.
Relationship to other operands
This operand is related to the following operands:
  • pd_inet_unix_bufmode operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
  • pd_listen_socket_bufset operand
  • pd_inet_unix_utl_bufmode operand
  • pd_utl_buff_size operand
13) pd_tcp_unix_bufsize = send-receive-buffer-size-for-communication-with-HiRDB-client-inside-host-where-HiRDB-server-resides
~<unsigned integer>((0-262144))<<16384>> (bytes)
Specifies, as a multiple of 4,096, the maximum size of the send/receive buffer to be used for communication with the following HiRDB clients connected from the host where the HiRDB server resides (TCP UNIX domain):
  • HiRDB clients of HiRDB Version 4.0 04-02 or earlier
  • HiRDB clients that use HiRDB XA libraries that support multithreading
Specification guidelines
  • Normally, this operand does not need to be specified. Specify os in the pd_inet_unix_bufmode operand and use the value set by the OS.
  • If you specify conf in the pd_inet_unix_bufmode operand, use this operand to specify the send/receive buffer size used for HiRDB communication processing.
Notes
  • If 0 is specified, the value set by the OS is used.
  • The maximum TCP buffer size depends on the OS.
  • In Linux, communications do not use the TCP UNIX domain protocol, so the specified buffer size is not valid. In this case, the pd_tcp_inet_bufsize specification is used.
Relationship to other operands
This operand is related to the following operands:
  • pd_inet_unix_bufmode operand
  • pd_tcp_inet_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
  • pd_listen_socket_bufset operand
  • pd_inet_unix_utl_bufmode operand
  • pd_utl_buff_size operand
14) pd_listen_socket_bufset = 0 | 1
Specifies whether the send/receive buffer is to be set in a listen socket when the listen socket for a TCP INET domain that is used for HiRDB communication processing is created.
0: Do not set the send/receive buffer size in the listen socket.
1: Set the send/receive buffer size in the listen socket.
For the send/receive buffer size, the value of the pd_ipc_inet_bufsize operand is set. However, the following conditions must be satisfied:
  • conf is specified for the pd_inet_unix_bufmode operand.
  • A non-zero value is specified for the pd_ipc_inet_bufsize operand.
For details, see the description of the pd_inet_unix_bufmode operand.
Specification guidelines
  • Normally, this operand does not need to be specified. Specify os in the pd_inet_unix_bufmode operand and use the value set by the OS.
  • When conf is specified for the pd_inet_unix_bufmode operand, and the send/receive buffer size specified for this operand is used, if the value of the pd_ipc_inet_bufsize operand is smaller than the value set by the OS, a communication delay might occur. In this case, you might be able to improve the communication performance by specifying 1 for this operand.
Note
If you have specified 1 for this operand, you must use the send/receive buffer size set by this operand, even if you specify conf for the pd_utl_inet_unix_bufmode operand and perform communication using the pd_utl_buff_size operand. Set the send/receive buffer size in such a manner that the same size is used for the listen and accept sockets. If different send/receive buffer sizes are used for the listen and accept sockets, the communication performance might not be improved.
Relationship to other operands
This operand is related to the following operands:
  • pd_inet_unix_bufmode operand
  • pd_tcp_inet_bufsize operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
  • pd_inet_unix_utl_bufmode operand
  • pd_utl_buff_size operand
15) pd_utl_buff_size = utility-communication-buffer-size
~<unsigned integer>((8-64))<<32>> (kilobytes)
Specifies in kilobytes the size of each sector of the buffers used for communication by the following utility processes:
  • Database load utility (pdload)
  • Database reorganization utility (pdrorg with -g option specified)
  • Rebalancing utility (pdrbal)
  • Database recovery utility (pdrstr)
  • Database copy utility (pdcopy)
Advantage
When data is re-sent in communications between a server process that is processing a utility and a HiRDB server, the number of communication instances can be reduced by increasing the specification of this operand, which can improve performance.
Specification guidelines
communication-buffer-size = [Figure](page-size#[Figure] 2)[Figure] 1024[Figure] (kilobytes)
#: 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.
Relationship to other operands
This operand is related to the operands listed below. For details, see the description of the pd_inet_unix_bufmode operand.
  • pd_inet_unix_bufmode operand
  • pd_tcp_inet_bufsize operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
  • pd_listen_socket_bufset operand
  • pd_inet_unix_utl_bufmode operand
Effects on individual estimation formulas
If the value of the pd_utl_buff_size operand is changed, the following estimation formulas are affected:
HiRDB Version 9 Installation and Design Guide:
  • Memory size required for the execution of the database recovery utility (pdrstr)
  • Memory size required for the execution of the database load utility (pdload)
  • Memory size required for the execution of the database copy utility (pdcopy)
16) pd_inet_unix_utl_bufmode = auto | conf
Specifies the size of the send/receive buffer to be used for communications that use the pd_utl_buff_size operand.
auto:
Automatically calculate the value based on the pd_utl_buff_size operand.
conf:
Use the value specified for the following operands:
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
Specification guidelines
  • Normally, this operand does not need to be specified. Specify os in the pd_inet_unix_bufmode operand and use the value set by the OS.
  • If you specify conf for the pd_inet_unix_bufmode operand and 1 for the pd_listen_socket_bufset operand, specify conf for this operand.
Relationship to other operands
This operand is related to the following operands:
  • pd_inet_unix_bufmode operand
  • pd_tcp_inet_bufsize operand
  • pd_tcp_unix_bufsize operand
  • pd_ipc_inet_bufsize operand
  • pd_ipc_unix_bufsize operand
  • pd_listen_socket_bufset operand
  • pd_utl_buff_size operand