To execute a UAP, you must specify client environment definitions for each client.
To execute commands and utilities, add the following directory to the PATH environment variable:
/opt/HiRDB/client/utl/
$PDDIR/client/utl/
You must store the environment variables shown below in the .profile file. These environment variables execute automatically at the time of startup.
$ PDHOST=HiRDB-server-host-name[,secondary-system-HiRDB-server-host-name]
$ PDNAMEPORT=HiRDB-server-port-number
$ PDFESHOST=front-end-server-host-name
[:port-number-of-unit-containing-front-end-server]
[,secondary-system-front-end-server-host-name
[:port-number-of-unit-containing-secondary-system-front-end-server]]
$ PDSERVICEGRP=server-name
$ PDSRVTYPE={WS|PC}
$ PDSERVICEPORT=high-speed-connection-port-number
[,secondary-system-high-speed-connection-port-number]
$ PDFESGRP=FES-group[,switchover-FES-group[,switchover-FES-group]...]
$ PDCLTRCVPORT=client-receive-port-number
$ PDCLTRCVADDR={client-IP-address|client-host-name}
$ PDTMID=OLTP-identifier
$ PDXAMODE={0|1}
$ PDTXACANUM=maximum-number-of-concurrent-transaction-executions-per-process
$ PDXARCVWTIME=transaction-recovery-wait-time
$ PDXATRCFILEMODE={LUMP|SEPARATE}
$ HiRDB_PDHOST=HiRDB-server-host-name[,secondary-system-HiRDB-server-host-name]
$ HiRDB_PDNAMEPORT=HiRDB-server-port-number
$ HiRDB_PDTMID=OLTP-identifier
$ HiRDB_PDXAMODE={0|1}
$ PDUSER=[authorization-identifier/password]
$ PDCLTAPNAME=identification-name-of-UAP-to-be-executed
$ PDCLTLANG={SJIS|CHINESE|UJIS|C}
$ PDLANG={UTF-8|SJIS|CHINESE|ANY}
$ PDDBLOG={ALL|NO}
$ PDEXWARN={YES|NO}
$ PDSUBSTRLEN={3|4|5|6}
$ PDCLTCNVMODE={AUTO|NOUSE|UJIS|UJIS2|UTF8|UTF8MS|
UTF8_TXT|UTF8_EX|UTF8_EX2|UTF8MS_TXT|UCS2_UJIS|
UCS2_UTF8}
$ PDCLTGAIJIDLL=user-defined-external-character-conversion-DLL-file-name
$ PDCLTGAIJIFUNC=user-defined-external-character-conversion-function-name
$ PDCLTGRP=client-group-name
$ PDTCPCONOPT={0|1}
$ PDAUTORECONNECT={YES|NO}
$ PDRCCOUNT=CONNECT-retry-count-with-automatic-reconnect-facility
$ PDRCINTERVAL=CONNECT-retry-interval-with-automatic-reconnect-facility
$ PDUAPENVFILE=UAP-environment-definition-file-name
$ PDDBBUFLRU={YES|NO}
$ PDHATRNQUEUING=NO
$ PDASTHOST=HiRDB-Control-Manager-Agent-host-name
[,secondary-system-HiRDB-Control-Manager-Agent-host-name]
$ PDASTPORT=HiRDB-Control-Manager-Agent-port-number
$ PDSYSTEMID=HiRDB-identifier-of-HiRDB-server-managed-by-HiRDB-Control-Manager-Agent
$ PDASTUSER=OS-user-name/password
$ PDCMDWAITTIME=maximum-client-wait-time-during-command-execution
$ PDCMDTRACE=command-trace-file-size
$ PDIPC={MEMORY|DEFAULT}
$ PDSENDMEMSIZE=data-send-memory-size-in-client
$ PDRECVMEMSIZE=data-receive-memory-size-in-client
$ PDCWAITTIME=maximum-client-wait-time
$ PDSWAITTIME=maximum-server-wait-time-during-transaction-processing
$ PDSWATCHTIME=maximum-server-wait-time-outside-transaction-processing
$ PDCWAITTIMEWRNPNT=output-time-for-SQL-runtime-warning
$ PDKALVL={0|1|2}
$ PDKATIME=packet-send-interval
$ PDTIMEDOUTRETRY=retry-count
$ PDNBLOCKWAITTIME=connection-establishment-monitoring-time-in-nonblock-mode
$ PDCONNECTWAITTIME=maximum-wait-time-in-HiRDB-client-during-server-connection
$ PDCLTPATH=trace-file-storage-directory
$ PDSQLTRACE=SQL-trace-file-size
$ PDUAPERLOG=error-log-file-size
$ PDERRSKIPCODE=SQLCODE[,SQLCODE]...
$ PDPRMTRC={YES|NO|IN|OUT|INOUT}
$ PDPRMTRCSIZE= maximum-data-length-of-parameter-information-output-to-SQL-trace
$ PDTRCMODE={ERR|NONE}
$ PDUAPREPLVL={[s][u][p][r]|a}
$ PDREPPATH=storage-directory-for-UAP-statistical-report-files
$ PDTRCPATH=storage-directory-for-dynamic-SQL-trace-files
$ PDSQLTRCOPENMODE={CNCT|SQL}
$ PDSQLTEXTSIZE=SQL-statement-size
$ PDSQLEXECTIME={YES|NO}
$ PDRCTRACE=reconnect-trace-file-size
$ PDWRTLNPATH=storage-directory-for-files-to-which-WRITE-LINE-statement-value-expression-values-are-output
$ PDWRTLNFILSZ=maximum-size-of-output-files-for-WRITE-LINE-statement-value-expression-values
$ PDWRTLNCOMSZ=total-size-of-WRITE-LINE-statement-value-expression-values
$ PDUAPEXERLOGUSE={YES|NO}
$ PDUAPEXERLOGPRMSZ=maximum-data-length-of-parameter-information
$ PDVWOPTMODE={0|1|2}
$ PDTAAPINFPATH=access-path-information-file-output-directory-name
$ PDTAAPINFMODE={0|1}
$ PDTAAPINFSIZE=access-path-information-file-size
$ PDSTJTRNOUT={YES|NO}
$ PDLOCKLIMIT=maximum-locked-resource-request-count-per-user
$ PDDLKPRIO={96|64|32}
$ PDLOCKSKIP={YES|NO}
$ PDFORUPDATEEXLOCK={YES|NO}
$ PDISLLVL=data-guarantee-level
$ PDSQLOPTLVL=SQL-optimization-option[,SQL-optimization-option]...
$ PDADDITIONALOPTLVL=SQL-extension-optimizing-option
[,SQL-extension-optimizing-option]...
$ PDHASHTBLSIZE=hash-table-size-when-hash-join-or-subquery-hash-execution-is-applied
$ PDDFLNVAL={USE|NOUSE}
$ PDAGGR=group-count-resulting-from-grouping
$ PDCMMTBFDDL={YES|NO}
$ PDPRPCRCLS={YES|NO}
$ PDAUTOCONNECT={ON|OFF}
$ PDDDLDEAPRP={YES|NO}
$ PDCURSORLVL={0|1|2}
$ PDDELRSVWDFILE=SQL-reserved-word-deletion-file-name
$ PDHJHASHINGMODE={TYPE1|TYPE2}
$ PDBLKF=block-transfer-row-count
$ PDBINARYBLKF={YES|NO}
$ PDBLKBUFFSIZE=communication-buffer-size
$ PDNODELAYACK={YES|NO}
$ PDDBACCS=generation-number-of-RDAREA-to-be-accessed
$ PDDBORGUAP={YES|NO}
$ PDSPACELVL={0|1|3}
$ PDCLTRDNODE=XDM/RD-E2-database-identifier
$ PDTP1SERVICE={YES|NO}
$ PDCNSTRNTNAME={LEADING|TRAILING}
$ PDBESCONHOLD={YES|NO}
$ PDBESCONHTI=BES-connection-holding-period
$ PDRDABLKF=batch-retrieval-row-count
$ PDODBSTATCAHE={0|1}
$ PDODBESCAPE={0|1}
$ PDGDATAOPT={YES|NO}
$ PDODBLOCATOR={YES|NO}
$ PDODBSPLITSIZE=partition-acquisition-size
$ PDODBCWRNSKIP={YES|NO}
$ PDJETCOMPATIBLE={YES|NO}
$ PDPLGIXMK={YES|NO}
$ PDPLGPFSZ=initial-size-of-delayed-batch-creation-index-information-file
$ PDPLGPFSZEXP=extension-value-of-delayed-batch-creation-index-information-file
$ export PDHOST PDNAMEPORT PDFESHOST PDSERVICEGRP PDSRVTYPE
PDSERVICEPORT PDFESGRP PDCLTRCVPORT PDCLTRCVADDR PDTMID PDXAMODE
PDTXACANUM PDXARCVWTIME PDXATRCFILEMODE PDUSER
PDCLTAPNAME PDCLTLANG PDLANG PDDBLOG PDEXWARN PDSUBSTRLEN
PDCLTCNVMODE PDCLTGAIJIDLL PDCLTGAIJUFUNC PDCLTGRP PDTCPCONOPT
PDAUTORECONNECT PDRCCOUNT PDRCINTERVAL PDUAPENVFILE
PDDBBUFLRU PDHATRNQUEUING PDASTHOST PDASTPORT PDSYSTEMID PDASTUSER
PDCMDWAITTIME PDCMDTRACE PDIPC PDSENDMEMSIZE
PDRECVMEMSIZE PDCWAITTIME PDSWAITTIME PDSWATCHTIME
PDCWAITTIMEWRNPNT PDKALVL PDKATIME PDTIMEDOUTRETRY
PDNBLOCKWAITTIME PDCONNECTWAITTIME PDCLTPATH PDSQLTRACE
PDUAPERLOG PDERRSKIPCODE PDPRMTRC PDPRMTRCSIZE PDTRCMODE
PDUAPREPLVL PDREPPATH PDTRCPATH PDSQLTRCOPENMODE PDSQLTEXTSIZE
PDUAPEXERLOGUSE PSUAPEXERLOGPRMSZ PDVWOPTMODE PDTAAPINFPATH
PDTAAPINFMODE PDTAAPINFSIZE PDSTJTRNOUT PDLOCKLIMIT PDDLKPRIO
PDLOCKSKIP PDFORUPDATEEXLOCK PDISLLVL PDSQLOPTLVL
PDADDITIONALOPTLVL PDHASHTBLSIZE PDDFLNVAL PDAGGR
PDCMMTBFDDL PDPRPCRCLS PDAUTOCONNECT PDDDLDEAPRP PDCURSORLVL
PDDELRSVWDFILE PDHJHASHINGMODE PDBLKF PDBINARYBLKF PDBLKBUFFSIZE
PDNODELAYACK PDDBACCS PDDBORGUAP PDSPACELVL PDCLTRDNODE
PDTP1SERVICE PDCNSTRNTNAME PDBESCONHOLD PDBESCONHTI PDRDABLKF
PDODBSTATCAHE PDODBESCAPE PDGDATAOPT PDODBLOCATOR PDODBSPLITSIZE
PDODBCWRNSKIP PDJETCOMPATIBLE PDPLGIXMK PDPLGPFSZ PDPLGPFSZEXP
You must store the environment variables shown below in the .login or .cshrc file. These environment variables execute automatically at the time of startup.
% setenv PDHOST HiRDB-server-host-name
[,secondary-system-HiRDB-server-host-name]
% setenv PDNAMEPORT HiRDB-server-port-number
% setenv PDFESHOST front-end-server-host-name
[:port-number-of-unit-containing-front-end-server]
[,secondary-system-front-end-server-host-name
[:host-name-of-unit-containing-secondary-system-front-end-server]]
% setenv PDSERVICEGRP server-name
% setenv PDSRVTYPE {WS|PC}
% setenv PDSERVICEPORT high-speed-connection-port-number
[,secondary-system-high-speed-connection-port-number]
% setenv PDFESGRP FES-group[,switchover-FES-group[,switchover-FES-group]...]
% setenv PDCLTRCVPORT client-receive-port-number
% setenv PDCLTRCVADDR {client-IP-address
|client-host-name}
% setenv PDTMID OLTP-identifier
% setenv PDXAMODE {0|1}
% setenv PDTXACANUM maximum-concurrent-transaction-execution-count-per-process
% setenv PDXARCVWTIME transaction-recovery-wait-time
% setenv PDXATRCFILEMODE {LUMP|SEPARATE}
% setenv HiRDB_PDHOST HiRDB-server-host-name
[,secondary-system-HiRDB-server-host-name]
% setenv HiRDB_PDNAMEPORT HiRDB-server-port-number
% setenv HiRDB_PDTMID OLTP-identifier
% setenv HiRDB_PDXAMODE {0|1}
% setenv PDUSER authorization-identifier/password
% setenv PDCLTAPNAME identification-name-of-UAP-to-be-executed
% setenv PDCLTLANG {SJIS|CHINESE|UJIS|C}
% setenv PDLANG {UTF-8|SJIS|CHINESE|ANY}
% setenv PDDBLOG {ALL|NO}
% setenv PDEXWARN {YES|NO}
% setenv PDCLTCNVMODE {AUTO|NOUSE|UJIS|UJIS2|UTF8|UTF8MS|UTF8_TXT|
UTF8_EX|UTF8_EX2|UTF8MS_TXT|UCS2_UJIS|UCS2_UTF8}
% setenv PDCLTGAIJIDLL user-defined-external-character-conversion-DLL-file-name
% setenv PDCLTGAIJIFUNC user-defined-external-character-conversion-function-name
% setenv PDCLTGRP client-group-name
% setenv PDTCPCONOPT {0|1}
% setenv PDAUTORECONNECT {YES|NO}
% setenv PDRCCOUNT CONNECT-retry-count-with-automatic-reconnect-facility
% setenv PDRCINTERVAL CONNECT-retry-interval-with-automatic-reconnect-facility
% setenv PDUAPENVFILE UAP-environment-definition-file-name
% setenv PDDBBUFLRU {YES|NO}
% setenv PDHATRNQUEUING NO
% setenv PDASTHOST HiRDB-Control-Manager-Agent-host-name
[,secondary-system-HiRDB-Control-Manager-Agent-host-name]
% setenv PDASTPORT HiRDB-Control-Manager-Agent-port-number
% setenv PDSYSTEMID HiRDB-identifier-of-HiRDB-server-managed-by-HiRDB-Control-Manager-Agent
% setenv PDASTUSER [OS-user-name/password]
% setenv PDCMDWAITTIME maximum-client-wait-time-during-command-execution
% setenv PDCMDTRACE command-trace-file-size
% setenv PDIPC {MEMORY|DEFAULT}
% setenv PDSENDMEMSIZE data-send-memory-size-in-client
% setenv PDRECVMEMSIZE data-receive-memory-size-in-client
% setenv PDCWAITTIME maximum-client-wait-time
% setenv PDSWAITTIME maximum-server-wait-time-during-transaction-processing
% setenv PDSWATCHTIME maximum-server-wait-time-outside-transaction-processing
% setenv PDCWAITTIMEWRNPNT output-time-for-SQL-runtime-warning
% setenv PDKALVL {0|1|2}
% setenv PDKATIME packet-send-interval
% setenv PDTIMEDOUTRETRY retry-count
% setenv PDNBLOCKWAITTIME connection-establishment-monitoring-time-in-nonblock-mode
% setenv PDCONNECTWAITTIME maximum-wait-time-in-HiRDB-client-during-server-connection
% setenv PDCLTPATH trace-file-storage-directory
% setenv PDSQLTRACE SQL-trace-file-size
% setenv PDUAPERLOG error-log-file-size
% setenv PDERRSKIPCODE SQLCODE[,SQLCODE]...
% setenv PDPRMTRC {YES|NO|IN|OUT|INOUT}
% setenv PDPRMTRCSIZE= maximum-data-length-of-parameter-information-output-to-SQL-trace
% setenv PDTRCMODE {ERR|NONE}
% setenv PDUAPREPLVL {[s][u][p][r]|a}
% setenv PDREPPATH storage-directory-for-UAP-statistical-report-files
% setenv PDTRCPATH storage-directory-for-dynamic-SQL-trace-files
% setenv PDSQLTRCOPENMODE {CNCT|SQL}
% setenv PDSQLTEXTSIZE SQL-statement-size
% setenv PDSQLEXECTIME {YES|NO}
% setenv PDRCTRACE reconnect-trace-file-size
% setenv PDWRTLNPATH storage-directory-for-files-to-which-WRITE-LINE-statement-value-expression-values-are-output
% setenv PDWRTLNFILSZ maximum-size-of-output-files-for-WRITE-LINE-statement-value-expression-values
% setenv PDWRTLNCOMSZ total-size-of-WRITE-LINE-statement-value-expression-values
% setenv PDUAPEXERLOGUSE {YES|NO}
% setenv PDUAPEXERLOGPRMSZ maximum-data-length-of-parameter-information
% setenv PDVWOPTMODE {0|1|2}
% setenv PDTAAPINFPATH access-path-information-file-output-directory-name
% setenv PDTAAPINFMODE {0|1}
% setenv PDTAAPINFSIZE access-path-information-file-size
% setenv PDSTJTRNOUT {YES|NO}
% setenv PDLOCKLIMIT maximum-locked-resource-request-count-per-user
% setenv PDDLKPRIO {96|64|32}
% setenv PDLOCKSKIP {YES|NO}
% setenv PDFORUPDATEEXLOCK {YES|NO}
% setenv PDISLLVL data-guarantee-level
% setenv PDSQLOPTLVL SQL-optimization-option[,SQL-optimization-option]...
% setenv PDADDITIONALOPTLVL SQL-extension-optimizing-option
[,SQL-extension-optimizing-option]...
% setenv PDHASHTBLSIZE hash-table-size-when-hash-join-or-subquery-hash-execution-is-applied
% setenv PDDFLNVAL {USE|NOUSE}
% setenv PDAGGR group-count-resulting-from-grouping
% setenv PDCMMTBFDDL {YES|NO}
% setenv PDPRPCRCLS {YES|NO}
% setenv PDAUTOCONNECT {ON|OFF}
% setenv PDDDLDEAPRP {YES|NO}
% setenv PDCURSORLVL {0|1|2}
% setenv PDDELRSVWDFILE SQL-reserved-word-deletion-file-name
% setenv PDHJHASHINGMODE {TYPE1|TYPE2}
% setenv PDBLKF block-transfer-row-count
% setenv PDBINARYBLKF {YES|NO}
% setenv PDBLKBUFFSIZE communication-buffer-size
% setenv PDNODELAYACK {YES|NO}
% setenv PDDBACCS generation-number-of-RDAREA-to-be-accessed
% setenv PDDBORGUAP {YES|NO}
% setenv PDSPACELVL {0|1|3}
% setenv PDCLTRDNODE XDM/RD-E2-database-identifier
% setenv PDTP1SERVICE {YES|NO}
% setenv PDCNSTRNTNAME {LEADING|TRAILING}
% setenv PDBESCONHOLD {YES|NO}
% setenv PDBESCONHTI BES-connection-holding-period
% setenv PDRDABLKF batch-retrieval-row-count
% setenv PDODBSTATCAHE {0|1}
% setenv PDODBESCAPE {0|1}
% setenv PDGDATAOPT {YES|NO}
% setenv PDODBLOCATOR {YES|NO}
% setenv PDODBSPLITSIZE partition-acquisition-size
% setenv PDODBCWRNSKIP {YES|NO}
% setenv PDJETCOMPATIBLE {YES|NO}
% setenv PDPLGIXMK {YES|NO}
% setenv PDPLGPFSZ initial-size-of-delayed-batch-creation-index-information-file
% setenv PDPLGPFSZEXP extension-value-of-delayed-batch-creation-index-information-file
In the Windows environment, the directory is set automatically to the PATH environment variable. However, the directory may not be set automatically if the path name is too long or if you do not have write privileges for PATH. You should therefore check whether the directory has been set to PATH. If the directory has not been set, you must add the following directory to PATH. xxxx indicates the directory name in which the HiRDB client is installed.
xxxx\UTL
Set the environment variables as system environment variables or user environment variables, or store them in the HiRDB.INI file in the Windows directory. If you are using a function in the UAP to set the environment variables, use the SetEnvironmentVariable function. Do not use the putenv function.
A specification example of the HiRDB.INI file is shown below.
[HIRDB]
PDHOST=HiRDB-server-host-name[,secondary-system-HiRDB-server-host-name]
PDNAMEPORT=HiRDB-server-port-number
PDFESHOST=front-end-server-host-name
[:port-number-of-unit-containing-front-end-server]
[,secondary-system-front-end-server-host-name
[:port-number-of-unit-containing-secondary-system-front-end-server]]
PDSERVICEGRP=server-name
PDSRVTYPE={WS|PC}
PDSERVICEPORT=high-speed-connection-port-number
[,secondary-system-high-speed-connection-port-number]
PDFESGRP=FES-group[,switchover-FES-group[,switchover-FES-group]...]
PDCLTRCVPORT=client-receive-port-number
PDCLTRCVADDR={client-IP-address|client-host-name}
PDXATRCFILEMODE={LUMP|SEPARATE}
PDUSER=[authorization-identifier/password]
PDCLTAPNAME=identification-name-of-UAP-to-be-executed
PDCLTLANG={SJIS|CHINESE|UJIS|C}
PDLANG={UTF-8|SJIS|CHINESE|ANY}
PDDBLOG={ALL|NO}
PDEXWARN={YES|NO}
PDSUBSTRLEN={3|4|5|6}
PDCLTCNVMODE={AUTO|NOUSE|UJIS|UJIS2|UTF8|UTF8MS|
UTF8_TXT|UTF8_EX|UTF8_EX2|UTF8MS_TXT|UCS2_UJIS|
UCS2_UTF8}
PDCLTGAIJIDLL=user-defined-external-character-conversion-DLL-file-name
PDCLTGAIJIFUNC=user-defined-external-character-conversion-function-name
PDCLTGRP=client-group-name
PDTCPCONOPT={0|1}
PDAUTORECONNECT={YES|NO}
PDRCCOUNT=CONNECT-retry-count-with-automatic-reconnect-facility
PDRCINTERVAL=CONNECT-retry-interval-with-automatic-reconnect-facility
PDUAPENVFILE=UAP-environment-definition-file-name
PDDBBUFLRU={YES|NO}
PDHATRNQUEUING=NO
PDASTHOST=HiRDB-Control-Manager-Agent-host-name
[,secondary-system-HiRDB-Control-Manager-Agent-host-name]
PDASTPORT=HiRDB-Control-Manager-Agent-port-number
PDSYSTEMID=HiRDB-identifier-of-HiRDB-server-managed-by-HiRDB-Control Manager-Agent
PDASTUSER=OS-user-name/password
PDCMDWAITTIME=maximum-client-wait-time-during-command-execution
PDCMDTRACE=command-trace-file-size
PDIPC={MEMORY|DEFAULT}
PDSENDMEMSIZE=data-send-memory-size-in-client
PDRECVMEMSIZE=data-receive-memory-size-in-client
PDCWAITTIME=maximum-client-wait-time
PDSWAITTIME=maximum-server-wait-time-during-transaction-processing
PDSWATCHTIME=maximum-server-wait-time-outside-transaction-processing
PDCWAITTIMEWRNPNT=output-timing-for-SQL-runtime-warning
PDKALVL={0|1|2}
PDKATIME=packet-send-interval
PDTIMEDOUTRETRY=retry-count
PDNBLOCKWAITTIME=connection-establishment-monitoring-time-in-nonblock-mode
PDCONNECTWAITTIME=maximum-wait-time-in-HiRDB-client-during-server-connection
PDCLTPATH=trace-file-storage-directory
PDSQLTRACE=SQL-trace-file-size
PDUAPERLOG=error-log-file-size
PDERRSKIPCODE=SQLCODE[,SQLCODE]...
PDPRMTRC={YES|NO|IN|OUT|INOUT}
PDPRMTRCSIZE= maximum-data-length-of-parameter-information-output-to-SQL-trace
PDTRCMODE={ERR|NONE}
PDUAPREPLVL={[s][u][p][r]|a}
PDREPPATH=storage-directory-for-UAP-statistical-report-files
PDTRCPATH=storage-directory-for-dynamic-SQL-trace-files
PDSQLTRCOPENMODE={CNCT|SQL}
PDSQLTEXTSIZE=SQL-statement-size
PDSQLEXECTIME={YES|NO}
PDRCTRACE=reconnect-trace-file-size
PDWRTLNPATH=storage-directory-for-files-to-which-WRITE-LINE-statement-value-expression-values-are-output
PDWRTLNFILSZ=maximum-size-of-output-files-for-WRITE-LINE-statement-value-expression-values
PDWRTLNCOMSZ=total-size-of-WRITE-LINE-statement-value-expression-values
PDUAPEXERLOGUSE={YES|NO}
PDUAPEXERLOGPRMSZ=maximum-data-length-of-parameter-information
PDVWOPTMODE={0|1|2}
PDTAAPINFPATH=access-path-information-file-output-directory-name
PDTAAPINFMODE={0|1}
PDTAAPINFSIZE=access-path-information-file-size
PDSTJTRNOUT={YES|NO}
PDLOCKLIMIT=maximum-locked-resource-request-count-per-user
PDDLKPRIO={96|64|32}
PDFORUPDATEEXLOCK={YES|NO}
PDLOCKSKIP={YES|NO}
PDISLLVL=data-guarantee-level
PDSQLOPTLVL=SQL-optimization-option[,SQL-optimization-option]...
PDADDITIONALOPTLVL=SQL-extension-optimizing-option
[,SQL-extension-optimizing-option]...
PDHASHTBLSIZE=hash-table-size-when-hash-join-or-subquery-hash-execution-is-applied
PDDFLNVAL={USE|NOUSE}
PDAGGR=group-count-resulting-from-grouping
PDCMMTBFDDL={YES|NO}
PDPRPCRCLS={YES|NO}
PDAUTOCONNECT={ON|OFF}
PDDDLDEAPRP={YES|NO}
PDCURSORLVL={0|1|2}
PDDELRSVWDFILE=SQL-reserved-word-deletion-file-name
PDHJHASHINGMODE={TYPE1|TYPE2}
PDBLKF=block-transfer-row-count
PDBINARYBLKF={YES|NO}
PDBLKBUFFSIZE=communication-buffer-size
PDNODELAYACK={YES|NO}
PDDBACCS=generation-number-of-RDAREA-to-be-accessed
PDDBORGUAP={YES|NO}
PDSPACELVL={0|1|3}
PDCLTRDNODE=XDM/RD-E2-database-identifier
PDTP1SERVICE={YES|NO}
PDRDCLTCODE={SJIS|UTF-8}
PDCNSTRNTNAME={LEADING|TRAILING}
PDBESCONHOLD={YES|NO}
PDBESCONHTI=BES-connection-holding-period
PDODBSTATCAHE={0|1}
PDODBESCAPE={0|1}
PDGDATAOPT={YES|NO}
PDODBLOCATOR={YES|NO}
PDODBSPLITSIZE=partition-acquisition-size
PDODBCWRNSKIP={YES|NO}
PDJETCOMPATIBLE={YES|NO}
PDPLGIXMK={YES|NO}
PDPLGPFSZ=initial-size-of-delayed-batch-creation-index-information-file
PDPLGPFSZEXP=extension-value-of-delayed-batch-creation-index-information-file