Table 6-25 lists the client environment definitions. The numbers in the list correspond to the individual environment definition numbers used in 6.6.4 Environment definition information.

• Environment variables that must be specified
  The environment variables displayed in bold characters must be specified regardless of which HiRDB system environment is used. Specify all other environment variables according to the HiRDB system environment being used.
  

  Table 6-25 Client environment definitions

  No.	Environment variable	Function	Category
  1	PDHOST	Specifies the host name of the HiRDB system to be connected.	System configuration3
  2	PDNAMEPORT	Specifies the port number of the HiRDB system.
  3	PDFESHOST	Specifies the host name of the front-end server.
  4	PDSERVICEGRP	Specifies the server name of the single server or front-end server.
  5	PDSRVTYPE	Specifies the HiRDB server type.
  6	PDSERVICEPORT	Specifies the port number for high-speed connection.
  7	PDFESGRP	Specifies the FES group to which connection is to be established when a high-speed connection is used.
  8	PDCLTRCVPORT	Specifies the receive port number of the client.
  9	PDCLTRCVADDR	Specifies the IP address or host name of the client.
  10	PDTMID	Specifies a unique identifier for each OLTP when multiple OLTPs access one HiRDB server.	Clients that use an X/Open-compliant API in an OLTP environment1
  11	PDXAMODE	Specifies whether the transaction transfer function is to be used when the HiRDB client is linked with an OLTP system.
  12	PDTXACANUM	Specifies the maximum number of transactions to be executed simultaneously from a UAP that uses an X/Open-compliant API.
  13	PDXARCVWTIME	Specifies the wait time if a transaction cannot be recovered.
  14	PDXATRCFILEMODE	Specifies the format of each trace file name in the connection mode that uses the X/Open-compliant API.
  15	HiRDB_PDHOST	Specifies the host name of the HiRDB server to be connected.
  16	HiRDB_PDNAMEPORT	Specifies the port number of the HiRDB server.
  17	HiRDB_PDTMID	Specifies a unique identifier for each OLTP when multiple OLTPs access one HiRDB server.
  18	HiRDB_PDXAMODE	Specifies whether the transaction transfer function is to be used when the HiRDB client is linked with an OLTP system.
  19	PDUSER	Specifies the authorization identifier and password. This environment variable can be omitted in the UNIX environment.	User execution environment
  20	PDCLTAPNAME	Specifies UAP identification information (UAP identifier) for accessing the HiRDB server.
  21	PDCLTLANG	Specifies the character code classification used in the descriptions of UAPs to be processed by the preprocessor.
  22	PDLANG	Specifies that the character code used when the UAP is executed is either Unicode or EUC Chinese kanji code. In the Linux version, specifies that SJIS is used as the character code. This environment variable is not valid in a Windows environment.
  23	PDDBLOG	Specifies whether the database update log is to be collected when a UAP is executed.
  24	PDEXWARN	Specifies whether return codes with warnings are to be accepted from the server.
  25	PDSUBSTRLEN	Specifies the maximum number of bytes used to represent one character.
  26	PDCLTCNVMODE	Specifies whether character codes are to be converted if the HiRDB server and the HiRDB client use different character code classifications.
  27	PDCLTGAIJIDLL	Specifies the name of the user-defined external character conversion DLL file.
  28	PDCLTGAIJIFUNC	Specifies the name of the user-defined external character conversion function.
  29	PDCLTGRP	Specifies a client group name when the connection frame guarantee facility for client groups is used.
  30	PDTCPCONOPT	Specifies that the number of TCP ports used in server connection processing is to be reduced when the client connects to a HiRDB server with a version of 06-02 or later.
  31	PDAUTORECONNECT	Specifies whether the automatic reconnect facility is to be used.
  32	PDRCCOUNT	Specifies the number of times the CONNECT statement is to be retried by the automatic reconnect facility.
  33	PDRCINTERVAL	Specifies the retry interval for CONNECT statement execution by the automatic reconnect facility.
  34	PDUAPENVFILE	Specifies the UAP environment definition file that defines the execution environment if the UAP is to be executed in a separate environment.
  35	PDDBBUFLRU	Specifies whether the LRU method is used for caching in global buffer pages accessed by the UAP.
  36	PDHATRNQUEUING	Specifies that the client is not using the transaction queuing facility.
  37	PDASTHOST	Specifies the host name of HiRDB Control Manager - Agent to be connected when the UAP is executed.	Command execution from a UAP
  38	PDASTPORT	Specifies the port number of Control Manager - Agent to be connected when the UAP is executed.
  39	PDSYSTEMID	Specifies the HiRDB identifier of the HiRDB server managed by HiRDB Control Manager - Agent to be connected when the UAP is executed.
  40	PDASTUSER	Specifies the user name and password for the OS that will run commands.
  41	PDCMDWAITTIME	Specifies the maximum time the client is to wait from the time it sends a request to HiRDB Control Manager - Agent until a response is returned.
  42	PDCMDTRACE	Specifies the size of the command trace file when a file is output during UAP execution.
  43	PDIPC	Specifies the communication method between processes.	Inter-process memory communication facility
  44	PDSENDMEMSIZE	Specifies the data storage area size when the client sends data to the server while the inter-process memory communication facility is used.
  45	PDRECVMEMSIZE	Specifies the data storage area size when the client receives data from the server while the inter-process memory communication facility is used.
  46	PDCWAITTIME	Specifies the maximum time that the HiRDB client waits for a response to be returned after issuing a request to the HiRDB server.	System monitoring
  47	PDSWAITTIME	Specifies the maximum time that the HiRDB server waits for the next request from the HiRDB client to arrive after returning a response to the previous request from the HiRDB client. This function monitors the time during transaction processing.
  48	PDSWATCHTIME	Specifies the maximum time that the HiRDB server waits for the next request from the HiRDB client to arrive after returning a response to the previous request from the HiRDB client. This function monitors the time outside transaction processing.
  49	PDCWAITTIMEWRNPNT	Specifies the output timing of the SQL runtime warning information file when the SQL runtime running output facility is used. The output timing is specified as a percentage of the maximum wait time of the HiRDB client or as a time.
  50	PDKALVL	Specifies whether the facility that sends packets regularly from the HiRDB client to the HiRDB server is to be used.
  51	PDKATIME	Specifies the interval for sending packets regularly from the HiRDB client to the HiRDB server.
  52	PDTIMEDOUTRETRY	Specifies the number of times the connect() system call is to be retried if an error occurs in the connect() system call executed when the HiRDB client connects with the HiRDB server.
  53	PDNBLOCKWAITTIME	Specifies the connection establishment monitoring time in nonblock mode when completion of the connection between the HiRDB server and client is monitored.
  54	PDCONNECTWAITTIME	Specifies the maximum wait time that the HiRDB client waits from a response from the HiRDB server during connection with the HiRDB server.
  55	PDCLTPATH	Specifies the storage directory for the SQL trace file and error log file created by the HiRDB client.	Trouble-shooting
  56	PDSQLTRACE	Specifies the size of the SQL trace file (in byte units) into which the SQL trace of the UAP is to be output.
  57	PDUAPERLOG	Specifies the size of the error log file (in byte units) into which the error log of the UAP is to be output.
  58	PDERRSKIPCODE	Specifies that a specific error log is not to be output.
  59	PDPRMTRC	Specifies whether parameter information and retrieval data is to be output to the SQL trace information.
  60	PDPRMTRCSIZE	Specifies the maximum length of the parameter information and retrieval data to be output to the SQL trace information.
  61	PDTRCMODE	Specifies whether troubleshooting information other than SQL trace information is to be output.
  62	PDUAPREPLVL	Specifies output information for UAP statistical reports.
  63	PDREPPATH	Specifies the output directory for UAP statistical reports when these files are to be created in a directory different from the one specified by PDCLTPATH.
  64	PDTRCPATH	Specifies the storage directory for dynamic SQL trace files.
  65	PDSQLTRCOPENMODE	Specifies the open mode for the SQL trace file when PDREPPATH is specified.
  66	PDSQLTEXTSIZE	Specifies the size of the SQL statement to be output to the SQL trace information.
  67	PDSQLEXECTIME	Specifies whether the SQL runtime is to be output to the SQL trace information.
  68	PDRCTRACE	Specifies the size of the file that outputs the UAP reconnect trace.
  69	PDWRTLNPATH	Specifies the storage directory for files to which value expression values of WRITE LINE statements are to be output.
  70	PDWRTLNFILSZ	Specifies the maximum size of the files to which value expression values of WRITE LINE statements are to be output.
  71	PDWRTLNCOMSZ	Specifies the total size of the value expression values in WRITE LINE statements.
  72	PDUAPEXERLOGUSE	Specifies whether the facility for output of extended SQL error information is to be used.
  73	PDUAPEXERLOGPRMSZ	Specifies the maximum data length in the parameter information to be output to the error log file and the SQL error report when the facility for output of extended SQL error information is used.
  74	PDVWOPTMODE	Specifies whether or not the access path information file is to be obtained.	Access path display utility
  75	PDTAAPINFPATH	Specifies the output destination directory when the access path information file is output to the HiRDB client side. The file is not output without this specification.	Access path information file for HiRDB SQL Tuning Advisor
  76	PDTAAPINFMODE	Specifies the file name format of the access path information file when it is output to the HiRDB client side.
  77	PDTAAPINFSIZE	Specifies the file size of the access path information file when it is output to the HiRDB client side.
  78	PDSTJTRNOUT	Specifies whether UAP statistical information is to be output to the client side.	Output unit of UAP statistical information
  79	PDLOCKLIMIT	Specifies the maximum number of lock requests that a UAP can issue to one server.	Lock control
  80	PDDLKPLIO	Specifies the deadlock priority value of a UAP.
  81	PDLOCKSKIP	Specifies whether search using condition evaluation with no lock is to be performed.
  82	PDFORUPDATEEXLOCK	Specifies whether WITH EXCLUSIVE LOCK is to be applied to the lock option of the SQL statement in which the FOR UPDATE clause was specified (or assumed).
  83	PDISLLVL	Specifies the data guarantee level for SQL statements.	SQL-related
  84	PDSQLOPTLVL	Specifies the optimization method (SQL optimization option) for determining the most efficient access path in consideration of the database status.
  85	PDADDITIONALOPTLVL	Specifies the optimization method (SQL extension optimizing option) for determining the most efficient access path in consideration of the database status.
  86	PDHASHTBLSIZE	Specifies the hash table size to be used when hash join or subquery hash execution is applied in SQL optimization.
  87	PDDFLNVAL	When table data is to be fetched into an embedded variable, specifies whether a default value is to be set into the embedded variable if the fetched value is a null value.
  88	PDAGGR	Specifies the maximum number of groups allowed in each server so that the memory size used in GROUP BY processing can be determined.
  89	PDCMMTBFDDL	Specifies whether a transaction that has that executed a data manipulation SQL statement must execute commit processing automatically before it executes a definition SQL statement.
  90	PDPRPCRCLS	Specifies whether an open cursor is to be closed automatically if the SQL identifier being used by the open cursor is used again by the PREPARE statement.
  91	PDAUTOCONNECT	Specifies whether autoconnection is to be executed if an SQL statement is executed while the client is not connected to HiRDB.
  92	PDDDLDEAPRP	Specifies whether the definition information of a table being used by a closed holdable cursor can be changed by another UAP between transactions.
  93	PDCURSORLVL	Specifies whether an open/close cursor request is to be sent automatically to the HiRDB server when a search is performed using the cursor.
  94	PDDELRSVWDFILE	Specifies the name of the SQL reserved word deletion file when the SQL reserved word deletion file is used.
  95	PDHJHASHINGMODE	Specifies the hashing method when Apply hash join, subquery hash execution is selected as the SQL extension optimizing option.
  96	PDBLKF	Specifies the number of rows to be sent by a single transfer process when the HiRDB server transfers search results to the HiRDB client.	Block transfer facility
  97	PDBINARYBLKF	Specifies whether the block transfer facility is to be applied when a table having a selection expression for BINARY-type data with a defined length of 32,001 bytes or more is searched.
  98	PDBLKBUFFSIZE	Specifies the size of the server-client communication buffer used by the block transfer facility.
  99	PDNODELAYACK	Specifies whether immediate acknowledgement is to be used. This environment variable is limited to the AIX 5L version.	Use of immediate acknowledgment for HiRDB communication
  100	PDDBACCS	Specifies the generation number of an RDAREA if an RDAREA that is not the current RDAREA is to be accessed while the inner replica facility is being used.	Inner replica facility
  101	PDDBORGUAP	Specifies that the UAP is to be executed for the original RDAREA for online reorganization hold.	Updatable online reorganization
  102	PDSPACELVL	Specifies the space conversion level for data storage, comparison, and retrieval.	Space conversion for data
  103	PDCLTRDNODE	Specifies the identifier of the XDM/RD E2 database to be connected when the XDM/RD E2 connection facility is used.	XDM/RD E2 connection facility
  104	PDTP1SERVICE	Specifies whether OpenTP1 service names are to be reported to XDM/RD E2 when the XDM/RD E2 connection facility is used.
  105	PDRDCLTCODE	Specifies the character code classification that the client uses when the XDM/RD E2 connection facility is used.
  106	PDCNSTRNTNAME	Specifies the position of the constraint name definition when a referential or check constraint is defined.	Referential or check constraint
  107	PDBESCONHOLD	Specifies whether the BES connection holding facility is to be used.	BES connection holding facility
  108	PDBESCONHTI	Specifies the BES connection holding period when the BES connection holding facility is used.
  109	PDRDABLKF	Specifies the number of rows to be sent in one transfer when retrieval results are transferred from a distributed server to a distributed client.	Distributed database
  110	PDODBSTATCACHE	Specifies whether column information or index information that is collected the first time an ODBC function (SQLColumns() or SQLStatistics()) is issued is to be cached.	ODBC functions
  111	PDODBESCAPE	Specifies whether the "&" ESCAPE character is to be specified for the pattern character string in a retrieval that uses a cataloging ODBC function.
  112	PDGDATAOPT	Specifies that the SQLGetData function of ODBC is to fetch data from columns, even if the data has already been fetched from those columns.
  113	PDODBLOCATOR	Specifies whether the locator facility is to be used to partition and retrieve data when a database access tool is used to retrieve BLOB-type or BINARY-type column data. The database access tools are the ODBC driver, the OLE DB provider, and the HiRDB.Net data provider.
  114	PDODBSPLITSIZE	Specifies the partition acquisition size when PDODBLOCATOR=YES is specified.
  115	PDODBCWRNSKIP	Specifies whether warnings are to be skipped when an ODBC connection is used.
  116	PDJETCOMPATIBLE	Specifies whether the ODBC 3.0 driver is to be operated in a Microsoft Jet database engine compatible mode not based on the ODBC 3.0 specification.
  117	PDPLGIXMK	Specifies whether delayed batch creation of plug-in indexes is to be used.	Plug-ins
  118	PDPLUGINNSUB2	For details, see the manual for the target plug-in.
  119	PDPLGPFSZ	Specifies the initial size of the index information file for delayed batch creation of plug-ins.
  120	PDPLGPFSZEXP	Specifies the extension size of the index information file for delayed batch creation of plug-ins.
  121	PDJDBFILEDIR	Specifies the file output destination of the Exception trace log using the Type4 JDBC driver.	JDBC driver
  122	PDJDBFILEOUTNUM	Specifies the number of outputs to the Exception trace log file using the Type4 JDBC driver.
  123	PDJDBONMEMNUM	Specifies the number of acquired information items in the Exception trace log memory using the Type4 JDBC driver.
  124	PDJDBTRACELEVEL	Specifies the trace acquisition level of the Exception trace log using the Type4 JDBC driver.

¹ Environment variables in this category are specified only for clients that use an X/Open-compliant API in an OLTP environment to access the HiRDB server. These environment variables are invalid for any other clients, even if the variables are specified.

For details about whether each environment variable is necessary, see 6.6.2 Specifications for using a UAP under OLTP as the client.

When the multi-connection facility is used, the values specified for the environment variables become invalid, even if they are registered to the environment variable group for each connection definition.

² This environment variable is set for plug-ins. The client libraries do not check the setting contents of this environment variable. Also, the information is not output to the SQL trace.

³ For the environment variables related to system configuration, specify the necessary information when the client connects with the HiRDB server. Whether or not these environment variables can be specified depends on the connection format with the HiRDB server. For details about connection formats with the HiRDB server, see 6.6.5 Environment variables and connection types for HiRDB servers.