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.

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