A practical guide to DB2 UDB data replication V8 / / [Lijun (June) Gu ... et al.]

• Pubblicazione: [San Jose, Calif., : IBM Corp., International Technical Support Organization], 2002
• Edizione: 1st ed.
• Descrizione fisica: xviii, 552 p. : ill
• Disciplina: 005.75/65
• Soggetto topico: Database management
• Altri autori: GuLijun
• Note generali: "DB2. Data management software"--Cover p. [1].; "SG24-6828-00."
• Nota di bibliografia: Includes bibliographical references (p. 537-539) and index.
• Nota di contenuto: Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction to DB2 Replication V8 -- 1.1 Overview of the IBM replication solution -- 1.2 Why use replication? -- 1.2.1 Distribution of data to other locations -- 1.2.2 Consolidation of data from remote systems -- 1.2.3 Bidirectional exchange of data -- 1.2.4 Other requirements -- 1.3 DB2 V8 replication from 30,000 feet -- 1.3.1 Administration -- 1.3.2 Capture -- 1.3.3 Apply -- 1.3.4 Alert Monitor -- 1.4 Putting the pieces together -- 1.4.1 Administration for all scenarios -- 1.4.2 Data distribution and data consolidation -- 1.4.3 Bidirectional with a master (update anywhere) -- 1.4.4 Bidirectional with no master (peer-to-peer) -- 1.4.5 Alert Monitor configuration -- 1.5 DB2 Replication V8 close up -- 1.5.1 Administration - defining a replication scenario -- 1.5.2 Operations - DB2 Capture and Apply -- 1.5.3 Operations - Informix Capture and Apply -- 1.5.4 Administration and operations - Alert Monitor -- 1.6 What's new in DB2 Replication V8 -- 1.6.1 Administration -- 1.6.2 Capture -- 1.6.3 Apply -- 1.6.4 Monitor -- 1.6.5 Troubleshooting -- 1.7 The redbook environment -- Chapter 2. Getting started with Replication Center -- 2.1 DB2 Replication Center's architecture -- 2.2 Technical requirements for DB2 Replication Center -- 2.2.1 Hardware requirements -- 2.2.2 Software requirements -- 2.2.3 Networking requirements -- 2.2.4 Requirements at replication servers -- 2.2.5 Requirements for replication to/from non-DB2 servers -- 2.3 DB2 products needed to use Replication Center -- 2.4 How to get Replication Center -- 2.4.1 How to get DB2 Connect Personal Edition -- 2.5 Installing DB2 Replication Center -- 2.5.1 System kernel parameters on Solaris, HP-UX, and Linux. ; 2.5.2 Installing DB2 Administration Client with Replication Center -- 2.6 Configuring DB2 Connectivity for Replication Center -- 2.7 Replication Center and file directories -- 2.8 Desktop environment for Replication Center -- 2.9 Opening DB2 Replication Center -- 2.10 A Quick Tour of DB2 Replication Center -- 2.11 Managing your DB2 Replication Center profile -- 2.12 Replication Center dialog windows -- 2.13 Run Now or Save SQL -- 2.13.1 Running Saved SQL files later -- 2.14 Creating Control Tables - using Quick or Custom -- 2.15 Adding Capture and Apply Control Servers -- 2.15.1 Removing Capture/Apply Control Centers -- 2.16 Replication Center objects for non-DB2 servers -- 2.17 Creating registrations and subscriptions -- 2.18 Replication Center Launchpad -- 2.19 Trying replication with the DB2 SAMPLE database -- 2.20 More Replication Center tips -- Chapter 3. Replication control tables -- 3.1 Introduction to replication control tables -- 3.2 Setting up capture control tables -- 3.2.1 Create capture control tables -- 3.2.2 Platform specific issues, capture control tables -- 3.3 Setting up apply control tables -- 3.3.1 Creating apply control tables -- 3.3.2 Platform specific issues, apply control tables -- 3.4 Advanced considerations -- 3.4.1 Creating control tables at a command prompt -- 3.4.2 Capture control tables - advanced considerations -- 3.4.3 Apply control tables - advanced considerations -- 3.4.4 Sizing tablespaces for control tables -- 3.4.5 Control tables described -- Chapter 4. Replication sources -- 4.1 What is a replication source? -- 4.2 Define a replication source from Replication Center -- 4.2.1 Registering the replication sources -- 4.2.2 Selecting the replication sources -- 4.2.3 Defining the registration options -- 4.2.4 iSeries replication sources -- 4.2.5 CD Table -- 4.2.6 Non-DB2 sources - CCD tables. ; 4.2.7 Non-DB2 sources - Capture triggers and procedures -- 4.3 Views as replication sources -- 4.3.1 Views over one table -- 4.3.2 Views over multiple tables -- 4.3.3 Restrictions on views -- Chapter 5. Subscription set -- 5.1 Subscription set and subscription set members -- 5.1.1 Subscription attributes -- 5.2 Subscription set and member planning -- 5.2.1 Member definitions to non-DB2 targets servers -- 5.2.2 Subscription set and apply qualifiers planning -- 5.3 Define subscriptions using the Replication Center -- 5.3.1 Create subscription sets with members -- 5.3.2 Create subscription set without members -- 5.3.3 Subscription sets from non-DB2 servers -- 5.3.4 Subscription sets to non-DB2 servers -- 5.3.5 Adding subscription members to existing subscription sets -- 5.3.6 Subscription sets and member notebook -- 5.4 Target types descriptions -- 5.4.1 User copy -- 5.4.2 Point-in-time -- 5.4.3 Aggregate tables -- 5.4.4 CCD (consistent change data) -- 5.4.5 Replica -- 5.5 Data blocking -- 5.6 Scheduling replication -- 5.7 SQL script description -- 5.8 Create subscriptions using iSeries CL commands -- 5.8.1 Add subscription set - ADDDPRSUB -- 5.8.2 Add subscription members - ADDDPRSUBM -- Chapter 6. Operating Capture and Apply -- 6.1 Basic operations on Capture and Apply -- 6.1.1 Basic operations from the Replication Center -- 6.1.2 Basic operations from the command prompt -- 6.1.3 Considerations for DB2 UDB for UNIX and Windows -- 6.1.4 Considerations for DB2 UDB for z/OS -- 6.1.5 Considerations for DB2 UDB for iSeries -- 6.1.6 Troubleshooting the operations -- 6.2 Capture and Apply parameters -- 6.2.1 Change Capture parameters -- 6.2.2 Capture parameters -- 6.2.3 Apply parameters -- 6.3 Other operations -- 6.3.1 Pruning control tables -- 6.3.2 Reinitializing Capture -- 6.3.3 Suspend and resume Capture -- 6.4 Using ASNLOAD for the initial load. ; 6.4.1 Using ASNLOAD on DB2 UDB for UNIX and Windows -- 6.4.2 Using ASNLOAD on DB2 UDB for z/OS -- 6.4.3 Using ASNLOAD on the iSeries -- Chapter 7. Monitoring and troubleshooting -- 7.1 Capture and Apply status -- 7.2 Replication alert monitoring -- 7.2.1 Creating monitoring control tables -- 7.2.2 Create contacts -- 7.2.3 Alert Conditions -- 7.2.4 Replication monitoring and non-DB2 sources -- 7.2.5 Replication monitoring and non-DB2 targets -- 7.2.6 Replication monitor program operations -- 7.2.7 Using JCL to start monitoring on z/OS -- 7.2.8 Receiving an alert -- 7.2.9 Replication monitoring example -- 7.3 Other monitoring -- 7.3.1 Examining historic data -- 7.3.2 Health center -- 7.3.3 System monitoring -- 7.4 Troubleshooting -- 7.4.1 DB2 Administration Client -- 7.4.2 Files generated -- 7.4.3 Replication Analyzer (asnanalyze and ANZDPR) -- 7.4.4 Replication Trace (asntrc and WRKDPRTRC) -- 7.4.5 DB2 Trace -- 7.4.6 db2support -- 7.4.7 How to get assistance -- 7.4.8 Platform specific troubleshooting -- 7.5 Advanced troubleshooting -- 7.5.1 asnanalyze and ANZDPR -- 7.5.2 DB2 replication trace -- Chapter 8. Maintaining your replication environment -- 8.1 Maintaining registrations -- 8.1.1 Adding new registrations -- 8.1.2 Deactivating and activating registrations -- 8.1.3 Removing registrations -- 8.1.4 Changing capture schemas -- 8.1.5 Changing registration attributes for registered tables -- 8.2 Maintaining subscriptions -- 8.2.1 Adding new subscriptions sets -- 8.2.2 Deactivating and activating subscriptions -- 8.2.3 Changing subscription sets -- 8.2.4 Removing subscription sets -- 8.2.5 Adding members to existing subscription sets -- 8.2.6 Changing attributes of subscription sets -- 8.2.7 Adding a new column to a source and target table -- 8.3 Promote function -- 8.3.1 Promoting registered tables -- 8.3.2 Promoting registered views. ; 8.3.3 Promoting subscription sets -- 8.4 Maintaining capture and apply control servers -- 8.4.1 Manually pruning replication control tables -- 8.4.2 RUNSTATS for replication tables -- 8.4.3 REORG for replication tables -- 8.4.4 Rebinding replication packages and plans -- 8.4.5 Recovering source tables, replication tables, or target tables -- 8.4.6 Managing DB2 logs and journals used by Capture -- 8.5 Full refresh procedures -- 8.5.1 Automatic full refresh -- 8.5.2 Manual full refresh -- 8.5.3 Bypassing the full refresh -- Chapter 9. Advanced replication topics -- 9.1 Replication filtering -- 9.1.1 Replicating column subsets -- 9.1.2 Replicating row subsets -- 9.2 Replication transformations -- 9.2.1 Capture transformations -- 9.2.2 Source table views -- 9.2.3 Apply transformations -- 9.2.4 Before and after SQL statements -- 9.3 Replication of large objects -- 9.3.1 DB2 LOB replication -- 9.3.2 Informix LOB replication -- 9.4 Replication of DB2 Spatial Extender data -- 9.5 Update anywhere replication -- 9.5.1 Administration - defining update anywhere replication -- 9.5.2 Operations - Capture and Apply -- 9.6 DB2 peer to peer replication -- 9.6.1 Administration and operations for peer to peer replication -- 9.6.2 Adding another peer -- 9.6.3 Conflict detection using triggers -- Chapter 10. Performance -- 10.1 End-to-end system design for replication -- 10.1.1 Pull replication system design -- 10.1.2 Push replication system design -- 10.1.3 iSeries-to-iSeries replication with remote journalling -- 10.1.4 Replicating to non-DB2 servers -- 10.1.5 Replicating from non-DB2 -- 10.2 Capture performance -- 10.2.1 Reading the DB2 Log -- 10.2.2 Reading iSeries Journals -- 10.2.3 Collecting transaction information in memory -- 10.2.4 Capture Insert into CD and UOW tables -- 10.2.5 Capture pruning -- 10.2.6 non-DB2 source servers -- 10.2.7 Capture's latency. ; 10.2.8 Capture's throughput.
• Titolo autorizzato: A practical guide to DB2 UDB data replication V8
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910822242303321
• Lo trovi qui: Univ. Federico II
• Serie: IBM redbooks.