10.2 Operand formats

The tables below explain the formats of operands that must be examined if you want to apply compatibility mode. Note that the numbers in the No. column in these tables correspond to numbers affixed to operands explained in 10.3 Operand explanations.

Organization of this section
(1) Maximum concurrent executions
(2) HiRDB processing
(3) Transaction decision processing
(4) SQL specifications
(5) SQL optimization
(6) Temporary tables
(7) Communication processing
(8) Date and time
(9) Unit status files (when an error occurs)
(10) Server status files (when an error occurs)
(11) System log files

(1) Maximum concurrent executions

No.Format
1[set pd_utl_exec_mode = 0 | 1]

(2) HiRDB processing

No.Format
2[set pd_dbsync_altwrite_skip = Y | N]

(3) Transaction decision processing

No.Format
3[set pd_trn_rollback_msg_interval = interval-at-which-a-message-indicating-that-rollback-is-underway-is-output]

(4) SQL specifications

No.Format
4[set pd_sql_simple_comment_use = Y | N]

(5) SQL optimization

No.Format
5[set pd_hashjoin_hashing_mode = TYPE1 | TYPE2]
6[set pd_apply_search_ats_num = maximum-number-of-combinations-of-narrowing-values-applied-to-ATS-search-condition]

(6) Temporary tables

No.Format
7[set pd_max_tmp_table_rdarea_no = maximum-number-of-temporary-table-RDAREAs]

(7) Communication processing

No.Format
8[set pd_registered_port_level = 0 | 1]
9[set pd_inet_unix_bufmode = os | conf]
10[set pd_ipc_inet_bufsize = send-receive-buffer-size-for-server-unit-to-server-unit-communication]
11[set pd_ipc_unix_bufsize = send-receive-buffer-size-for-communication-within-server-unit]
12[set pd_tcp_inet_bufsize = send-receive-buffer-size-for-communication-with-HiRDB-client-outside-host-where-HiRDB-server-resides]
13[set pd_tcp_unix_bufsize = send-receive-buffer-size-for-communication-with-HiRDB-client-inside-host-where-HiRDB-server-resides]
14[set pd_listen_socket_bufset = 0 | 1]
15[set pd_utl_buff_size = utility-communication-buffer-size]
16[set pd_inet_unix_utl_bufmode = auto | conf]

(8) Date and time

No.Format
17[set pd_leap_second = Y | N]

(9) Unit status files (when an error occurs)

No.Format
18[set pd_syssts_initial_error = stop | continue | excontinue]
19[set pd_syssts_singleoperation = stop | continue]

(10) Server status files (when an error occurs)

No.Format
20[set pd_sts_initial_error = stop | continue | excontinue]
21[set pd_sts_singleoperation = stop | continue]

(11) System log files

No.Format
22[set pd_log_max_data_size = log-input/output-buffer-size]
23[set pd_log_rec_leng = system-log-file-record-length]
24[set pd_log_rollback_buff_count = rollback-log-input-buffer-sector-count]