Skip to main content

Moving Data Across the DB2 Family

An IBM Redbooks publication


Published on 14 February 2003, updated 12 January 2004

  1. .PDF (4.5 MB)

Share this page:   

ISBN-10: 0738428299
ISBN-13: 9780738428291
IBM Form #: SG24-6905-00

Authors: Paolo Bruni, Michael Ho, Marko Milek, Arne Nilsen and Jose Mari Michael Sanchez

    menu icon


    Moving data across different databases and even different platforms has been a common task in IT shops for quite some time. Applications may have been developed independently and over time, using packages and different technology; and data might reside on different platforms exploiting the specific platform strong points. However, there still is a growing need for applications that need to access all of this data for overall processing.

    While new Web related technologies are emerging with the intent to provide functions to collect and integrate information across multiple databases and applications for access in real time, moving data to one location for overall processing is still a very common requirement.

    This IBM Redbooks publication provides an overview of what is currently available within the DB2 Family of products (specifically DB2 for z/OS, and DB2 for UNIX and Windows) in terms of functions, tools, and utilities to satisfy the need for moving data. We focus on discussing High Performance Unload and Cross Loader; the first one is a tool, the second one is a new option of the Load utility, since they are the latest functions that IBM has released. We also introduce the concepts and some examples of using the Federated Database support.

    Table of Contents

    Part 1. Introduction

    Chapter 1. Introduction

    Chapter 2. Overview of data movers

    Part 2. Product functions and utilities

    Chapter 3. Unload with DB2 for z/OS

    Chapter 4. Load with DB2 for z/OS

    Chapter 5. Export and Import with DB2 distributed

    Chapter 6. Load with DB2 distributed

    Part 3. Tools

    Chapter 7. IBM DB2 High Performance Unload for z/OS

    Chapter 8. IBM DB2 High Performance Unload for Multiplatforms

    Part 4. Scenarios

    Chapter 9. Getting ready for moving data

    Chapter 10. Moving data to DB2 for z/OS

    Chapter 11. Moving data to DB2 distributedPart 5.

    Part 5. Appendixes

    Appendix A. Defining a federated database

    Appendix B. DB2 connectivity

    Appendix C. Migrating to DB2 distributed V8

    Appendix D. DB2 UDB for z/OS Unload options


    Others who read this also read