SQDR Plus Technical Documents

These technical documents provide specific information and tips about using Stelo real time data replication and change data capture solutions.

Quick Start Guide to Using SQDR Plus
Article # SQV00PU006
This multi-part guide describes how to install and configure SQDR Plus to perform incremental data replication operations using SQDR and the StarSQL ODBC driver.
Quick Start Guide to Using the Stelo Replicator Linux Container
Article # SQV00PL076
This guide describes how to install and configure the Stelo Replicator Linux Container.
SQDR Plus Product FAQ
Article # SQV00PL013
This document contains frequently asked product questions and answers for SQDR Plus.
SQDR Plus Technical FAQ
Article # SQV00PL019
This document contains frequently asked technical questions and answers for SQDR Plus.
SQDR Plus Documentation Updates
Article # SQV00PL009
This document contains documentation updates for the SQDR Plus software. Information will be removed when it is migrated to other areas of the documentation
SQDR Plus Hints and Troubleshooting Tips
Article # SQV00PU010
This document contains generic troubleshooting tips for SQDR Plus.
Network Troubleshooting Tips
Article # SQV00PL081
This technical document describes various techniques to troubleshoot network connectivity issues, and is applicable to all products.
Case Study: Troubleshooting Slow Replication (due to Rollback behavior)
Article # SQV00PL065
This technical document describes the steps taken to troubleshoot a throughput issue at a customer site. The cause and solution for this particular incident are rather specific, but the techniques used to identify the cause are useful as an example. Through the investigative methods described, we determined that the cause was a large number of single row rollbacks performed on a particular table by an SQL job on the host, and to recommend a solution.

Case Study: Troubleshooting Failure to start some agents (due to memory overcommitted)
Article # SQV00PL069
A system with large number of agents encountered a problem where some agents failed to start due to memory being overcommitted by a large number of Java processes. This technical document describes the procedure used to diagnose and remedy the problem.
SQDR and SQDR Plus Security Best Practices
Article # SQV00PL052
This technical document contains Security Best Practices tips and suggestions for SQDR and SQDR Plus.
SQDR and SQDR Plus TCP KeepAlive Recommendations
Article # SQV00PL061
This technical document contains TCP KeepAlive recommendations for SQDR and SQDR Plus.
SQDR Plus on AIX
Article # SQV00PL054
SQDR Plus 5.22 & later can be installed on IBM AIX using the QuickStart Guides for SQDR Plus on Linux. This technical note documents the differences between using SQDR Plus on AIX vs Linux.
 

Db2 for i

SQDR Plus:Tips for Db2 for i (IBM iSeries) Replication
Article # SQV00PL032
This document contains tips and troubleshooting hints when using SQDR Plus for incremental data replication from an IBM Db2 for i database.

Tips for Db2 for i Journaling
Article # SQV00PL060
When performing incremental replication from a Db2 for i database, tables to be replicated must be journaled, preferably as *BOTH rather than *AFTER. This technical document contains information about viewing and changing the journaling characteristics of a table using a terminal session, IBM Navigator for i, or SQDR Control Center...

SQDR Plus IBM i User Authorities
Article # SQV00PL010
This document describes the authorities needed by IBM i (OS/400) user accounts used by SQDR Plus and how to configure those accounts in restricted environments using GRANT.
Creating a subsystem for SQDR Plus jobs (Db2 for i source)
Article # SQV00PL040
This document describes how to improve performance when replicating from an IBM Db2 for i source by creating a new subsystem and routing SQDR Plus connections based on the user ID.
SQDR Plus IBM i (OS/400) Resource Utilitization
Article # SQV00PL008
This document documents the IBM i (OS/400) resources, such as host servers and ports, used by SQDR and SQDR Plus when accessing an IBM Db2 for i database.
SQDR Plus IBM i CL Setup Scripts
Article # SQV00PL029
This document describes the StarQuest-supplied CL programs that can be used by an IBM i system administrator to perform the IBM i host setup tasks prior to creating the agent, when data center security policies restrict the use of privileged user accounts in SQDR Manager.
Using SQDR Plus with IBM i IASPs (Independent Auxiliary Storage Pools)
Article # SQV00PL017
This technical document describes the configuration necessary for SQDR and SQDR Plus to access tables located on an IBM i IASP.
SQDR Plus IBM i High Availability Role Swap
Article # SQV00PL030
This technical document describes the recommended procedure to achieve minimal disruption when performing a planned host role swap in an IBM High Availability environment.

Db2 for LUW (Linux, UNIX, & Windows)

SQDR Plus:Tips for Db2 LUW Replication
Article # SQV00PL031
This document contains tips and troubleshooting hints when using SQDR Plus for incremental data replication from an IBM Db2 LUW (Linux, UNIX, & Windows) database.
SQDR Plus IBM Db2 LUW Resource Utilitization
Article # SQV00PL028
This document describes the resources and API's used by SQDR and SQDR Plus when accessing an IBM Db2 for LUW database.
SQDR Plus: Db2 LUW Log Reader Stored Procedure
Article # SQV00PL064
This document describes installing and using the stored procedure for reading the logs of an IBM Db2 for LUW database. This procedure is optional but recommended.
Replicating from Db2 LUW configured as AUTHENTICATION=CLIENT
Article # SQV00PL075
This document describes special configuration for replicating from Db2 LUW configured as AUTHENTICATION=CLIENT.

Replicating from Db2 LUW configured as AUTHENTICATION=DATA_ENCRYPT
Article # SQV00PL084
This document describes special configuration for replicating from Db2 LUW configured as AUTHENTICATION=DATA_ENCRYPT.
 

Microsoft SQL Server

SQDR Plus:Tips for SQL Server Replication
Article # SQV00PL041
This document contains tips and troubleshooting hints when using SQDR Plus for incremental data replication from a Microsoft SQL Server database.
SQDR Plus: SQL Server & Change Data Capture (CDC)
Article # SQV00PL049
This document contains additional tips and troubleshooting hints when using SQDR Plus for incremental data replication from a Microsoft SQL Server database, using Change Data Capture (CDC) rather than Change Tracking (CT).
SQDR Plus SQL Server User Authorities
Article # SQV00PL039
This document describes the authorities needed by Microsoft SQL Server accounts used by SQDR Plus and how to configure those accounts in restricted environments using GRANT.
SQDR SQL Server Performance Tips
Article # SQV00PL058
This technical document provides tips on identifying and correcting performance issues when using Microsoft SQL Server as a destination.

Oracle

SQDR Plus:Tips for Oracle Replication
Article # SQV00PL022
This document contains tips and troubleshooting hints when using SQDR for data replication to or from an Oracle database.
SQDR Plus Oracle User Authorities
Article # SQV00PL018
This document describes the authorities needed by Oracle accounts used by SQDR Plus and how to configure those accounts in restricted environments using GRANT.
SQDR Plus: Managing Oracle Log Files
Article # SQV00PL021
This document describes how an Oracle administrator can determine which log files can be deleted without affecting SQDR Plus incremental replications.
SQDR Plus: Oracle XStream Support
Article # SQV00PL062
This document describes how to use the XStream support of SQDR Plus 5.30 & later in place of LogMiner.
SQDR Plus: Oracle Stream Licensing
Article # SQV00PL071
Special licensing considerations apply when using XStream technology with an Oracle source. This document contains instructions on gathering necessary information about the Oracle source system.
SQDR Plus: Oracle Patches
Article # SQV00PL074
This document describes how to locate and download Oracle patches..
SQDR Plus: Oracle XStream - Recreate Outbound Server
Article # SQV00PL073
This document describes how to recreate the XStream Outbound Server on an Oracle source system.
SQDR Plus: Oracle XStream Diagnostics
Article # SQV00PL072
This document describes how to run and interpret a script that captures XStream diagnostic information on the Oracle source system.
 

MySQL

SQDR Plus:Tips for MySQL Replication
Article # SQV00PL033
This document contains tips and troubleshooting hints when using SQDR Plus for incremental data replication from a MySQL or MySQL-compatible (e.g. MariaDB, Amazon Web Services Aurora) database.
Configuring MySQL SSL Connections
Article # SQV00PL086
This document describes configuring SQDR Plus for secure (SSL/TLS) connections to a MySQL or MySQL-compatible (e.g. MariaDB, Amazon Web Services Aurora) database.
 

Informix

SQDR Plus:Tips for Informix Replication
Article # SQV00PL042
This document contains tips and troubleshooting hints when using SQDR Plus for incremental data replication from an IBM Informix database.
SQDR Plus Informix Resource Utilization & Log Management
Article # SQV00PL045
This document documents the resources and API's used by SQDR and SQDR Plus when accessing an IBM Informix database.

PostgreSQL

Tips for PostgreSQL Replication
Article # SQV00PL053
This document contains tips and troubleshooting hints when using SQDR and SQDR Plus for data replication to and from a PostgreSQL database.
PostgreSQL Resource Utilization
Article # SQV00PL077
This document documents the resources used by SQDR and SQDR Plus when accessing a PostgreSQL database.

Salesforce

Tips for Salesforce
Article # SQV00PL050
This document contains tips and troubleshooting hints when using SQDR for replication to or from Salesforce.

 

Db2 LUW & Derby Staging/Control Databases

Troubleshooting Tips for the SQDR Plus Db2 LUW Staging Database
Article # SQV00PL015
SQDR Plus uses a local IBM Db2 for Linux, UNIX & Windows (Db2 LUW) database as the control and staging database. This technical document provides guidance in working with Db2 LUW as used by SQDR Plus.


Backing up the Db2 control database
Article # SQV00PL079
This document provides guidance on how to perform an offline backup of SQDR and SQDR Plus control & staging databases for recovery purposes in the event of an upgrade, migration, etc.

Restoring a Db2 control database
Article # SQV00PL080
This document provides guidance on how to restore SQDR and SQDR Plus control & staging databases for recovery purposes in the event of an upgrade, migration, etc.

Db2 Archive Logging & Online Backups of Control Databases
Article # SQV00PL085
This document provides guidance on how to configure archive logging and perform an online backup of SQDR and SQDR Plus control & staging databases. It also covers automated tasks.

Db2 LUW Staging Database - Storage Maintenance
Article # SQV00PL059
Over time, the storage used by the SQDR Plus staging database may grow..This technical document provides guidance in reducing the storage used by the Db2 LUW staging database.


Using Db2 HADR with SQDR
Article # SQV00PL082
This technical document describes how to use the high availability disaster recovery (HADR) feature of Db2 LUW to provide a high availability solution for both partial and complete site failures. It can also be used to avoid or minimize downtime during upgrades of hardware, operating system, Db2, or SQDR.

Tier 2 UserID Considerations
Article # SQV00PL055
When configuring the SQDR Plus (tier 2) Platform and its agents, the UserID names db2admin and sqdr are recommended. This technical document describes considerations that apply when you use names other than the recommended names.

Db2 Activate Scripts
Article # SQV00PL034
SQDR and SQDR Plus uses a local IBM Db2 for Linux, UNIX & Windows (Db2 LUW) database as for control and staging databases. Performance can often be improved by activating these databases when Db2 is started. This technical document provides instructions for automatically activating these databases when Db2 is started.
Detecting and Cleaning up Unused Db2 Databases
Article # SQV00PL037
This document describes a script that can be used to detect unused local Db2 databases and generate a script to drop these databases.
Installing Db2 LUW
Article # SQV00PL066
SQDR Plus uses a local IBM Db2 (Db2 for Linux, UNIX & Windows (Db2 LUW)) database as the control and staging database. This document describes installing Db2 on a new system before installing SQDR Plus.
Reinstalling Db2
Article # SQV00PL016
SQDR Plus uses a local IBM Db2 (Db2 for Linux, UNIX & Windows (Db2 LUW)) database as the control and staging database. In most cases, Db2 can be upgraded to a newer version of Db2 without removing it first. However, there are several scenarios where removing Db2 and reinstalling it as a fresh install is recommended; this technical document explains the procedure.
Updating to IBM Db2 11.5.5
Article # SQV00PL035
SQDR Plus uses a local IBM Db2 (Db2 for Linux, UNIX & Windows (Db2 LUW)) database as the control and staging database. This technical document describes upgrading to Db2 11.5.5fp1 from earlier versions of Db2.
Updating to IBM Db2 11.5.7 and later
Article # SQV00PL070
SQDR Plus uses a local IBM Db2 (Db2 for Linux, UNIX & Windows (Db2 LUW)) database as the control and staging database. As of this writing, the current recommended version is 11.5.5fp1. This technical document describes considerations when using 11.5.7 and later.
 
Configuring Db2 LUW for SSL
Article # SQV00PL044
SQDR Plus uses a local IBM Db2 (Db2 for Linux, UNIX & Windows (Db2 LUW)) database as the control and staging database. In addition, Db2 can be used as a gateway to provide indirect access to internal Db2 and Informix servers. This technical document provides details on configuring SSL for Db2 LUW using a self-signed certificate and corresponding configuration changes on the SQDR client.
Creating a Custom Db2 LUW Staging Database
Article # SQV00PL067
SQDR Plus uses a local IBM Db2 (Db2 for Linux, UNIX & Windows (Db2 LUW)) database as the control and staging database. This database is created automatically by the Add Agent Wizard. In rare cases it may be desirable to create the staging database manually - e.g. for replicating from older Db2 LUW source databases that do not use the current default code set of UTF-8. This technical document describes a technique for a creating and using a custom staging database.
 
Troubleshooting Tips for the SQDR Plus Derby Control Database
Article # SQV00PL019
SQDR Plus uses a local Apache Derby database as the control database for the SQDR Plus Launch Agent. This technical document provides guidance in working with Derby as used by SQDR Plus.
 

Jetty (SQDR Control Center)

SQDR Plus: Configuring SSL for Jetty (SQDR Control Center)
Article # SQV00PL036
SQDR uses the Java-based open source project Jetty to implement a web server (the SQDR Control Center) used for configuring and controlling SQDR Plus. By default, the SQDR Control Center uses a self-signed certificate supplied by the jetty project for SSL connections. This technical document describes how to configure the SQDR Control Center to use a third party SSL certificate, using either an internal or a public certificate authority (CA).
 

More Tips

Using TableChecker
Article # SQV00PL046
This document describes describes the use of TargetChecker, a Visual Basic script to verify that the number of rows in the source table match the number of rows in the destination table.
Deleting an SQDR Plus Staging Agent
Article # SQV00PL011
This document describes the recommended procedure for deleting an SQDR Plus Agent.
Cleanup of Unused Groups
Article # SQV00PL051
This document describes how to identify and delete unused (orphaned) groups in SQDR Control Center.
How to Automatically Pause and Resume an SQDR Incremental Replication Group
Article # SQV00DR015
This document explains how to schedule the execution of this script using the Windows Scheduled Tasks facility.
SQDR Plus: Using PowerShell
Article # SQV00PL078
This technical document describes Stelo Capture (SQDR Plus aka Tier 2) tasks that can be controlled programmatically using PowerShell. These tasks include listing, creating, starting, stopping, and deleting the Capture Agents that retrieve change information from source (Tier 1) databases.
Using SQDR Key Logging Data
Article # SQV00DR021
SQDR provides a key logging feature that captures the incremental primary key data replicated to the destination database. This data may be helpful to dictate work flow operations. This document describes how to use SQDR to replicate the newly added records in the key logging table to another SQL Server database and present the data in a user-friendly format.
How to Enable SQDR Logging for an Incremental Replication Subscription
Article # SQV00DR016
This document explains how to enable logging at the level recommended by StarQuest Technical Support, and how to collect the log data after the error condition has been captured.
SQDR and SQDR Plus: Migrating to a New Server
Article # SQV00PL023
This technical document describes the process for moving an existing production SQDR incremental replication environment to a new system and upgrading to the the latest product versions with minimal disruption.
SQDR Plus: Migrating to a New Server
Article # SQV00PL025
This technical document describes the process for moving the tier 2 component (SQDR Plus) of a production incremental replication environment to a new system.
Reinstalling SQDR Plus
Article # SQV00PL068
This technical document describes the process for uninstalling and re-installing the tier 2 component (SQDR Plus)..
Using SQDR Plus for Bidirectional Synchronization
Article # SQV00PU005
This document describes a technique using SQDR Plus to perform bidirectional synchronization between two similar host database systems (Db2 for i, Db2 for LUW, or Oracle).
Using Partitioned Snapshots to baseline a large table
Article # SQV00PL024
This technical document describes a specialized technique that can be used to perform a baseline on a very large volatile table.
Distributed Network Examples
Article # SQV00PL043
This technical document provides several real-world examples of how the SQDR four tier architecture can be used to provide database replication across remote networks.
Preparing IBM i for use with SQDR Cloud Services
Article # SQV00PL026
This technical document describes preparing an in-house IBM i (iSeries) server for incremental replication using StarQuest Data Replicator (SQDR) running on a virtual machine running on cloud service as Microsoft Azure or Amazon Web Services (AWS).
Configuring SQDR Cloud Services
Article # SQV00PL027
This technical document describes configuring SQDR Plus and SQDR on a virtual machine running on a cloud service as Microsoft Azure or Amazon Web Services (AWS), connecting to an in-house IBM i (iSeries) server.
SQDR and SQDR Plus: Configuring SSL
Article # SQV00PL047
This technical document contains an overview and documentation references for configuring SSL (Secure Sockets Layer) for encrypted communication between the various components of StarQuest Data Replicator and source databases.
SQDR Plus: Setting up a Windows Failover Cluster
Article # SQV00PL038
Windows Server Failover Clustering (WSFC) is a feature of the Windows Server platform for improving the high availability (HA) of applications and services. This document describes how to configure Windows, IBM Db2, SQDR Plus, and SQDR to provide high availability for the StarQuest Data Replicator solution.