The DB2 Replication Certification Guide
Published on 4. May 1999
Book
Paperback/Softback
432 pages
978-0-13-082424-0 (ISBN)
Description
This is IBM's official guide to making the most of IBM DB2 UDB replication -- and an invaluable resource for anyone seeking IBM DB2 Certification. Master IBM's Apply and Capture programs, and understand exclusive IBM replication concepts such as replication subscriptions, "update-anywhere," and mobile replication. Learn how to install, configure, and operate IBM DB2's industry-leading replication features -- in both DB2-only and multi-vendor database environments. Understand DB2's push and pull replication configurations, as well as the fan-out configuration, which is ideal for large, distributed environments. Review DB2's rigorous conflict identification and automatic compensation features, which allow any replication to be reliably updated and propagated asynchronously to other replicas, enterprise-wide. Learn how to clone replication subscriptions, to save time in setting up multiple DB2 database servers. Finally, discover how take advantage of DB2 replication with mainframe data, Oracle databases, and in other diverse environments.
More details
Language
English
Place of publication
Armonk
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 236 mm
Width: 180 mm
Thickness: 30 mm
Weight
805 gr
ISBN-13
978-0-13-082424-0 (9780130824240)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
Jonathan Cook and Calene Janacek are software professionals at IBM's International Technical Support Organization, Austin, TX.
Content
Cook/Harbus THE DB2 REPLICATION CERTIFICATION GUIDE ISBN 0-13-082424-0 Figures. Tables. Preface. How This Book was Created. Chapter 1. An Overview of DB2 Data Replication. What is Data Replication? IBM Data Replication Products. Replication Connectivity Configurations. Summary. Chapter 2. Managing Replication Sources and Subscriptions. Overview. Replication Subscriptions. Managing Defaults for Replication Sources and Subscriptions. Summary. Chapter 3. Capture and Apply. The Capture Program. The Apply Program. Setting up Capture and Apply as Windows NT Services. Communications between Capture and Apply. Setting up a Simple Replication Configuration. Summary. Chapter 4. Replicating DB2 Data from OS/390 to Windows NT. Replication Overview. Capture for OS/390 V5 Considerations. Apply for Windows NT V5 Considerations. Test Environment for OS/390 and Windows NT Replication. Initial Configuration for the Replication Scenario. Setting up Capture for MVS. Setting up Apply for Windows NT. Starting Capture for MVS. Starting Apply for Windows NT. Managing the Replication Environment. Summary. Chapter 5. Staging Tables. Overview. Setting Up Replication Systems Using Staging Tables. Examples of Staging Table Configurations. Additional Considerations and Uses. Chapter 6. Update-Anywhere Replication. Overview. Setting Up an Update-Anywhere Environment. Preparing for Capture and Apply. Additional Considerations and Recommendations. Summary. Chapter 7. Mobile Replication. Overview. Planning for Mobile Replication. Setting Up a Mobile Replication Example. Summary. Chapter 8. Advanced Replication Techniques. Join Replication. Replicating From Oracle to DB2 UDB. CCD Table Considerations. DB2 ODBC Catalog. DB2 UDB Enterprise-Extended Edition Considerations. DB2 UDB Long Varchar Support. Summary. Chapter 9. Troubleshooting. Replication Administration. Running Capture. Running Apply. ASNLOAD Messages. Mobile Replication. Summary. Appendix A. Sample Certification Questions and Test Objectives. Data Replication Exam Objectives for Exam