Muutke küpsiste eelistusi

DB2 Replication Certification Guide [Pehme köide]

4.00/5 (2 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 432 pages, kõrgus x laius x paksus: 236x180x30 mm, kaal: 805 g
  • Ilmumisaeg: 04-May-1999
  • Kirjastus: IBM Press
  • ISBN-10: 0130824240
  • ISBN-13: 9780130824240
Teised raamatud teemal:
  • Pehme köide
  • Hind: 69,39 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
DB2 Replication Certification GuideSuurem pilt
  • Formaat: Paperback / softback, 432 pages, kõrgus x laius x paksus: 236x180x30 mm, kaal: 805 g
  • Ilmumisaeg: 04-May-1999
  • Kirjastus: IBM Press
  • ISBN-10: 0130824240
  • ISBN-13: 9780130824240
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780130824240.html
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.

Muu info

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.
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
Jonathan Cook and Calene Janacek are software professionals at IBM's International Technical Support Organization, Austin, TX.