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.
Related concepts
Characteristics of .data files
Data extraction and load limitations
Related tasks
Extracting data from a table or view to a .data file
Loading data from a .data file to a table
Related information
Setting preferences for DB2 database connections

Feedback