10.1 Operand formats

The foreign server information definition defines the execution environment for the HiRDB External Data Access facility. Note that the numbers in the following table correspond to the numbers assigned to the operands explained in 10.2 Operand explanations.

[Figure]To users who are creating a foreign server information definition for the first time
First, determine the values to be specified for the operands shown in bold. Basically, once you specify these operands, you can use the HiRDB External Data Access facility.
[Figure]Operands you can modify before restarting HiRDB
You can modify all operands in the foreign server information definition before restarting HiRDB (following planned termination, forced termination, or abnormal termination).
No.FormatOperand category
1[set pd_hb_db_con = STARTUP | ACCESS]Connection to and disconnection from a foreign server
2[set pd_hb_db_dis_con = SHUTDOWN | COMMIT]
3[set pd_hb_e_mode = ALL | NONE]Foreign server error information
4[set pd_hb_e_code = SQLCODE[,SQLCODE]...]
5[set pd_hb_e_size = foreign-server-error-information-file-size]
6[set pd_hb_l_path = foreign-server-interface-trace-information-file-output-destination-directory]Foreign server interface trace information
7[set pd_hb_l_size = foreign-server-interface-trace-information-file-size]
8[set pd_hb_l_prm = Y | N]
9[set pd_hb_l_prm_size = maximum-data-size-of-?-parameter-information-to-be-output-to foreign-server-interface-trace-information-file]
10[set pd_hb_l_mode = ALL | PARTIAL]
11[set pd_hb_ary_fec_num = number of rows-to-be-fetched-at-once-with-FETCH-facility-that-uses-array]FETCH
12[putenv PDCURSORLVL 0 | 1 | 2 ]
13putenv PDHOST foreign-HiRDB-host-name[,foreign-HiRDB-secondary-system-host-name]Connection to a foreign server
14[putenv PDFESHOST foreign-HiRDB-front-end-server-host-name[:foreign-HiRDB-front-end-server-port-number][,foreign-HiRDB-secondary-system-front-end-server-host-name[:foreign-HiRDB-secondary-system-front-end-server-host-name]]]
15putenv PDNAMEPORT foreign-HiRDB-port-number
16[putenv PDSERVICEPORT foreign-HiRDB-high-speed-connection-port-number[,foreign-HiRDB-secondary-system-high-speed-connection-port-number]]
17[putenv PDSERVICEGRP foreign-HiRDB-server-name]
18[putenv PDSRVTYPE WS | PC]
19[putenv PDCLTRCVPORT receive-port-range-to-be-reserved]
20[putenv PDCLTRCVADDR back-end-server-IP-address-or-host-name-for-connecting-to-foreign-server]
21[putenv PDAUTORECONNECT YES | NO]
22[putenv PDRCCOUNT maximum-number-of-CONNECT-retries-using-automatic-reconnect-facility]
23[putenv PDRCINTERVAL CONNECT-retry-interval-for-using-automatic-reconnect-facility]
24[putenv PDDBLOG ALL | NO]Database update log
25[putenv PDCLTGRP client-group-name]Client group
26[putenv PDIPC MEMORY | DEFAULT]Communication processing
27[putenv PDSENDMEMSIZE memory-size-for-sending-data]
28[putenv PDRECVMEMSIZE memory-size-for-receiving-data]
29[putenv PDTCPCONOPT 0 | 1]
30[putenv PDKALVL 0 | 1 | 2]
31[putenv PDKATIME interval-for-sending-packets-to-foreign-HiRDB]
32[putenv PDNODELAYACK YES | NO]
33[putenv PDCWAITTIME [maximum-wait-time-1-for-HiRDB-client-used-by-HiRDB-External-Data-Access-Adapter][,maximum-wait-time-2-for-HiRDB-client-used-by-HiRDB-External-Data-Access-Adapter]]System monitoring
34[putenv PDSWAITTIME [maximum-wait-time-1-for-foreign-HiRDB][,maximum-wait-time-2-for-foreign-HiRDB]]
35[putenv PDCLTPATH SQL-trace-file-and-error-log-file-output-destination-directory]Troubleshooting information
36[putenv PDSQLTRACE SQL-trace-file-size]
37[putenv PDSQLTEXTSIZE size-of-SQL-statements-to-be-output-to-SQL-trace-file]
38[putenv PDSQLEXECTIME YES | NO]
39[putenv PDUAPERLOG error-log-file-size]
40[putenv PDPRMTRC YES | NO]
41[putenv PDPRMTRCSIZE maximum-data-size-of-?-parameter-information-inside-SQL-trace]
42[putenv PDTRCMODE ERR | NONE]
43[putenv PDTRCPATH dynamic-SQL-trace-file-output-destination-directory]
44[putenv PDUAPREPLVL [s][u][p][r] | a]
45[putenv PDREPPATH UAP-statistical-report-output-destination-directory]
46[putenv PDSQLTRCOPENMODE CNCT | SQL]
47[putenv PDVWOPTMODE access-path-information-acquisition-mode]
48[putenv PDLOCKLIMIT upper-limit-for-lock-requests-to-foreign-HiRDB]Lock
49[putenv PDDBACCS RDAREA-generation-number-of-foreign-HiRDB]Inner replica facility
50[putenv PDDBORGUAP YES | NO]
51[putenv PDSQLOPTLVL SQL-optimization-option-for-foreign-HiRDB[,SQL-optimization-option-for-foreign-HiRDB]...]SQL optimization
52[putenv PDADDITIONALOPTLVL SQL-extension-optimization-option-for-foreign-HiRDB[,SQL-extension-optimization-option-for-foreign-HiRDB]...]
53[putenv PDAGGR number-of-groups-generated-for-foreign-HiRDB-grouping]
54[putenv PDHASHTBLSIZE hash-table-size-for-hash-join-subquery-hash-execution-by-foreign-HiRDB]
55[putenv PDUAPEXERLOGUSE YES | NO]Facility for output of extended SQL error information
56[putenv PDUAPEXERLOGPRMSZ maximum-data-size-of-parameter-information-to-be-output-to-error-log-file-and-SQL-error-report-file]
57[putenv PDBESCONHOLD YES | NO]BES connection holding facility
58[putenv PDBESCONHTI back-end-server-connection-hold-time]
59[putenv PDHATRNQUEUING NO]System switchover facility