O'Reilly logo

Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition by Susan Visser, Bill Wong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required