•  Universal Cache: User Guide
  • Conventions
  • Syntax notation conventions
•  Universal Cache installation and configuration overview
  •  Prerequisites
    • System requirements for Universal Cache
    • solidDB® supported platforms
    • Supported backend data servers for Universal Cache
    • solidDB® installation requirements
    • User process resource limits (ulimits) considerations in Linux and UNIX environments
    • Security-enhanced Linux considerations
    • Component and installation package information
    • User accounts and database connection data for Universal Cache
  •  Installation topologies for Universal Cache
    • Example: Evaluation topology
    • Example: Production topology
    • Example: Multiple cache databases topology
    • Example: Universal Cache with High Availability topology
  •  Installing and configuring Universal Cache
    • Overview of Universal Cache installation and configuration steps
    • Installing and configuring solidDB® server for Universal Cache
    • Installing and configuring IBM InfoSphere CDC for solidDB®
    • Installing and configuring your backend data server
    • Installing and configuring IBM InfoSphere CDC for your backend data server
    • Installing and configuring IBM InfoSphere CDC Access Server
    • Installing and configuring IBM InfoSphere CDC Management Console
  •  Installing drivers
    • Installing solidDB® JDBC Driver
    • Installing solidDB® ODBC Driver
    • Installing and configuring backend ODBC drivers for SQL passthrough
•  Setting up caching
  •  Setting up caching with Management Console
    • Key concepts for setting up caching with Management Console
    • Deciding on the replication model
  •  Universal-Cache-specific settings and tasks for IBM InfoSphere CDC
    • Important IBM InfoSphere CDC system parameter settings for Universal Cache
    • Enabling use of foreign keys (referential integrity)
    • Dropping and re-creating solidDB® source tables
    • Starting mirroring in Management Console without synchronizing data
    • Using Unicode and partial Unicode databases with Universal Cache
    • Enabling fast refresh
    • Using shared memory access (SMA) with Universal Cache
• Preparing applications for use with Universal Cache
•  Performance tuning and monitoring
  • Factors impacting Universal Cache performance
  • Monitoring performance
•  SQL passthrough
  • Principles of operation
  • Considerations for developing applications with SQL passthrough access rights
  •  Configuring and using SQL passthrough
    • Setting up SQL passthrough
    • Setting and modifying SQL passthrough mode
    • Tracing and monitoring SQL passthrough
  • SQL passthrough and High Availability
  • SQL passthrough failure handling
•  Data aging
  • Principles of operation
  • Using data aging
•  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
•  Failure handling in Universal Cache
  • 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
  • Backend server or backend node fails
  • Backend primary server fails
• Troubleshooting
•  IBM InfoSphere CDC for solidDB® reference
  •  About IBM InfoSphere CDC
    • IBM InfoSphere CDC for solidDB® system 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
    • dmendreplication: End replication
    • dmrefresh: Refresh subscription
    • dmstartmirror: Start mirroring
  •  Database transaction log commands
    • dmdecodebookmark: Display verbose bookmark information
    • dmsetbookmark: Set bookmark
    • dmshowbookmark: Display bookmark information
    • dmshowlogdependency: Show log dependency
  •  Exporting and importing configuration commands
    • dmexportconfiguration: Export IBM InfoSphere CDC configuration
    • dmimportconfiguration: Import IBM InfoSphere CDC configuration
  •  Managing tables for replication commands
    • dmdescribe: Describe source tables
    • dmflagforrefresh: Flag for refresh
    • dmmarktablecapturepoint: Mark a table capture point on a source table
    • dmpark - Park table
    • dmreaddtable: Update source table definition
    • dmreassigntable: Update target table definition
    • dmsetreplicationmethod: Set replication method
  •  Monitoring replication commands
    • dmclearevents: Clear events
    • dmgetsubscriptionstatus: Get subscription status
    • dmshowevents: Display IBM InfoSphere CDC events
  •  Other commands
    • dmbackupmd: Backup metadata
    • dmconfigurets: Configure IBM InfoSphere CDC
    • dmmdcommander
    • dmmdconsole
    • dmclearstagingstore: Remove cached operations from the staging store
    • dmgetstagingstorestatus: Retrieve staging store status
    • dmenablecontinuouscapture: Enable continuous capture
    • dmdisablecontinuouscapture - Disable continuous capture
    • dmset: Set IBM InfoSphere CDC system parameter
    • dmsetaccessserverparams: Set Access Server parameters
    • dmshowversion: Show IBM InfoSphere CDC version
    • dmshutdown: Shut down IBM InfoSphere CDC
    • dmsupportinfo: Collect support information
    • dmterminate: Terminate IBM InfoSphere CDC processes
    • dmts32: Start IBM InfoSphere CDC
    • dmts64: Start IBM InfoSphere CDC
  •  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
    • Sample user exits for IBM InfoSphere CDC
    • 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
• Log Reader parameters
• SQL passthrough parameters
• ODBC data type support in SQL passthrough
• ODBC driver connect string: Formatting rules