Skip to main content

   

IBM Redbooks  >  Information Management software




Redbooks Abstract

Moving Data Across the DB2 Family



Download PDF (4.5 MB)


Get AdobeĀ® ReaderĀ®


View as HTML


Tips for viewing


Order Hardcopy


Others who downloaded this book also downloaded ...

Abstract

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 Redbook 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 downloaded this publication also downloaded
Rational Application Developer V7 Programming Guide, SG24-7501-00
DB2 for z/OS Stored Procedures: Through the CALL and Beyond, SG24-7083-00
DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More, SG24-6079-00


Profile

Publish Date
14 February 2003

Last Update
12 January 2004

Rating: rating
(based on 7 reviews)

Rate this book

Author(s)
Paolo Bruni
Michael Ho
Marko Milek
Arne Nilsen
Jose Mari Michael Sanchez

ISBN
0738428299

IBM Form Number
SG24-6905-00

Number of pages
360

Also available on

CD-ROM

SK3T-7876-13