6.6.1 Environment setup format

To execute a UAP, you must specify client environment definitions for each client.

Organization of this subsection
(1) UNIX environment
(2) Windows environment

(1) UNIX environment

To execute commands and utilities, add the following directory to the PATH environment variable:

(a) sh (Bourne shell)

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

(b) csh (C shell)

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

Notes on the UNIX environment
  • The environment variables are required for preprocessing. For details about preprocessing, see 8.2 Preprocessing.
  • If different directories are used for storing shared libraries for the client during UAP creation and UAP execution, specify the -W1,+s option in the cc or ccbl command. During UAP execution, specify the name of the directory containing the shared libraries in the SHLIB_PATH environment variable. For details about the cc and ccbl commands, see 8.3 Compiling and linking.
  • When you use the Type4 JDBC driver, client environment definitions set using this method are not valid.
  • Client environment definitions that begin with PDJDB are not valid when they are set using this method.

(2) Windows environment

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

Notes on the Windows environment
  • The environment variables are required for preprocessing. For details about how to preprocess, see 8.2 Preprocessing.
  • When you use the Type4 JDBC driver, client environment definitions set using this method are not valid.
  • Client environment definitions that begin with PDJDB are not valid when they are set using this method.