You can set preferences in the Preferences window for how DB2® data is extracted
and loaded.
About this task
To set preferences for DB2 extract and load:
- In the Preferences window: Click and expand the Data
Management node.
- Click DB2 Options.
- 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.
- Click OK.
Results
The next time you extract or load data from a DB2 database, your option is used.