search for books and compare prices
Tables of Contents for The DB2 Universal Replication Certification Guide
Chapter/Section Title
Page #
Page Count
Figures
xi
Tables
xvii
Preface
xix
How This Book was Created
xxi
An Overview of DB2 Data Replication
1
34
What is Data Replication?
3
26
Data Replication Sources
4
1
Data Replication Targets
5
1
Registrations and Subscriptions
5
1
Administration through the Control Center
6
2
Subscription Sets
8
2
The Capture Process
10
1
The Apply Process
11
5
Source, Target, and Control Servers
16
1
Control Tables
17
1
Data Transformation
18
5
Staging Tables
23
1
Scheduling Replication
24
1
Update Anywhere
25
2
Pruning Data
27
1
Mobile Replication
27
2
IBM Data Replication Products
29
4
Software Requirements
31
1
Hardware Requirements
32
1
Replication Connectivity Configurations
33
1
Summary
34
1
Managing Replications Sources and Subscriptions
35
24
Overview
35
8
Defining a Replication Source
35
3
Defining a Custom Replication Source
38
2
Other Types of Replication Sources
40
1
Defining Join Replication Sources
40
2
Managing Replication Sources
42
1
Replication Subscriptions
43
13
Defining a Subscription
43
4
Defining Subscriptions - Advanced Options
47
1
Defining Target Table Types
47
1
Defining Target Columns
48
3
Defining Target Rows
51
1
Specifying SQL Statements
52
1
Defining Timing and Event-based Settings
53
2
Managing Subscriptions
55
1
Managing Defaults for Replication Sources and Subscriptions
56
2
Replication Defaults Using Tools Settings
56
2
Replication Control Tables Defaults
58
1
Summary
58
1
Capture and Apply
59
30
The Capture Program
59
9
How the Capture Program Works
59
1
Replicating Updates
60
1
Authorization Requirements
61
1
Running the Capture Program on Windows NT
62
2
Starting Capture on Windows NT
64
1
Controlling Capture
65
1
Specifying Tuning Parameters for Capture
66
2
The Apply Program
68
7
How the Apply Program Works
68
1
The Apply Qualifier
69
1
Authorization Requirements
70
1
Triggering Replication
70
2
Running the Apply Program on Windows NT
72
1
Starting Apply
73
1
Stopping Apply
74
1
Setting up Capture and Apply as Windows NT Services
75
3
Communications between Capture and Apply
78
3
Pruning
80
1
Setting up a Simple Replication Configuration
81
6
Defining a Replication Source
82
1
Defining a Replication Subscription
83
3
Binding the Capture Program
86
1
Binding the Apply Program
86
1
Creating the Password File
87
1
Starting the Capture Program
87
1
Starting the Apply Program
87
1
Summary
87
2
Replicating DB2 Data from OS/390 to Windows NT
89
80
Replication Overview
89
1
Capture for OS/390 V5 Considerations
90
3
Archived Log Read Support
91
1
Compression Data Support
91
1
Data Sharing Support
92
1
Authorization for Running Capture for MVS
92
1
Apply for Windows NT V5 Considerations
93
2
Uncommitted Read (UR) Isolation Level Support
93
1
Subscription Sets
94
1
Test Environment for OS/390 and Windows NT Replication
95
5
Configuring TCP/IP DRDA for DB2 for OS/390
97
3
Initial Configuration for the Replication Scenario
100
17
Defining a Replication Source
101
8
Defining a Replication Subscription
109
8
Setting up Capture for MVS
117
4
Starting Capture
119
2
Setting up Apply for Windows NT
121
4
Authorization
122
1
Binding the Apply Packages
122
1
Apply Password File
123
2
Starting Capture for MVS
125
2
Starting Apply for Windows NT
127
3
Managing the Replication Environment
130
38
Operating Capture for MVS
130
2
Removing a Replication Source
132
2
Stopping Apply for Windows NT
134
1
Communication between Capture and Apply in Full Refresh
135
1
Differential Copy
136
4
Manual Pruning
140
1
ASNDONE User Exit
141
2
LOADX Option to Refresh the Target Table
143
2
Manual Loading
145
3
Event Timing
148
7
Before and After SQL
155
7
Data Blocking Using MAX_SYNCH_MINUTES
162
6
Summary
168
1
Staging Tables
169
42
Overview
169
7
Types of Staging Tables
172
4
Setting Up Replication Systems Using Staging Tables
176
18
Defining a Replication Source
177
4
Defining a Subscription
181
10
Preparing Apply and Capture
191
1
Running Capture and Apply
192
1
Testing the Configuration
193
1
Examples of Staging Table Configurations
194
15
Internal Staging Table (Non-Complete and Condensed)
194
8
Remote Staging Table (Complete and Condensed)
202
5
Remote Staging Table with a Complete History
207
2
Additional Considerations and Uses
209
2
Update-Anywhere Replication
211
38
Overview
211
11
No Conflict Detection (None)
213
2
Standard Conflict Detection
215
4
Enhanced Conflict Detection
219
3
Setting Up an Update-Anywhere Environment
222
19
Defining a Replication Source
222
6
Defining a Subscription
228
13
Preparing for Capture and Apply
241
4
Running Capture and Apply
242
1
Testing the Configuration
243
2
Additional Considerations and Recommendations
245
1
Rejected Transactions
246
1
Summary
246
3
Mobile Replication
249
24
Overview
249
2
Planning for Mobile Replication
251
1
Hardware and Software Requirements
251
1
Security Requirements
251
1
Setting Up a Mobile Replication Example
251
20
Creating the Example Databases
252
1
Creating the Example Tables
253
2
Defining the Replication Source
255
3
Defining the Subscription
258
3
Binding the Apply Program to the Example Databases
261
2
Binding the Mobile Client GUI
263
1
Identifying the Control Server Database
263
1
Directory for Generated Files
264
1
Specifying Stub Code for the Dial and Hang-up Software
264
1
Creating a Password File
265
1
Inserting Test Data
265
1
Invoking the Mobile Replication GUI
266
1
Verifying that Replication Occurred
267
4
Summary
271
2
Advanced Replication Techniques
273
82
Join Replication
273
15
Join Scenario Overview
274
1
Defining a Join Replication Source
275
4
Defining the Subscription
279
4
Full Refresh
283
1
Differential Copy
284
2
Double Delete
286
2
Replicating From Oracle to DB2 UDB
288
26
Overview of the Replication Configuration
289
1
Placement of the Control Tables and Data Tables
290
1
Configuring the Source Table - Nickname Definition
291
1
Defining the Control Tables
292
5
Defining a Registration
297
5
Defining a Subscription Set
302
2
Defining a Subscription Member
304
3
Trigger to Coordinate Capture and Apply
307
1
Upper Limit of the Apply Program
308
2
Pruning the CCD Table
310
1
Logical Partitioning Key Support in Triggers
311
2
Obtaining a Sequence Number from Other Sources
313
1
The Trigger Already Exists
313
1
SQL30090N When Dropping Control Tables
313
1
CCD Table Considerations
314
19
Local or Remote
314
1
Complete or Condensed
315
1
Internal of External CCD
315
1
Change History CCD Example
315
6
Gap Resolution
321
2
External Data Considerations
323
10
DB2 ODBC Catalog
333
16
DB2 ODBC Catalog Enhancements
335
1
Software Requirements
336
1
Setting up Capture for MVS
336
1
Setting up Apply for MVS
337
2
Defining the Replication Sources and Subscriptions
339
2
Setting up the Workstation Client
341
2
Starting Capture for MVS
343
1
Starting Apply for MVS
344
2
Stopping Apply for MVS
346
1
Verifying That the DB2 ODBC Catalog Was Used
346
3
DB2 UDB Enterprise-Extended Edition Considerations
349
2
Administration Considerations
349
2
Capture Considerations
351
1
Apply Considerations
351
1
DB2 UDB Long Varchar Support
352
2
Summary
354
1
Troubleshooting
355
20
Replication Administration
356
1
Replication Administration Messages
356
1
Replication Administration Problem Determination Checklist
357
1
Running Capture
357
5
Capture Program Trace Control Table
357
1
Capture Program Trace File
358
1
Capture Program log File
359
1
Capture Program Error Mesages
360
1
Capture Program Determination Checklist
361
1
Running Apply
362
11
The Apply Trail Control Table
362
5
Apply Program Trace File
367
2
The Apply Program Log File
369
1
Apply Program Error Messages
369
3
Apply Program Determination Checklist
372
1
ASNLOAD Messages
373
1
Mobile Replication
373
1
Summary
374
1
Appendix A. Sample Certification Questions and Test Objectives
375
1
A.1 Data Replication Exam Objectives for Exam #508
375
1
A.2 Samplle Questions
376
10
A.3 Answers to Sample Questions
386
3
Appendix B. Replication Tables
389
2
Appendix C. Replication Defaults File - DPREP.DFT
391
2
Appendix D. Script to Create Control Table - DPCNTL.UDB
393
6
Appendix E. Related Publications
399
2
Index
401