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

• Pubblicazione: [San Jose, Calif.?], : IBM, International Technical Support Organization, 2003
• Edizione: 1st ed.
• Descrizione fisica: xxii, 338 p. : ill
• Disciplina: 005.75/65
• Soggetto topico: Database management
• Altri autori: BruniPaolo
• Note generali: "SG24-6905-00."
• Nota di bibliografia: Includes bibliographical references (p. 333-334) and index.
• Nota di contenuto: 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.
• Sommario/riassunto: 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.
• Titolo autorizzato: Moving data across the DB2 family
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910828471003321
• Lo trovi qui: Univ. Federico II
• Serie: IBM redbooks.; DB2 information management software.