Home Page Icon
Home Page
Table of Contents for
Front cover
Close
Front cover
by Wim Van Tichelen, Bill Shubin, Deepak Rangarao, Judy Parkes, Anzar Noor, Frank K
Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC
Front cover
Notices
Trademarks
Preface
The team who wrote this book
Now you can become a published author, too!
Comments welcome
Stay connected to IBM Redbooks
Chapter 1. Introduction and overview
1.1 Optimized data integration
1.2 InfoSphere architecture
Chapter 2. InfoSphere CDC: Empowering information management
2.1 The need for dynamic data
2.2 Data delivery methods
2.3 Providing dynamic data with InfoSphere CDC
2.3.1 InfoSphere CDC architectural overview
2.3.2 Reliability and integrity
Chapter 3. Business use cases for InfoSphere CDC
3.1 InfoSphere CDC techniques for transporting changed data
3.1.1 Option 1: Database staging
3.1.2 Option 2: Message queue (MQ) based integration
3.1.3 Option 3: File-based integration
3.1.4 Option 4: InfoSphere DataStage Direct Connect
3.2 Data warehousing and business intelligence
3.2.1 Active data warehousing
3.2.2 Slowly changing dimensions
3.3 Consolidation
3.3.1 Consolidation: Sample implementation 1
3.3.2 Consolidation: Sample implementation 2
3.4 Distribution
3.4.1 Distribution: Sample implementation 1
3.4.2 Distribution: Sample implementation 2
3.5 Database migration
3.5.1 Database migration: Sample implementation
3.6 Application integration
3.6.1 Application integration: Sample implementation 1
3.6.2 Application integration: Sample implementation 2
3.6.3 Application integration: Sample implementation 3
3.7 Integration with master data management
3.7.1 Integration with master data management: Sample implementation
3.8 Integration with IBM Information Server
3.8.1 Integration with IBM Information Server: Sample implementation
3.9 Operational business intelligence
3.9.1 Operational business intelligence: Sample implementation
Chapter 4. Solution topologies
4.1 Unidirectional replication
4.2 Cascading replication
4.3 Bidirectional replication
4.4 Consolidation replication
4.5 Data distribution replication
4.6 Hub-and-Spoke replication with propagation
4.7 Destination
4.7.1 JMS Message Queue
4.7.2 Flat files
4.7.3 DataStage
4.7.4 Web services
Chapter 5. InfoSphere CDC features and functionality
5.1 Transformations
5.1.1 Column functions
5.1.2 Journal control fields
5.1.3 Joining
5.1.4 User exits for customizations
5.1.5 Considerations for using transformational functionality
5.2 Replication modes
5.2.1 Refresh
5.2.2 Continuous mirroring
5.2.3 Scheduled end (net change)
5.3 Filtering
5.3.1 Row level
5.3.2 Column level
5.4 Apply methods
5.4.1 Standard
5.4.2 LiveAudit
5.4.3 Adaptive Apply
5.4.4 Summarization
5.4.5 Row consolidation
5.4.6 Soft deletes
5.4.7 Custom apply methods (user exits)
5.4.8 Flat files
5.4.9 DataStage direct connect
5.4.10 JMS message queues
5.5 Conflict detection and resolution
Chapter 6. Understanding the architecture
6.1 Component overview
6.1.1 InfoSphere CDC instances
6.1.2 Interoperability between the InfoSphere CDC components
6.2 Management Console fundamentals
6.2.1 Access Manager Interface
6.2.2 Configuration Interface
6.2.3 Monitoring Interface
6.2.4 InfoSphere CDC API
6.2.5 Access Server fundamentals
6.3 The InfoSphere CDC engine
6.3.1 Bookmarks
6.3.2 The InfoSphere CDC Linux, UNIX, and Windows engine
6.3.3 The InfoSphere CDC for System i engine
6.3.4 The InfoSphere CDC for z/OS engine
6.4 Communications between source and target
6.5 Summary
Chapter 7. Environmental considerations
7.1 Globalization with InfoSphere CDC
7.1.1 Time zone considerations
7.1.2 Encoding conversions
7.2 Firewall configurations
7.2.1 How InfoSphere CDC uses TCP/IP
7.2.2 Firewalls
7.2.3 InfoSphere CDC in a firewalled network environment
7.2.4 Configuring source port restrictions
7.2.5 Troubleshooting CDC connection issues
7.3 Log retention
7.3.1 Log retention general guidelines
7.3.2 Log retention platform-specific guidelines
7.4 Remote processing capabilities
7.4.1 Remote source
7.4.2 Remote target
7.4.3 Remote source and target
7.4.4 Log shipping
7.5 Using InfoSphere CDC in resilient environments
7.5.1 InfoSphere CDC reachability: Virtual IP
7.5.2 InfoSphere CDC binary files and metadata for the Linux, UNIX, and Windows engine
7.5.3 InfoSphere CDC on a shared volume
7.5.4 InfoSphere CDC on separate nodes with a shared database
7.5.5 InfoSphere CDC on separate servers with separate databases
7.5.6 System i resilient environments
7.5.7 z/OS / Sysplex and InfoSphere CDC in resilient environments
7.6 Change management
7.6.1 Understanding InfoSphere CDC bookmarks
7.6.2 Change Management sample environment
7.6.3 DDL changes in a service window
7.6.4 DDL changes without a service window
Chapter 8. Performance analysis and design considerations
8.1 High volume between two systems
8.1.1 Latency and throughput
8.1.2 InfoSphere CDC architecture
8.2 Identification of potential bottlenecks
8.3 Performance monitoring in InfoSphere CDC environments
8.3.1 Performance monitoring using the Management Console
8.3.2 System monitoring tools
8.4 Using workflow for performance issues
8.5 Installation considerations
8.5.1 Silent installations and instance creation
8.6 Design considerations
8.6.1 Using multiple parallel subscriptions
8.6.2 Using multiple InfoSphere CDC instances
8.6.3 Using an n-tiered architecture
8.6.4 Using cascading replication to spread the workload
8.6.5 Continuous scraping
Chapter 9. Customization and automation
9.1 Options for managing InfoSphere CDC
9.2 Management Console GUI
9.3 Management Console commands
9.3.1 Common uses for the Management Console commands
9.3.2 Compiling Management Console command scripts
9.4 InfoSphere CDC engine commands (CLI)
9.4.1 Running commands for the Linux, UNIX, and Windows engine
9.4.2 Running CL commands for System i
9.4.3 Running console commands for IBM System z
9.4.4 Sample scripts
9.4.5 Checking an InfoSphere CDC engine and subscriptions activity
9.4.6 Removing obsolete database logs
9.5 InfoSphere CDC API
9.5.1 Development environment setup
9.5.2 Contents of the api.jar file
9.5.3 Connecting to and managing the Access Server
9.5.4 Connecting to the data stores
9.5.5 Configuring InfoSphere CDC replication
9.5.6 Creating a subscription
9.5.7 Procedure for mapping tables
9.5.8 Table mapping example
9.5.9 Procedure for removing mapped tables
9.5.10 Table mapping removal example
9.5.11 Row and column filtering
9.5.12 Derived columns
9.5.13 Encoding conversions (before and after Version 6.5)
9.5.14 Operations and user exits
9.5.15 Common procedures (updating table definitions)
9.5.16 Deploying subscription changes and considerations
9.5.17 Starting, stopping, and monitoring subscriptions
9.5.18 Monitoring latency
9.5.19 Monitoring event logs using the API
9.6 Monitoring and integration with external monitoring solutions
9.6.1 Components to monitor
9.6.2 InfoSphere CDC instance activity
9.6.3 Subscription activity
9.6.4 Events
9.6.5 Latency
9.7 User exits
9.7.1 Common uses for user exits
9.7.2 User exit programs
9.7.3 Derived expression user exits
9.7.4 Table and row-level user exits
9.7.5 Subscription-level (unit of work)
9.7.6 Java user exit for flat file custom formatter
9.7.7 Notifications
Appendix A. Single scrape events and errors
Single scrape error events
Appendix B. Additional material
Locating the web material
Using the web material
Glossary
Related publications
IBM Redbooks
Online resources
Help from IBM
Back cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Note: Before using this information and the product it supports, read the information in “Notices” on page ix.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset