Level: Intermediate Paul Read (paul_read@uk.ibm.com), Product Introduction Manager, βetaWorks, IBM
04 May 2009 In Part 2 of this two-part
series,
set up IBM® solidDB® Universal Cache with IBM DB2® for
Linux®, UNIX®, and Windows® to accelerate access to data.
Learn about system and environment requirements and ways to acquire IBM
solidDB Universal Cache code. Learn also how to install, configure, and use
the IBM solidDB Universal Cache solution.
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.
About this series
This tutorial is the second part of a two-part
series.
The
first
installment
explained the architecture and setup of IBM solidDB Universal Cache
with DB2 for Linux, UNIX, and Windows.
About this tutorial
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.
Objectives
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.
Prerequisites
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.
System requirements
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.
| 
