Universal Cache User Guide : Tools and utilities
  
Tools and utilities
The solidDB® server and IBM InfoSphere CDC for solidDB® installation packages include tools and utilities for automating and scripting common tasks in the setup and usage of IBM InfoSphere CDC replication technology. For example, the tools and utilities can be used to script creation of IBM InfoSphere CDC instances and subscriptions or automate data aging and refreshes.
The tools are provided as a set of sample applications, scripts, and stored procedures that can be used from the operating system command prompt.
IBM InfoSphere CDC for solidDB® package - tools and utilities
Tool or utility
Purpose
Location
Instance and subscription management tools
dminstancemanager
dmsubcriptionmanager
Command-line utilities facilitating IBM InfoSphere CDC instance and subscription management
<IBM InfoSphere CDC for solidDB® installation directory>\samples\ucutils
ucautomation automation framework (Perl)
Perl-based sample scripts and library modules for automating installation and configuration tasks, including creating datastores, subscriptions, and mappings
<IBM InfoSphere CDC for solidDB® installation directory>\samples\ucautomation
ucdeploy sample application
Sample application to demonstrate how to set up IBM InfoSphere CDC replication using scripting.
<IBM InfoSphere CDC for solidDB® installation directory>\samples\ucdeploy
uchsbmonitor sample script
Sample script for monitoring and restarting a set of subscriptions, for example, in High Availability (HotStandby) configurations
<IBM InfoSphere CDC for solidDB® installation directory>\samples\uchsbmonitor
ucpassthrough sample application
Sample application to demonstrate how to set up IBM InfoSphere CDC replication with the SQL passthrough feature
<IBM InfoSphere CDC for solidDB® installation directory>\samples\ucpassthrough
solidDB® package - stored procedures
Stored procedure
Purpose
Location
Data aging
create_automatic_aging.sql
start_automatic_aging.sql
stop_automatic_aging.sql
Automates aging of data in a solidDB® database based on user-defined aging rules
<solidDB® installation directory>\procedures
Refresh
create_refresh_package.sql
Enables refreshes to be started programmatically from an application, without interacting with an IBM InfoSphere CDC instance
<solidDB® installation directory>\procedures
See also
Perl automation framework
Instance and subscription management tools
SQL stored procedures for data aging and refresh