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

Format:

Book

Contributor:

Gu, Lijun.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Database management.

IBM Database 2.

Physical Description:

xviii, 552 p. : ill.

Edition:

1st ed.

Place of Publication:

[San Jose, Calif. : IBM Corp., International Technical Support Organization], 2002.

Language Note:

English

Contents:

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.

Notes:

"DB2. Data management software"--Cover p. [1].

"SG24-6828-00."

Includes bibliographical references (p. 537-539) and index.

OCLC:

560314246