Call Level Interface Guide and Reference

Using Deferred Prepare to Reduce Network Flow

In DB2 CLI Version 5, deferred prepare is on by default. The PREPARE request is not sent to the server until the corresponding execute request is issued. This minimizes network flow and improves performance.

See Deferred Prepare now on by Default for complete details.