StarQuest Technical Documents
Quick Start Guide to Using SQDR Plus for DB2 UDB on Linux/UNIX
Last Update: 15 April 2008
Product: SQDR Plus for DB2 UDB
Version: 3.3 or later
Article ID: SQV00PU002
Abstract
This Quick Start
Guide provides streamlined procedures to help you quickly set up an environment
for performing incremental replication operations using SQDR Plus for UDB. It describes
how to install and configure SQDR Plus on a DB2 UDB platform that is running a
Linux or UNIX operating system, how to install and configure SQDR on a Windows platform,
and how to install and configure the StarSQL ODBC driver to access the host DB2
system. The procedures include instructions for configuring connections to the
DB2 UDB host (source), SQDR (control), and the target (destination) databases,
and for creating a subscription using the SQDR Replication Manager.
The first part of this guide focuses on preparing the DB2 UDB
host, and the second part describes how to prepare a Windows computer and
define and run an SQDR replication operation. The estimated time to complete
all tasks is approximately 1 hour 10 minutes, as summarized below.
Part One (on the DB2 UDB host): approximately 30 minutes
Step 1:
Pre-installation Tasks. (estimated time: 20 minutes)
Step 2: Install the SQDR Plus Software. (estimated time: 10 minutes)
Part Two (on the Windows client): approximately 40 minutes
Step 1: Install the StarSQL ODBC Driver.
(estimated time: 5 minutes)
Step 2: License the StarQuest Products. (estimated time: 5 minutes)
Step 3: Create DBMS Data Source. (estimated time: 5 minutes)
Step 4: Start the SQL Server Service.
(estimated time: less than 5 minutes)
Step 5: Install and Configure the StarQuest Data Replicator Software. (estimated time: 10
minutes)
Step 6: Start the Data Replicator Manager and Create
a Subscription. (estimated time: 10 minutes)
Step 7: Review the Subscription Status.
(estimated time: less than 5 minutes)
Solution
The following sections guide you through the steps that are
summarized in the preceding Abstract. The steps in Part One prepare the UDB
host computer and install the SQDR Plus software, and the steps in Part Two are
performed on a Windows-based computer that has TCP/IP connectivity to the
target UDB host computer.
Before
You Begin
Before you begin, review the following list to ensure that you
have the information and files you need, and that your computer environment
provides the minimum requirements. You cannot successfully complete the
procedures in Part One or Two until these requirements are met.
General Requirements
- You have requested and downloaded evaluation copies of the
StarSQL, SQDR, and SQDR Plus software. All software packages are distributed as
compressed files that you download from the StarQuest Ventures Web site. From a
browser enter the address http://www.starquest.com/ and select Download for Trial from the Products menu if the prerequisite software has not been
downloaded. Request the download of SQDR Plus on the UDB platform to get
bundled download instructions for all the required StarQuest products,
including StarSQL, SQDR, and SQDR Plus for UDB.
- You have the Download Instructions that were sent to the email
address specified in the StarQuest Product Download Request form. You need
these instructions and Internet access to license the software.
DB2 UDB Host Computer Requirements
- Verify that you can access the DB2 command line processor (CLP):
- Run db2profile (sh/ksh) or db2cshrc (csh) in the sqllib directory of the
instance owner, such as shown below.
sh/ksh |
$ ./home/db2inst1/sqllib/db2profile
# . db2profile |
csh |
% source /home/db2inst1/sqllib/db2cshrc
# source db2cshrc |
- Enter the command db2. If the
db2 command fails, edit the PATH environment variable to include the directory
in which DB2 is installed.
- Verify that the DB2 UDB server software has been installed on the
host computer and that it is version 8 with FixPak 10 or later, or version 9.1
or later. You can use the db2level command to display the Release, Level, and information tokens of the DB2
instance. For example, a typical result of running the db2level command on a Linux/UNIX computer
that has DB2 UDB v9 installed would be:
DB21085I Instance
"db2inst2" uses "64" bits and DB2 code release "SQL08027"
with level identifier "03080106".
Informational tokens are "DB2
v8.1.3.128", "s061108", "MI00180", and FixPak
"14".
Product is installed at
"/opt/IBM/db2/V8.1".
DB2 UDB Host Computer Java Requirements
- Ensure that the DB2 UDB computer where you will install SQDR Plus
has a Java Virtual Machine (JVM) v1.4 or later installed and specified in the
system PATH.
- Type java -version at the
command line to display the active Java version. If you are installing SQDR
Plus on Solaris or HP-UX, issue the following command to verify that you have a
64-bit mode of Java available before you begin the installation.
java -d64 -version
- If the Java version is not returned, or is earlier than v1.4, download
the JVM software from the IBM developerWorks Web site or, if you are running
Solaris or HP-UX, from the Sun Microsystems or Hewlett-Packard Web site,
respectively.
- If you have more than one version of Java installed, verify that
DB2 UDB is configured to use the correct version of the Java Development Kit
(JDK).
- Enter the following command in the DB2 command window and look for the Java
Development Kit installation path field, JDK_PATH:
db2 get dbm cfg
- If you need to set the JDK_PATH value to the correct location of the JDK
or JVM, enter the following on the DB2 command window, replacing the path as necessary
with the location where Java is installed on your computer.
db2 update dbm cfg using JDK_PATH /home/db2inst/jdk14
- If the server computer supports both 32-bit and 64-bit instances
(AIX, HP-UX, or Solaris) use the JDK_64_PATH configuration parameter instead of
the JDK_PATH parameter. The JDK_64_PATH parameter specifies the directory under
which the 64-bit version of the JDK is installed.
- If you change the JDK_PATH parameter, enter the following commands in a
DB2 command window to stop and restart the DB2 instance so the change takes
effect.
db2stop
db2start
Setting Up the Java Environment [HP-UX Only]
To run Java stored procedures on an
HP-UX computer with a 64-bit database instance you need to use the db2hpjv tool
to enable Java routine support, which is disabled by default.
- Enter the following commands on the command line to enable support for
Java stored procedures.
db2hpjv –e
db2stop
db2start
The HP-UX run-time linker must be able to access Java shared
libraries, and the DB2 system must be able to load the shared libraries and the
JVM. The loading program runs with setuid privileges and therefore looks for
the dependent libraries only in /usr/lib/pa20_64. Perform the following step
to specify the location of the Java shared libraries in the configuration file.
- Log
in as root user and add the /opt/java1.4/jre/lib/PA_RISC2.0W and /opt/java1.4/jre/lib/PA_RISC2.0W/hotspot directories to the /etc/dld.sl.conf file.
Setting Up the Java Environment [Linux Only]
To run Java stored procedures, the Linux run-time linker must be
able to access certain Java shared libraries, and DB2 must be able to load both
these libraries and the Java Virtual Machine (JVM). After you ensure that the
JDK and JVM are available, you can add the name of the directory that stores
the Java shared libraries to the /etc/ld.so.conf file.
- Add the Java shared libraries to /etc/ld.so.conf,
and execute the ldconfig command as root user to activate the changes, such as shown
below for 32- and 64-bit instances.
32-bit
Instance:
/opt/IBMJava2-142/jre/lib
/opt/IBMJava2-142/lib
/opt/IBMJava2-142/jre/bin
/opt/IBMJava2-142/jre/bin/classic
ldconfig
64-bit
Instance:
/opt/IBMJava2-amd64-142/jre/lib
/opt/IBMJava2-amd64-142/lib
/opt/IBMJava2-amd64-142/jre/bin
/opt/IBMJava2-amd64-142/jre/bin/j9vm
ldconfig
- Restart DB2 for the changes to take effect.
If you plan to allow SQDR Plus to manage the log files, the
installing user (typically root) must be defined in a group that has authorization to run the DB2 UPDATE CFG
statement. This requires the authorization of SYSADM, SYSCTRL, or SYSMAINT
group.
- Enter the following command in a DB2 command window to determine the
database manager configuration value for the SYSADM_GROUP, SYSCTRL_GROUP, or
SYSMAINT_GROUP.
db2 get dbm cfg | grep [SYSADM_GROUP | SYSCTRL_GROUP |
SYSMAINT_GROUP]
- Edit the etc/group to add the root user
to a group specified in SYSADM_GROUP (a group named DB2GRP1 typically is
created during installation) or to a group in SYSCTRL or SYSMAINT.
- Enter the following commands to restart the DB2 instance so the changes
take effect.
db2stop
db2start
SQL Server (SQDR Platform) Requirements
- The client computer on which you will install SQDR and StarSQL
must have some version of Microsoft SQL Server installed. If you do not already
have a SQL Server installation, you can obtain the Microsoft SQL Server 2000
Desktop Engine (MSDE 2000) or the SQL Server 2005 Express Edition free of
charge from Microsoft to use as a control database for the Data Replicator. The
StarQuest Technical Document "Installing SQL Server for a Control Database" provides
details for using MSDE 2000 or 2005 Express with SQDR.
- Depending on the type of authentication that is configured for
the SQL Server, you must have a SQL Server user ID (if using SQL Server and
Windows authentication) or a Windows user ID (if using Windows-only
authentication) that has permission to access the SQL Server Control Database
that is used by SQDR. This login must be a member of the System Administrators
(sysadmin) fixed server role.
- Your SQL Server user ID (if using SQL Server and Windows
authentication) or Windows user ID (if using Windows-only authentication) also
must have sufficient permissions to perform the replication operations on the
target SQL Server database. If using Windows-only authentication, ensure that
the proper logins have been created for the Windows user account that will
access the target SQL Server database. For more information on SQL Server
Authentication, refer to the Permissions Validation section of Administering SQL Server
documentation (SQL Server 2000) or refer to the Authentication
Mode section in the Installing SQL Server documentation (SQL Server 2005).
- If the SQL Server on which SQDR will be installed will also serve
as the destination database, ensure that incremental replications will be able
to rely on unique fields to identify change data. This requires that the target
database be configured with a Case Sensitive collation sequence. If you
have SQL Server Enterprise Manager (SQL Server 2000) or the SQL Server
Management Studio (SQL Server 2005), you can verify the collation sequence by
viewing the database properties. A case-sensitive collation has the characters
“CS” appended to the Collation Designator. For example, the collation
SQL_Latin1_General_CP1_CS_AS is a case-sensitive collation for U.S. English
systems. You can set the collation for a new database using the SQL Server
Enterprise Manager or the SQL Server Management Studio.
- If you intend to configure replication subscriptions to run
according to a schedule, verify that the SQL Server Agent service is available
and running. (MSDE 2000 includes the SQL Server Agent. SQL Server Express does
not include the SQL Server Agent component; therefore you cannot schedule
subscriptions to run automatically if you use SQL Server Express for the SQDR
control database.
If you have any problem installing or using the evaluation
software, please send an email to StarQuest Customer Support at contact@starquest.com or call
(+1) 415-669-9619 for assistance.
Part One: Prepare the DB2 UDB Host Computer
Total Estimated Time to Complete: 25 minutes
Perform
the following steps only after ensuring that the host computer meets the
requirements specified in the section “Before You Begin.”
You cannot successfully install and use the SQDR Plus software if the host does
not meet the requirements described in this section.
Step 1: Pre-installation Tasks
Estimated Time: 15 minutes
- Log on to the DB2 UDB host computer as a user with root authority. Be sure that you have run db2profile
(sh/ksh) or db2cshrc (csh) as described in “DB2 Host Requirements”
on page 2.
- Determine the current database manager instance by running the command db2 get instance in the DB2 command window. If
this database instance is satisfactory, go to Step 3.
If you wish to change the default instance, view the
available instances using the db2ilist command, and set the DB2INSTANCE environment variable by executing the
db2profile or db2cshrc script in the sqllib directory of the instance owner’s
home directory.
- The SQDR Plus installation will prompt for the host IP and port number
on which DB2 listens for remote connections. The default values for the DB2
host IP and port are 127.0.0.1 (localhost) and 50000. If you are unsure of the
DB2 host IP and port number, you can review this information using the netstat -in command and the DB2 Control
Center, respectively.
To determine the DB2 host IP:
- At the command line execute the command netstat
–in and record the IP Address of the system.
To determine the port number:
- Open the IBM DB2 folder on the desktop and click Control Center, or
enter the command db2cc to start the Control Center.
- Select the database instance and select Setup Communications from the
Object Details pane or the context menu.
- In the Setup Communications dialog, click on the Properties(2) button to
review the properties for the TCP/IP protocol.
- Record the value for the port number.
- As you install SQDR Plus you also must specify a DB2 user name and
password that has access to the DB2 UDB database that SQDR Plus will monitor.
Create this account before you start the installation if it does not already
exist. The DB2 user account needs authority to:
- Connect to the database
- Create tables
- Create packages
- Create and register routines
- Create schemas
- Create external routines
- The database must be configured to use archive logging for SQDR Plus to
access the log files it needs to ensure incremental replication operations are
applied properly. You can use the DB2 Control Center to enable archive logging
for the database before you install SQDR Plus. From the DB2 Control Center
select the database, right-click, and select the Configure
Database Logging command to change the type of logging to Archive.
- This Quick Start Guide assumes that the default configuration values are
used during the installation as they are generally appropriate in most
environments. Make a note of the optional email notification values for your
environment if you want to specify these values during installation. You can
leave these fields blank during the installation and configure the email
notification feature at a later time. Refer to the SQDR Plus for DB2 Universal Database User's Guide for more information about these parameters.
Configuration Parameter |
Sample Value |
Your Value |
SMTP Server: |
mail.mydomain.com |
|
From: |
sqdr@mydomain.com |
|
To: |
sqdradmin@mydomain.com |
|
Notification Level: |
SEVERE |
|
Step 2: Install the
SQDR Plus Software
Estimated Time: 10 minutes
To run the SQDR Plus installer on a Linux or UNIX-based computer
you need to have an X-Windows GUID environment. You can run the installer from
a console, use a VNC connection from a remote computer, or set the DISPLAY
environment variable to point to another UNIX computer that has an X-Windows
environment.
- Copy the DATA1.JAR, media.inf, and setup script
files to the computer on which you want to run the installation.
- Log on to the computer as a user with root authority.
- Create a user ID, such as sqdr, so you
can specify it during the installation process as the user ID under which the
Capture Agent service will run.
- Change to the directory where you copied the SQDR Plus installation
files and execute the setup script to begin the
installation.
- Click Next to proceed with the installation process after the Welcome
dialog appears.
- Click Next once more to proceed to the DB2 connection information
dialog. Select the database on which to install SQDR Plus, and provide the IP,
port, and DB2 User ID as determined in Steps 3 and 4 of the Pre-installation
tasks.
- After you review the License Agreement for using the software, click
Next to accept the terms and proceed with the installation.
- You can accept the default values for most of the installer dialogs.
Enter the configuration parameters noted in the prior section if you want to
configure the email notification feature. When the Capture Agent service pane
appears, enter the user ID that you created in step 3 for the Run As User and
ensure that the service is set to start after the software is installed.
- After you review the installation summary information, click Install to
begin the installation phase, and click Next as the Wizard shows panes with the
task results. If an error is encountered during the installation, back up to
the appropriate installation pane and correct the error.
- When the installation completes, review the capture_agent0.log file, which is located in /var/sqdrplus/<database_name>/conf,
for errors.
Additional References
SQDR Plus for DB2
Universal Database User’s Guide
Part Two: Prepare a Windows Computer
Total Estimated Time to Complete: 50 minutes
All of the procedures in this part are performed from a
Windows-based computer that has TCP/IP connectivity to the UDB computer where
SQDR Plus is installed.
For best results with SQDR, StarQuest recommends using the
StarSQL ODBC driver for access to DB2. However, SQDR does support the use of
the IBM DB2 Connect driver. If you plan to use the IBM DB2 Connect driver with
SQDR, skip Step 1 and proceed with Step 2 below. If you need to replicate LOB
data, in the DB2 Connect data source configuration add the LONGDATACOMPAT
parameter from the Advanced Settings tab of the CLI/ODBC Settings and set this
value to “As LONGVAR data”. Set the Maximum LOB column size value if desired,
or accept the default value.
Step 1: Install the
StarSQL ODBC Driver
Estimated Time: 5 minutes
The StarSQL software is distributed as a compressed file that you
download from the StarQuest Ventures Web site. See the section “Before You
Begin” on page 2 if you have not already downloaded the StarSQL
software.
- To install StarSQL, run the setup.exe program
from the StarSQL installer image.
- Select to perform a Typical installation.
At the end of the installation, a License Configuration dialog prompts
you to enter your license key for using StarSQL. You can enter the license keys
for all the StarQuest products you want to use, as described in the next step.
Step 2: License the
StarQuest Products
Estimated Time: 5 minutes
If you have not already received temporary license keys for the
evaluation software, refer to the Download Instructions that were sent via
email in response to the software evaluation request. The Download Instructions
provide specific instructions for obtaining a license key that allows you to
use the product(s). You can add the license key for multiple products at once,
as described below for adding the StarSQL, SQDR, and SQDR Plus license keys.
- From the Licenses tab of the License Configuration dialog, click Add to display the Add License dialog.
- In the Add License dialog enter the license key for StarSQL and click
the Add button. Repeat this step to enter the license key for SQDR and
SQDR Plus. After you have added the license key for each of the products, click OK in the License Configuration dialog.
Step 3: Create DBMS Data
Source
Estimated Time: 5 minutes
An ODBC data source name (DSN) defines the information that a
driver needs to access a specific instance of data in a DBMS. You must define
an ODBC DSN for each host DBMS that you want to replicate to or from. The
following provides instructions on how to configure a StarSQL ODBC DSN. If you
plan to use DB2 Connect as the ODBC driver, refer to the appropriate IBM
documentation for instructions on how to configure a DB2 Connect DSN.
- Launch the ODBC Administrator from the Windows Control Panel. For most
versions of Windows the ODBC Administrator is typically found in the menu path
Settings—>Control Panel —>Administrative Tools—>Data Sources (ODBC).
- Click the System DSN tab of the ODBC Data Source Administrator window.
Click Add and, in the next dialog, select StarSQL 32 for the driver and click Finish.
- In the first dialog of the StarSQL Data Source Wizard, enter a name for
the data source and, optionally, a description. Click Next to step through the
Wizard panes, specifying values appropriate for your environment. A typical
data source connecting to a UDB server has the following configuration values.
Database Server Name |
Database name (as it appears in the Control Center) |
Package Collection Name |
SQDR |
Host Name |
Network name or IP address of the UDB computer |
Port |
50000 (unless configured differently) |
Catalog Schema |
SYSCAT |
- From the Network pane of the StarSQL Data Source Wizard, click the Test
Connection button to ensure you can connect to the host database. If the
connection fails, modify the data source configuration until the ODBC DSN can
successfully connect to the host.
Additional References
StarSQL Quick Start Guide
StarSQL User’s Guide
StarSQL Online Help
Step 4: Start the SQL
Server Service
Estimated Time: less than 5 minutes
The StarQuest Data Replicator requires a control database in
which to store definitions for sources, destinations, subscriptions, and groups
of subscriptions. If you do not already have a SQL Server installation, you can
obtain the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) or SQL Server
2005 Express Edition free of charge from Microsoft, as further described in the
StarQuest Technical Document "Installing SQL Server for a Control Database.”
The SQL
Server service must be running for the Replicator Service to access its control
database. If you intend to configure replication subscriptions to run according
to a schedule, also start the SQL Server Agent service. Start the SQL Server and
SQL Server Agent services from Windows Services, typically found under Control
Panel—> Administrative Tools—> Services.
NOTE |
The SQL Server 2005 Express Edition does not include the
SQL Server Agent component, which the Data Replicator Manager uses to
schedule subscriptions to run automatically. If you use the free SQL Server 2005
Express Edition as a control database for Data Replicator, you can still use
the Data Replicator Manager to run subscriptions manually and you can use
other methods, such as Windows Scheduler, to schedule them to run
automatically.. |
Additional References
StarQuest Technical Document: Installing SQL Server for a Control Database
Estimated Time: 10 minutes
The StarQuest Data Replicator
software is distributed as a compressed file that you download from the
StarQuest Ventures Web site. See the section “Before You Begin” if you have not already downloaded the SQDR software.
- Run the setup.exe program from the SQDR
installer image.
- At the end of the installation, choose to launch the Data Replicator
Configuration and click Finish.
Configure the Data Replicator Service
You must configure the Data Replicator service to specify which
SQL Server data source to use for the control tables and how the Data
Replicator service should log in to the SQL Server.
- In the first pane of the Configuration Wizard, select the SQL Server
data source that you configured for the Data Replicator control tables and
enter the user ID required to log in to the SQL Server.
Click Next to proceed.

|
If you receive an error that the data source cannot be
found, launch the ODBC Data Source Administrator from Control Panel-->
Administrative Tools-->Data Sources (ODBC), double-click the SQL Server
System DSN, and review the configuration. At the configuration summary verify
that the Test Connection succeeds. Exit the ODBC Administrator and return to
the SQDR Configuration Wizard. |
- Select the option Create a New Control
Database and click Next.
- Choose whether to start the Data Replicator service automatically when
the computer is started or manually when the service is needed, and the Windows
account under which the Data Replicator service will run. Click Finish to save the Data Replicator configuration.
Step 6: Start the Data
Replicator Manager and Create a Subscription
Estimated Time: 10 minutes
You use the Data Replicator
Manager to set up and administer replication operations.
- Select Data Replicator Manager from the StarQuest Data Replicator
program group if it is not already running.
- In the License Configuration dialog, verify that you have a license key
entered with a Product ID of DR and click OK. See “Step 2:
License the StarQuest Products” if you have not entered
license keys for using the evaluation software.
Define a Source
To define the source data that you
want to replicate:
- In the main Data Replicator Manager window, right-click the Sources
folder and select the Insert Source command.
- Select the DSN that connects to the source database that contains the
data you want to replicate, and enter a user ID and password that has
permission to access that database. Click OK to add the source.

- If the source is enabled with SQDR Plus for UDB, SQDR will automatically
detect any available Capture Agent schemas. Click OK to accept the default
Capture Agent schema. We recommend that you supply a Notification Address
(hostname or IP address) of the computer that you want to receive a UDP
notification when changes are committed to this source.
The
drop down menu lists the IP addresses of all active network connections.
Usually one of the listed values is best; in the case of multiple subnets use
the same subnet as the UDB host. If NAT is being used and the IP address known
to the host is different than the local address, use the external address that
the UDB host uses to communicate with the SQDR computer.

Define a Destination
Now define the destination that
will receive the replicated data.
- Right-click the Destinations folder and select the Insert
Destination command.
- Select the DSN that connects to the database to which you want to
replicate the data, and enter a user ID and password that has permission to
access that database. Click OK to add the destination.

Create an Incremental Group
In this section you create a group in which to place one or more
subscriptions that perform incremental replication operations between the
specified source and destination.
- Right-click the Groups folder and select Insert
Incremental Group. In the Group properties dialog, enter a name for the
Group and an optional description.

- On the Advanced tab, select the Source and Destination that will be used
for each incremental replication subscription in this group. Click OK to add
the group.

Create a Subscription
The Replicator Manager provides a
Subscription Wizard to help you define the specific source data and how you
want to replicate it.
- Right-click the Subscriptions folder beneath the source that you added
and select the Insert Subscription command. The Add Subscription Wizard
appears.
- In the Select the Source pane, select Incremental as the Replication Type and enter a schema or object name if
you want to filter the source objects list. Click the Refresh button to
display the available source objects in the right pane and select the source
object you want to replicate. Click Next to proceed.

- In the Select a Destination pane, select the DSN that connects to the
destination you added to the Replicator Manager. Review the Destination Options
and Replication Options, and click Next to proceed.
- In the Select Group pane select the incremental replication group that
you created earlier. Click Next to continue.

- The Define Criteria pane allows you to specify a SQL WHERE clause in
order to horizontally partition the data to be replicated. Enter a valid WHERE
clause and click the Verify Criteria button, or leave the field blank. Click Next to continue.
- The Define Destination Columns pane allows you to review and change the
data type mappings for the source and destination objects. Modify the
destination columns if desired and click Next.

- Click Next in the Create Table Statement pane. The CREATE TABLE
statement will not appear until the subscription has been saved.
- On the Define Processing pane, enter optional host commands to be
executed before and/or after the data is replicated. Click Next to
continue.
- On the Indexes/Constraints pane, click Refresh to display any
indexes or constraints defined for the source. Select any that you want to
replicate to the destination and click Next.
- Enter a name for the subscription and click Finish.
The subscription is added beneath the Subscriptions folder of the
defined source and to the corresponding group.
Step 7: Review the
Subscription Status
Estimated Time: less than 5 minutes
After you define an incremental replication subscription the Data
Replicator runs a baseline snapshot replication that forms the base against
which incremental changes are tracked. After the baseline snapshot replication
succeeds, the incremental subscription actively monitors the source for
changes. This step shows you how to monitor the status of a subscription and a
group of incremental subscriptions.
- Review the status of the subscription by highlighting the subscription
in the left pane of the Replicator Manager.

- Double-click the replication event, indicated by the
icon,
to view the statistics of the baseline snapshot. If the data did not replicate
successfully, review the error(s) and correct the subscription properties as
necessary.

- Locate the member subscription under Groups, and double-click on the
Replication Event to view the status of the subscription. After the baseline
snapshot operation completes successfully the incremental subscription is
automatically enabled and actively monitoring for changes at the source.

Continuing Your Software Evaluation
This Quick Start Guide was intended to help you install the
StarQuest software and perform a data replication operation as quickly as
possible. Please continue to experiment with the software by adding additional
subscriptions, scheduling replication operations, and performing SQL operations
on data before and/or after it is replicated. As you experiment with the SQDR
Plus and SQDR software, refer to the product documentation for more
information.
- The SQDR Plus
for DB2 Universal Database User's Guide
manual is available as a
PDF file in the SQDR Plus installation image. It provides more detail about
configuring and managing the SQDR Plus Capture Agent.
- The Data Replicator Manager provides an online help system that
provides more information about defining and running replication operations.
Press F1 or click a Help button from the Data Replicator Manager to display the
online help system.
If you encounter any problems while using the evaluation
software, please send an email to StarQuest Customer Support at contact@starquest.com or call
(+1) 415-669-9619 for assistance.