Version 5
|
|
Version 5
|
Deferred prepare provides a performance enhancement when accessing DB2 and DRDA databases by combining the SQL PREPARE statement flow with the associated OPEN, DESCRIBE, or EXECUTE statement flow to minimize the inter-process or network flow.
When deferred prepare is enabled, DB2 defers sending out SQL PREPARE statements until the associated OPEN, DESCRIBE, or EXECUTE statement is issued by the application. See the CLI Guide and Reference for details.
A PREPARE that is not eligible for deferral can be sent immediately, and have its cursor opened at the same time. PREPARE statements that normally cannot be deferred or pre-OPEN can also be optimized if the appropriate option is set in the sqlesetc - Set Client API or precompiler option. See the Command Reference for details.
 |
Version 5.2
|
The newlogpath configuration parameter allows users to change the location where log files are stored. Log files can now be stored on raw devices (Windows NT, AIX, and Solaris). This can speed up database operation as there will be less overhead in code path length for each I/O call to read or write the log, and there is no need to initialize the new log path to guarantee the disk space. See the Administration Guide for details.