Before you start
The introduction of IBM solidDB 6.3 Universal Cache provides you with the ability to accelerate access to IBM DB2 and IBM Informix® Dynamic Server (IDS) databases, as well as Oracle, Microsoft SQL Server, and Sybase, increasing their performance up to ten times. When storing performance-critical data from one of the supported disk-based databases into solidDB's in-memory cache, applications can access data with extreme speed because it is always kept in the computer's memory, rather than on disk. With IBM solidDB Universal Cache, both existing and new applications can now generate data workloads of more than 120,000 transactions per second and safely rely on predictable response times measured in microseconds to support growing numbers of users and data volumes, allowing companies to quickly unlock the business value of their data, which is what Information on Demand is all about.
In this tutorial, set up IBM solidDB Universal Cache with DB2 for Linux, UNIX, and Windows (DB2) to accelerate access to data. This tutorial assumes that you already have DB2 installed. This tutorial uses a simple application to demonstrate the basic principles of the Universal Cache and the synchronization of data with the back-end database. For the replication element of this tutorial to work, the DB2 database must be in logretain mode.
You will need to get a licensed copy of the IBM solidDB Universal Cache 6.3 code. Business Partners and ISVs can utilise the IBM PartnerWorld Software site to get up to speed with detailed product information, software downloads, and service options (see Resources). Customers can use the Trials and demos Web page to download a trial version (see Resources).
The InfoSphere CDC Management Console (part of the IBM solidDB Universal Cache solution) is a Windows application. However, because the exercises for this tutorial were performed using a SUSE Linux Enterprise Server V10, we have used the "Wine" emulator within the operating system to install and run the console to simplify the tutorial. This is not a supported architecture, and for normal operations, the CDC Management Console would be installed on a separate workstation.
This tutorial will take you through the steps to:
- Install the component parts of the solution
- Configure a basic bidirectional replication solution
- Demonstrate the effects of the solution using a simple application
Figure 1, below, shows the basic architecture and components of an IBM solidDB Universal Cache solution, including the InfoSphere Change Data Capture (CDC) technology:
Figure 1. IBM solidDB Universal Cache architecture
Figure 1 is intended to assist you with the installation and configuration steps by providing a pictorial description of the processes.
The key elements of the architecture include:
- IBM solidDB: The front-end database or cache.
- RDBMS: The back-end database used for replication.
- InfoSphere CDC: The replication tool that allows you to replicate data between the cache and the RDBMS.
- InfoSphere CDC Access Server: The server that manages the replication processes for the cache and the RDBMS.
- InfoSphere CDC Management Console: A GUI application used to configure, manage, and monitor the replication processes.
Note: In this tutorial, all components are installed on the same computer.
In this tutorial, you will learn about system and environment requirements, the ways to acquire IBM solidDB Universal Cache code, and how to install, configure, and use the IBM solidDB Universal Cache solution. This tutorial includes a simple application written using IBM Data Studio Developer that demonstrates the abilities of the cache to synchronise and manage the data movement between the cache and the back-end database.
This tutorial is written for relational database professionals whose skills and experience are at a beginning to intermediate level. You should have a general familiarity with using a UNIX command-line shell and a working knowledge of the SQL language and database administration.
To run the examples in this tutorial, you need a Linux environment or vmware image with at least 1GB of memory, 1GB of free disk space, root access on the Linux box (or a sympathetic admin), and an installed DB2 database environment or the ability to create a DB2 for LUW environment. The tutorial assumes that you have created the userid called "solid" to manage and control the IBM solidDB Universal Cache environment.
The InfoSphere CDC Management Console will be installed in "Wine" to contain the whole exercise within the Linux environment. For details on Wine, see the WineHQ Web site (see the Resources section for a link). You should install Wine before you start. Some distributions of Linux may include a variant of Wine.