Techniques for reducing network flow

You can take several actions to reduce network flow.

To reduce the network flow that your Db2 ODBC applications generate, consider the following actions:
  • Use SQLSetColAttributes() to reduce network flow.
  • Disable autocommit.
  • Use arrays to send and retrieve data.
  • Manipulate large data values at the server.