Migration from Db2 Warehouse

You can use the web console to load data from your existing Db2 Warehouse instance into the Db2 Warehouse application on the appliance.

About this task

The file cannot be larger than 80% of the free space in your home directory. Information on free space can be found by going to Home > Monitor > System > Storage and hovering on the disk icon at the top-right of the web console.

Attention: Db2 Warehouse includes sample data for loading. For more information, see Loading sample data for Db2 Warehouse.

Follow these steps to load data:

1. Create a data file.
   To be able to load data, you must save the data in a delimited file, such as a comma-separated (CSV) file. To create a delimited format file, use a database utility to extract data from your data store or DBMS to a file. Each data file must contain data from one table only.
2. Load data from a local file.

   You can use the Load option to load data from an Microsoft Excel file or a delimited text file, such as a comma-separated value (CSV) file. The file can be on either your client or server. You can load initial data into a table, add data to a table, or replace all the data in a table.

   Provide the requested information in the user interface:

   Source

   Choose what type of data you have.

   Target

   Select where you want to put your data. It can be an existing table or one you create on the fly.

   Define

   Here's where you want to check if your data will load properly. Data types are automatically detected, and you'll be able to adjust column names, data types, and the separator character to make it work.

   Finalize

   As a last step, review your selections before you start loading your data.