•  Replication with IBM Infosphere CDC
  • Overview of replication in solidDB®
  • Conventions
•  Overview of IBM InfoSphere CDC replication between solidDB® servers
  • Architectural overview of IBM InfoSphere CDC Replication
  •  Configurations
    • Using IBM InfoSphere CDC replication with High Availability (HotStandby)
  • Features
  •  Restrictions
    • Restrictions on solidDB® server in IBM InfoSphere CDC Replication deployments
    • Restrictions on IBM InfoSphere CDC in IBM InfoSphere CDC Replication deployments
  • Security and authentication
• Installing IBM InfoSphere CDC replication components
•  Configuring IBM InfoSphere CDC replication
  • Configuring solidDB® for IBM InfoSphere CDC replication
  • Creating IBM InfoSphere CDC instances
  • Setting up replication with IBM InfoSphere CDC Management Console
•  solidDB® specific settings and tasks for IBM InfoSphere CDC
  • Dropping and re-creating solidDB® source tables
  • Enabling use of foreign keys (referential integrity)
  • Starting mirroring in Management Console without synchronizing
  • Using Unicode and partial Unicode databases with IBM InfoSphere CDC replication
  • Enabling fast refresh
  • Using shared memory access (SMA) with IBM InfoSphere CDC replication
• Data aging
• SQL passthrough
•  Tools and utilities
  • Perl automation framework
  •  Instance and subscription management tools
    • ucdeploy – Configuration and setup sample
    • ucpassthrough – SQL passthrough setup sample
    • uchsbmonitor – HSB subscription monitoring sample
  •  SQL stored procedures for data aging and refresh
    • Using the Aging stored procedure
    • Using the Refresh stored procedure
    • Example: Automating data aging for bidirectional subscriptions
•  IBM InfoSphere CDC replication failure scenarios
  • Standalone solidDB® server fails
  • IBM InfoSphere CDC instance fails
  • solidDB® server in HA mode (HotStandby) fails
  • Communication link between primary solidDB® server and IBM InfoSphere CDC for solidDB® instance fails
• Troubleshooting
•  IBM InfoSphere CDC for solidDB® reference
  •  About IBM InfoSphere CDC
    • IBM InfoSphere CDC for solidDB® system requirements Disk space requirements
  •  Required database, user accounts, and schemas
    • Single byte and multibyte character support
  •  Installing IBM InfoSphere CDC
    • Installing IBM InfoSphere CDC using an interactive installation
    • Installing IBM InfoSphere CDC using a silent installation
  •  Configuring IBM InfoSphere CDC
    • Configuring IBM InfoSphere CDC instances (Windows)
    • Configuring IBM InfoSphere CDC instances (UNIX and Linux)
  •  Starting and stopping IBM InfoSphere CDC
    • Starting IBM InfoSphere CDC
    • Stopping IBM InfoSphere CDC
    • Enabling SQL statements in Management Console
  •  Datatypes supported by IBM InfoSphere CDC
    • Supported data types
    • Supported mappings
  • IBM InfoSphere CDC metadata tables
  •  Commands for IBM InfoSphere CDC
    • Using the IBM InfoSphere CDC commands
    • Setting the TSINSTANCE environment variable
    • Controlling replication commands
    • Database transaction log commands
    • Exporting and importing configuration commands
    • Managing tables for replication commands
    • Monitoring replication commands
    • Other commands
  •  User exits for IBM InfoSphere CDC
    • Stored procedure user exits for table and row level operations
    • Defining a stored procedure user exit
    • Stored procedure user exit database connections
    • Retrieving data with a stored procedure user exit
    • Example of a stored procedure user exit
    • IBM InfoSphere CDC API reference – Javadocs
  •  Conflict resolution audit table
    • Structure of the conflict resolution audit table
    • Row image format
    • Truncated images
    • Unaudited data types
  •  Configuring user exits
    • To configure a user exit for a Java class
  •  System parameters for IBM InfoSphere CDC for solidDB®
    • General product system parameters
    • Notification system parameters
    • Maximize throughput system parameters
    • Encoding system parameters
    • Disk resource system parameters
    • Apply process system parameters