Nonstop Database, HiRDB Version 9 UAP Development Guide
This section explains how to tune and troubleshoot ODBC UAPs.
Use the block transfer facility. To use this facility, specify the PDBLKF operand in the client environment definition. A specification value between 40 and 50 is recommended. Specifying a larger value has little effect in reducing the number of communications and instead may delay processing because of the increased processing overhead. For details about the block transfer facility, see 4.7 Block transfer facility.
Use the high-speed connection facility. To use this facility, specify the PDFESHOST, PDSERVICEPORT, and PDSERVICEGRP operands in the client environment definition. The high-speed connection facility shortens the time for connection to HiRDB. For details about the PDFESHOST, PDSERVICEPORT, and PDSERVICEGRP operands of the client environment definition, see 6.6.4 Environment definition information.
If a UAP accesses the HiRDB system via ODBC, the SQL statements specified in the UAP may differ from the SQL statements requested of the HiRDB system, depending on the environment in which the UAP was created. To check what kind of SQL statements are issued to the HiRDB system, use the SQL trace facility. To use this facility, specify the PDSQLTRACE operand in the client environment definition. It is recommended to also specify the trace output destination directory in the PDCLTPATH operand at this time. For details about the SQL trace facility, see 11.1.1 SQL tracing.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.