Moving data across the DB2 family / [Paolo Bruni ... et al.].

Format:

Book

Contributor:

Bruni, Paolo.

International Business Machines Corporation. International Technical Support Center.

Series:

IBM redbooks.

DB2 information management software.

IBM redbooks

DB2 information management software

Language:

English

Subjects (All):

Database management.

IBM Database 2.

Physical Description:

xxii, 338 p. : ill.

Edition:

1st ed.

Place of Publication:

[San Jose, Calif.?] : IBM, International Technical Support Organization, 2003.

Language Note:

English

System Details:

text file

Summary:

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.

Contents:

Front cover

Contents

Figures

Examples

Tables

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Part 1 Introduction

Chapter 1. Introduction

1.0.1 Platforms and configurations

1.0.2 Terminology

1.1 Contents of this redbook

Chapter 2. Overview of data movers

2.1 Preliminary considerations

2.2 DB2 UDB for z/OS

2.2.1 DB2 DSN1COPY utility

2.2.2 DB2 sample program DSNTIAUL

2.2.3 DB2 Reorg utility

2.2.4 DB2 Unload utility

2.2.5 DB2 Load utility

2.2.6 DB2 Cross Loader option

2.3 DB2 UDB for UNIX and Windows

2.3.1 DB2 Backup and Restore utilities

2.3.2 DB2 Export utility

2.3.3 DB2 db2batch

2.3.4 DB2 Import utility

2.3.5 DB2 Load utility

2.3.6 DB2 Cross Loader option

2.3.7 DB2 db2move

2.3.8 DB2 db2look

2.4 Tools for z/OS and multiplatforms

2.4.1 DB2 Administration Tool for z/OS

2.4.2 DB2 Data Export Facility tool for z/OS

2.4.3 DB2 High Performance Unload tool for z/OS

2.4.4 DB2 Data Replication tools for z/OS and Multiplatform

2.4.5 DB2 Web Query tool for z/OS and Multiplatform

2.4.6 DB2 High Performance Unload tool for Multiplatforms

2.4.7 DB2 UDB Warehouse Manager for UNIX and Windows

2.5 Data movers summary

Part 2 Product functions and utilities

Chapter 3. Unload with DB2 for z/OS

3.1 Overview of the Unload utility

3.1.1 Extra functionality of the Unload utility

3.1.2 Privilege and authority required

3.1.3 Phases of the Unload utility

3.2 Input and output data sets

3.2.1 Output data sets from Unload

3.2.2 Input of Unload from image copy

3.3 Unload syntax and examples

3.3.1 Examples of using the Unload utility

3.3.2 Terminating or restarting Unload

Chapter 4. Load with DB2 for z/OS

4.1 The Load utility for DB2 for z/OS.

4.1.1 Input data for Load

4.1.2 Sample Load JCL

4.1.3 Some tips on using the Load

4.2 Cross Loader option

4.2.1 INCURSOR Load option

4.2.2 EXEC SQL utility control statement

4.2.3 Using the Cross Loader

4.3 Conclusions and recommendations

Chapter 5. Export and Import with DB2 distributed

5.1 Export utility overview

5.2 Using Export utility

5.2.1 Invoking the Export utility

5.3 Import utility overview

5.4 Using the Import utility

5.4.1 Invoking the Import utility

Chapter 6. Load with DB2 Distributed

6.1 Load utility overview

6.1.1 Per-partition Load operation

6.1.2 Load Recovery

6.2 AutoLoader utility

6.3 New features in DB2 distributed V8

6.3.1 Increased table space access during Load

6.3.2 Load with read access

6.3.3 Load into partitioned databases

6.3.4 Cross Loader option

6.3.5 Generated column support

6.3.6 Multi-dimensional clustering support

6.4 Using the Load utility

6.4.1 Invoking the Load utility

6.5 Comparing Load and Import

6.5.1 LOAD and Import performance comparison

6.5.2 Load and Import functional comparison

6.5.3 When to use Load or Import utilities

Part 3 High Performance Unload

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

7.1 An overview of HPU for z/OS

7.1.1 Applicability of HPU

7.1.2 Strong points of HPU

7.2 Installing HPU for z/OS

7.2.1 Installation requirements

7.2.2 Step-by-step installation procedures

7.2.3 Customization procedures for HPU

7.3 Data formats used by the HPU

7.3.1 Sources of input data that can be used by HPU

7.3.2 Output data formats

7.4 Using HPU

7.4.1 Using the HPU in batch mode

7.5 Components of the HPU statement

7.5.1 HPU blocks

7.5.2 Descriptions of the HPU blocks

7.6 Examples on using HPU in batch

7.7 Using the HPU interactively.

7.7.1 Using the DB2 Administration tool to start HPU

7.8 HPU performance measurements

7.9 Considerations

Chapter 8. IBM DB2 High Performance Unload for Multiplatforms

8.1 An overview of HPU for Multiplatforms

8.2 Installing and configuring HPU for MP

8.2.1 System requirements

8.2.2 Installation considerations and prerequisites

8.2.3 Installing HPU for MP

8.2.4 Installation directories and files

8.3 Using HPU for MP

8.3.1 Invoking HPU for MP

8.4 Comparing HPU for MP and Export

8.4.1 When to use HPU for MP tool or the Export utility

Part 4 Scenarios

Chapter 9. Getting ready for moving data

9.1 Before moving data

9.1.1 Choosing a tool or utility

9.1.2 Disk space considerations

9.1.3 Software considerations

9.1.4 File format considerations

9.1.5 Encoding scheme and code pages

9.1.6 Moving data with DB2 Connect

9.2 Extracting the data definition language

9.2.1 Using DB2 Administration Tool for z/OS to extract DDL

9.2.2 Using db2look to extract DDL

9.2.3 Considerations

Chapter 10. Moving data to DB2 for z/OS

10.1 Overview of moving data to DB2 for z/OS

10.2 Moving data from DB2 distributed

10.2.1 Using Cross Loader to move data from DB2 distributed to DB2 for z/OS

10.2.2 Data Propagator

10.2.3 Export and Import

10.2.4 SQL Insert with subselect in a Federated Database

10.3 Moving data between two DB2 for z/OS databases

10.3.1 Using Cross Loader to move data from/to DB2 for z/OS

10.3.2 Data Propagator

10.3.3 Unload and Load

10.3.4 HPU for z/OS and Load

10.3.5 SQL Insert with subselect in a Federated Database

10.4 Summary and conclusions

10.4.1 From distributed

10.4.2 From mainframe

10.4.3 Miscellaneous

Chapter 11. Moving data to DB2 Distributed

11.1 An overview

11.1.1 File format considerations.

11.1.2 Index considerations

11.1.3 Environment used for data movement examples

11.1.4 Graphical representation of the environment used in the examples

11.2 Cross loading

11.3 Export followed by Load or Import

11.4 SQL insert containing a SELECT clause

11.5 Data Propagator

11.6 HPU for z/OS followed by Load or Import

11.7 Unload utility followed by Load or Import

11.8 HPU for MP followed by Import or Load

Part 5 Appendixes

Appendix A. Defining a Federated Database

A.1 Examples of creating Federated Databases

A.1.1 Federated database setup with DB2 V7

A.1.2 Federated Database setup with DB2 V8

A.2 Server and wrapper type

Appendix B. DB2 connectivity

B.1 Communication database on DB2 for z/OS

B.1.1 Populate the communication database

B.1.2 CDB tables with contents

B.1.3 Test the connectivity

B.2 Cataloging the databases on DB2 distributed

Appendix C. Migrating to DB2 distributed V8

C.1 Migration restrictions

C.2 Pre- and post-migration tasks

Appendix D. DB2 UDB for z/OS Unload options

Abbreviations and acronyms

Related publications

IBM Redbooks

Other resources

Referenced Web sites

How to get IBM Redbooks

IBM Redbooks collections

Index

Back cover.

Notes:

"SG24-6905-00."

Includes bibliographical references (p. 333-334) and index.

OCLC:

61071569