Nonstop Database, HiRDB Version 9 UAP Development Guide
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-UAP $ PDXARCVWTIME=transaction-recovery-wait-time $ PDXATRCFILEMODE={LUMP|SEPARATE} $ PDXAAUTORECONNECT={YES|NO} $ 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|UTF-8|CHINESE-GB18030} $ PDLANG={UTF-8|SJIS|CHINESE|CHINESE-GB18030|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=client-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 $ PDARYERRPOS={YES|NO} $ 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} $ PDDDLDEAPRPEXE={YES|NO} $ PDDDLDEAPRP={YES|NO} $ PDLCKWAITTIME=lock-release-wait-time $ PDCURSORLVL={0|1|2} $ PDDELRSVWDFILE=SQL-reserved-word-deletion-file-name $ PDHJHASHINGMODE={TYPE1|TYPE2} $ PDCALCMDWAITTIME=maximum-wait-time-for-CAL-COMMAND-statement $ PDSTANDARDSQLSTATE={YES|NO} $ PDBLKF=block-transfer-row-count $ PDBINARYBLKF={YES|NO} $ PDBLKBUFFSIZE=communication-buffer-size $ PDBLKFUPD={YES|NO} $ PDBLKFERRBREAK={YES|NO} $ PDNODELAYACK={YES|NO} $ PDBINDRETRYCOUNT=bind-system-call-retries-count $ PDBINDRETRYINTERVAL=bind-system-call-retry-interval $ PDCLTSIGPIPE={CATCH|IGNORE} $ 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 $ 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 PDXAAUTORECONNECT 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 PDSQLEXECTIME PDRCTRACE PDWRTLNPATH PDWRTLNFILSZ PDWRTLNCOMSZ PDUAPEXERLOGUSE PDUAPEXERLOGPRMSZ PDARYERRPOS PDVWOPTMODE PDTAAPINFPATH PDTAAPINFMODE PDTAAPINFSIZE PDSTJTRNOUT PDLOCKLIMIT PDDLKPRIO PDLOCKSKIP PDFORUPDATEEXLOCK PDISLLVL PDSQLOPTLVL PDADDITIONALOPTLVL PDHASHTBLSIZE PDDFLNVAL PDAGGR PDCMMTBFDDL PDPRPCRCLS PDAUTOCONNECT PDDDLDEAPRPEXE PDDDLDEAPRP PDLCKWAITTIME PDCURSORLVL PDDELRSVWDFILE PDHJHASHINGMODE PDCALCMDWAITTIME PDSTANDARDSQLSTATE PDBLKF PDBINARYBLKF PDBLKBUFFSIZE PDBLKFUPD PDBLKFERRBREAK PDNODELAYACK PDBINDRETRYCOUNT PDBINDRETRYINTERVAL PDCLTSIGPIPE PDDBACCS PDDBORGUAPPDSPACELVL PDCLTRDNODE PDTP1SERVICE PDCNSTRNTNAME PDBESCONHOLD PDBESCONHTI 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-number-of-concurrent-transaction-executions-per-UAP % setenv PDXARCVWTIME transaction-recovery-wait-time % setenv PDXATRCFILEMODE {LUMP|SEPARATE} % setenv PDXAAUTORECONNECT {YES|NO} % 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|UTF-8|CHINESE-GB18030} % setenv PDLANG {UTF-8|SJIS|CHINESE|CHINESE-GB18030|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 client-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 PDARYERRPOS{YES|NO} % 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 PDDDLDEAPRPEXE {ON|OFF} % setenv PDDDLDEAPRP {YES|NO} % setenv PDLCKWAITTIME lock-release-wait-time % setenv PDCURSORLVL {0|1|2} % setenv PDDELRSVWDFILE SQL-reserved-word-deletion-file-name % setenv PDHJHASHINGMODE {TYPE1|TYPE2} % setenv PDCALCMDWAITTIME maximum-wait-time-for-CAL-COMMAND-statement % setenv PDSTANDARDSQLSTATE {YES|NO} % setenv PDBLKF block-transfer-row-count % setenv PDBINARYBLKF {YES|NO} % setenv PDBLKBUFFSIZE communication-buffer-size % setenv PDBLKFUPD {YES|NO} % setenv PDBLKFERRBREAK {YES|NO} % setenv PDNODELAYACK {YES|NO} % setenv PDBINDRETRYCOUNT bind-system-call-retries-count % setenv PDBINDRETRYINTERVAL bind-system-call-retry-interval % setenv PDCLTSIGPIPE {CATCH|IGNORE} % 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 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
If you have selected in a Windows environment to set environment variables during installation, the directory is set in 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|UTF-8|CHINESE-GB18030} PDLANG={UTF-8|SJIS|CHINESE|CHINESE-GB18030|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 PDCLTBINDLOOPBACKADDR={YES|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=client-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 PDARYERRPOS={YES|NO} PDDNDPTRACE=method-trace-file-size 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} PDDDLDEAPRPEXE={YES|NO} PDDDLDEAPRP={YES|NO} PDLCKWAITTIME=lock-release-wait-time PDCURSORLVL={0|1|2} PDDELRSVWDFILE=SQL-reserved-word-deletion-file-name PDHJHASHINGMODE={TYPE1|TYPE2} PDCALCMDWAITTIME=maximum-wait-time-for-CAL-COMMAND-statement PDSTANDARDSQLSTATE={YES|NO} PDBLKF=block-transfer-row-count PDBINARYBLKF={YES|NO} PDBLKBUFFSIZE=communication-buffer-size PDBLKFUPD={YES|NO} PDBLKFERRBREAK={YES|NO} PDNODELAYACK={YES|NO} PDBINDRETRYCOUNT=bind-system-call-retries-count PDBINDRETRYINTERVAL=bind-system-call-retry-interval 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
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.