Optimizing ODBC access

DB2^® database provides special optimization designed to improve communication performance through ODBC. These enhancements are available to Microsoft^® Access, Lotus^® Approach^®, or Visual Basic. You can gain the benefit of faster ODBC throughput using DB2's Configuration Assistant (CA).

To activate the optimized ODBC:

If you are defining a new connection:
1. Start the DB2 CA.
2. Open the Selected menu and select Add Database Using Wizard...
3. Follow the wizard's pages until you get to the Data Source page.
4. Check Register this database for CLI/ODBC.
5. Specify how CLI/ODBC applications accessing this database should be registered:
  - As system data source means the database is available to all users on the system.
  - As user data source means you are the only user who can access the database.
  - As file data source means a file containing data source information will be created. This data source file can be shared with other workstations if you have a TCP/IP connection. Otherwise, the file can only be used on this computer
6. Type a Data source name.
7. (Optionally) Select an application from the Optimize for application list to optimize the data source settings for a particular application.
8. Click OK and exit the CA.
If you are updating an existing connection:
1. Start the DB2 CA.
2. Double-click the database alias that you want to optimize.
3. Click Data Source.
4. Check Register this database for CLI/ODBC.
5. Specify how CLI/ODBC applications accessing this database should be registered:
  - As system data source means the database is available to all users on the system.
  - As user data source means you are the only user who can access the database.
  - As file data source means a file containing data source information will be created. This data source file can be shared with other workstations if you have a TCP/IP connection. Otherwise, the file can only be used on this computer
6. Type a Data source name.
7. (Optionally) Select an application from the Optimize for application list to optimize the data source settings for a particular application.
8. Click OK and exit the CA.