SQDR Plus Technical Documents

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

Quick Start Guide to Using SQDR Plus v4
Article # SQV00PU006
This multi-part guide describes how to install and configure SQDR Plus v4 to perform incremental data replication operations using SQDR and the StarSQL ODBC driver.
SQDR Plus Product FAQ
Article # SQV00PL013
This document contains frequently asked product questions and answers for SQDR Plus (4.0 and later).
SQDR Plus Technical FAQ
Article # SQV00PL019
This document contains frequently asked technical questions and answers for SQDR Plus (4.0 and later).
SQDR Plus v4 Documentation Updates
Article # SQV00PL009
This document contains documentation updates for the SQDR Plus v4 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 (4.0 and later).
 

DB2 for i Source

 
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.
SQDR Plus v4 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 v4 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.
DB2 for LUW (Linux, UNIX, & Windows) Source
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 # SQV00PL0288
This document documents the resources and API's used by SQDR and SQDR Plus when accessing an IBM DB2 forLUW database.
 
Microsoft SQL Server Source
 
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 User Authorities
Article # SQV00PL039
This document describes the authorities needed by SQL Server accounts used by SQDR Plus and how to configure those accounts in restricted environments using GRANT.
Oracle Source
 
SQDR Plus:Tips for Oracle Replication
Article # SQV00PL022
This document contains tips and troubleshooting hints when using SQDR Plus for incremental data replication 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.
MySQL Source
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.
Informix Source
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.

 

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.
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.
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.
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.
Updating from IBM DB2 Express-C to DB2 Express
Article # SQV00PL016
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 from DB2 Express-C to DB2 Express.
Updating from IBM Db2 10.5 to Db2 11.1
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 from Db2 Express 10.5 to Db2 Workgroup 11.1. Using Db2 11.1 is recommended when replicating from a Db2 11.1 source system.
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
Deleting an SQDR Plus Staging Agent
Article # SQV00PL011
This document describes the recommended procedure for deleting an SQDR Plus Agent.
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.
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 ugrading 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.
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.
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 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.
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.
 
Using SQDR Plus with the IBM DB2 Virtual Appliance
Article # SQV00PL012
(deprecated) This document describes how to obtain and configure the IBM DB2 Express-C Virtual Appliance (a ready-to-run Linux VMWare or KVM virtual machine) for use with SQDR Plus.
 

The following SQDR Plus Technical Documents also provide tips for the legacy product SQDR Plus Classic (SQDR Plus v3):

 
Quick Start Guide to Using SQDR Plus for iSeries with the StarSQL ODBC Driver
Article # SQV00PL001
This guide describes how to install and configure SQDR Plus for iSeries to perform incremental replication operations using SQDR and the StarSQL ODBC driver.
Quick Start Guide to Using SQDR Plus for iSeries with iSeries Access
Article # SQV00PL002
This guide describes how to install and configure SQDR Plus for iSeries to perform incremental replication operations using SQDR and the IBM iSeries Access ODBC driver.
Quick Start Guide to Using SQDR Plus for UDB on Windows
Article # SQV00PU001
This guide describes how to install and configure SQDR Plus for UDB on a Windows host computer and perform perform incremental replication operations using SQDR
Quick Start Guide to Using SQDR Plus for UDB on Linux/UNIX
Article # SQV00PU002
This guide describes how to install and configure SQDR Plus for UDB on a Linux or UNIX host computer and perform perform incremental replication operations using SQDR.
How to Query SQ_STATISTICS to Determine Lag Time on the Host
Article # SQV00PL005
The SQDR Plus software maintains a table called SQ_STATISTICS which stores statistical data related to the operation of the software. It may be useful to query this table to evaluate the performance of the software on the host database.
Best Practices for Restoring or Migrating a Database Monitored by SQDR Plus for iSeries
Article # SQV00PL003
This document describes a technique that will help minimize the processing required after restoring or migrating a database that is being monitored by SQDR Plus for iSeries.
SQDR Plus for iSeries Failover Procedures
Article # SQV00PL006
This document describes the proper procedures to migrate from one source database to another, without requiring that SQDR run baseline replications for the incremental subscriptions.
Changing the Installer User for SQDR Plus for iSeries
Article # SQV00PL007
This document describes how to perform an update of SQDR Plus for iSeries using a user ID other than the user ID that performed the original installation.
Best Practices for Restoring or Migrating a Database Monitored by SQDR Plus for UDB
Article # SQV00PU003
This document describes a technique that will help minimize the processing required after restoring or migrating a database that is being monitored by SQDR Plus for UDB.
Migrating SQDR Plus Subscriptions from a Test Environment to a Production Environment
Article # SQV00PL004
This document provides instructions on how to migrate SQDR Plus incremental replication subscriptions from a test environment to a production environment.
Installing SQDR Plus for UDB for Multiple Databases
Article # SQV00PU004
This document describes a technique to install SQDR Plus for UDB to handle multiple databases residing on the same host system by installing multiple independent copies of SQDR Plus for UDB.