Setting preferences for DB2 extract and load

You can set preferences in the Preferences window for how DB2® data is extracted and loaded.

To set preferences for DB2 extract and load:

  1. In the Preferences window: Click Windows > Preferences and expand the Data Management node.
  2. Click DB2 Options.
  3. Select or clear the Use DB2 commands to load and extract tables check box to specify how data is extracted and loaded. If you do not select this option, SQL queries are used. Using DB2 commands (LOAD and EXPORT) improves performance. However, you can only use DB2 commands when you are working with local databases. That is, the database must be on the same computer as the workbench.
  4. Click OK.
The next time you extract or load data from a DB2 database, your option is used.

Feedback