Loading data from a local or host file
You can use the web console to load data from a local file on your client. The file cannot be larger than 80% of the free space in your home directory. You can also load data that's stored on your host server.
Follow these steps to load data:
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.
| DBMS | Details | Learn More |
|---|---|---|
| Oracle | Unload the data from Oracle by using by using a utility such as Oracle Application Express®. | Oracle documentation about the unload process: Using Oracle Application Express Utilities |
| MySQL | Export the data from MySQL by using a utility such as MySQL Workbench or phpMyAdmin. | MySQL documentation about the export process: Data export |
| DB2® | Export the data from Db2 by using a command-line utility. | Db2 documentation about the export process: Exporting data |
Load the data
To load data from a local file using the web console, follow the steps on the user interface. A target table that is based on the data in the file can be automatically created for you. You can change column names and data types.
- Additional options for loading local data in Db2® Warehouse
-
- To load data from the local machine, click Client to indicate the file location.
- To load data that is stored on a host server file system, click Server to indicate the file location. The data that you are loading must be in the /mnt/clusterfs/scratch directory.