Today, you see how to move data in and out of a DB2 database by importing, loading, or exporting:
If you want to create a new database, replace data in an existing database, or append to the data in an existing database with data from another source, you use the Import utility.
If you have a substantial amount of data that you need to move into your database, consider using the Load utility rather than the Import utility.
If you need to move data from a DB2 database to another source, use the Export utility.
The Import and Load utilities provide similar functions, but the Load utility performs better when large amounts of data are involved. All three utilities support several different file formats, giving you flexibility to ...