Chapter 17. Moving Data
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 ...
Get Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
