docs.stelodata.com HTML Site Map
Last updated: 2022, October 7
Total pages: 439
docs.stelodata.com Homepage
/
3 pages
Stelo Info Center
Stelo Info Center
www.starquest.com Site Map - Generated by www.xml-sitemaps.com
Products/
2 pages
StarQuest Product Manuals
StarQuest Product Manuals
licensing/
3 pages
StarQuest Product Licensing
Transferring a license for a StarQuest product
Obtaining a License to Use StarQuest Products
sqdr/
5 pages
StarQuest Data Replicator Release Notes
StarQuest Data Replicator System Requirements
https://docs.stelodata.com/Products/sqdr/SQDR_doc_addendum.pdf
StarQuest Data Replicator Release Notes
StarQuest Data Replicator Release Notes
help/
154 pages
StarQuest Data Replicator Help
StarQuest Data Replicator Help
Blank Page
Copyright Information
Additional Copyright Information
Overview of the StarQuest Data Replicator
Data Replicator Components
System Requirements
What's New in This Release
Upgrading from a Prior Release of SQDR
Installing SQL Server for a Control Database
Installing the Data Replicator
Getting Started
Uninstalling the Data Replicator
Using the Replicator Manager
Starting the Replicator Manager
Navigating the Main Window
Icon Legend
Overview of Replication Process
Configuration Tasks
Configuring ODBC Data Sources
Configuring Database Permissions
SQL Server Authentication
Configuring the Replicator Service
Configuring a License
Working with the Replicator Service
Controlling SQL Server Services
Starting the Replicator Service
Changing Replicator Service Properties
Managing Control Database Connections
Add or Remove a Server
Add a Server: Advanced Options
Managing Remote Servers
Working with Sources
Adding a Replication Source
Configuring a Source for Incremental Replication
Using Connection Strings
Deleting a Source Server
Working with Destinations
Managing multiple SQL Server destinations
Adding a Destination
Deleting a Destination
Creating Subscriptions
Defining Incremental Replication Subscriptions
Creating Multiple Subscriptions for Same Source
Selecting the Subscription Source Object
Exporting and Importing Source Objects
Subscription Replication Criteria
Selecting the Subscription Destination
Selecting the Subscription Destination for IR subscriptions
Importing Mapping Scripts
Selecting the Group While Adding Subscriptions
Subscription Columns Properties
Defining Derived Columns
Synchronzing Column Mapping
Creating the Destination Object
Subscription Processing properties
Replicating Indexes and Constraints
Subscription Schedule tab
Naming and Saving a Subscription
Saving Multiple Subscriptions
Creating a Group
Group Properties General tab
Group Properties Advanced tab
Incremental Group Run Order
ALTER Processing
Specifying Commit Limits for Incremental Apply
I/R Subscription Defaults
Incremental Group Schedule
Adding Incremental Subscriptions to a Group
Export/Import Subscriptions
Scheduling Snapshot Groups
Group Props: Adding Member Subscriptions
Running Subscriptions
Managing Connections
Group Details
Subscription Details
Replication Event Information dialog box
Viewing statistics
Filtering the Subscription List
Setting Up Email Notifications
Controlling the Run Order of Subscriptions
Controlling Updates for Incremental Subscriptions
Programmatic replication
Skipping scheduled replications
Pausing Updates for Incremental Subscriptions
Aborting a replication
Resume an interrupted baseline or snapshot
Copying a Subscription
Renaming a subscription
Renaming a Group
Copying or converting IR member
Moving a Member of an Incremental Group
Converting a Member of an Incremental Group
Changing Subscription Properties
Deleting statistics
Deleting Subscriptions and Groups
Troubleshooting Problems
Contacting StarQuest
Obtaining Licensing Information
Mapping Data Types
How to Enable SQDR Logging for an Incremental Replication Subscription
Viewing diagnostic messages
Viewing Windows Events
Menu Commands
About Data Replicator Manager command
Copy/Convert Member of an Incremental Group
Delete command
Delete Statistics command
Destination Properties command
Duplicate Subscription command
Exit command
Help Topics command
Insert Destination command
Insert Group Command
Insert Group Member command
Insert Incremental Group
Insert Source command
Insert Subscription command
Move Member of an Incremental Group
Pause Updates Command
Properties command
Rename Subscription command
Replay Updates
Reset I/R Group
Resume Updates
Run Group from this Point command
Run Group Command
Run Subscription Command
Source Properties command
Start Service Command
Stop Service Command
Stop Group Command
Stop Subscription Command
Subscription Properties command
View Details command
View Filter Items Command
View Large Icons command
View List command
Refresh command
View Replication Event Command
View Small Icons command
View Toolbar command
Update Speed command
Dialogs
Add Columns dialog
Column Properties dialog
Destination Properties Basic tab
Advanced Destination Properties dialog
AS/400 multi member destination options
Duplicate Subscription dialog
Invalid Subscription Warning dialog
Multiple Subscriptions Dialog
New Capture Agent Schema Dialog
sqdr_odbc/
19 pages
https://docs.stelodata.com/Products/sqdr_odbc/ODBCREADME.txt
https://docs.stelodata.com/Products/sqdr_odbc/datadirect-connect-odbc-71.pdf
https://docs.stelodata.com/Products/sqdr_odbc/datadirect-odbc-reference.pdf
https://docs.stelodata.com/Products/sqdr_odbc/redshiftodbcuser.pdf
https://docs.stelodata.com/Products/sqdr_odbc/hiveodbcuser.pdf
https://docs.stelodata.com/Products/sqdr_odbc/informixodbcuser.pdf
https://docs.stelodata.com/Products/sqdr_odbc/mysqlodbcuser.pdf
https://docs.stelodata.com/Products/sqdr_odbc/oracleodbcuser.pdf
https://docs.stelodata.com/Products/sqdr_odbc/postgresqlodbc.pdf
https://docs.stelodata.com/Products/sqdr_odbc/salesforceodbcuser.pdf
https://docs.stelodata.com/Products/sqdr_odbc/sqlserverodbcuser.pdf
https://docs.stelodata.com/Products/sqdr_odbc/ODBC%20for%20Amazon%20Redshift%20v8.0%20readme.txt
https://docs.stelodata.com/Products/sqdr_odbc/ODBC%20for%20Apache%20Hive%20v8.0%20readme.txt
https://docs.stelodata.com/Products/sqdr_odbc/ODBC%20for%20Informix%20v8.0%20readme.txt
https://docs.stelodata.com/Products/sqdr_odbc/ODBC%20for%20MySQL%20v8.0%20readme.txt
https://docs.stelodata.com/Products/sqdr_odbc/ODBC%20for%20Oracle%20v8.0%20readme.txt
https://docs.stelodata.com/Products/sqdr_odbc/ODBC%20for%20PostgreSQL%20v8.0%20readme.txt
https://docs.stelodata.com/Products/sqdr_odbc/ODBC%20for%20Salesforce%20v8.0%20readme.txt
https://docs.stelodata.com/Products/sqdr_odbc/ODBC%20for%20SQL%20Server%20v8.0%20readme.txt
sqdrplus/
6 pages
StarQuest SQDR Plus Release Notes
SQDR Plus system requirements
https://docs.stelodata.com/Products/sqdrplus/SQDRPlus_UDB.pdf
https://docs.stelodata.com/Products/sqdrplus/SQDR_Plus_doc_addendum.pdf
StarQuest SQDR Plus Release Notes
StarQuest SQDR Plus Release Notes
SQDRManager.hlp/
53 pages
SQDR Control Center Help
SQDR Control Center Help
Blank Page
Welcome to SQDR Plus
Copyright Information
Requirements
Connecting to SQDR Manager
Working with the Launch Agent
Adding a Database
Adding a Database (DB2 for LUW Source)
Adding a Database (Microsoft SQL Server Source)
Adding a Database (Oracle)
Adding a Database (Informix Source)
Adding a Database (MySQL/MariaDB/Aurora Source)
Working with a Database
Working with a remote SQDR Plus v3 Agent
Summary View of a Staging Agent
Displaying Subscriptions
Displaying Diagnostics
Configuration
Displaying Statistics
Publishing
RemoteJournaling
Send Logs to StarQuest
Multimember Support
Password Management
Pausing SQDR Plus during host maintenance (DB2 for i source)
Configuring Pruning of Control Tables
Configuration Reference
Source-related Properties by DBMS Type
Technical Notes
Mail Notification
Configuring SSL to DB2 for i Source
Configuring SSL on DB2 for i
Configuring SSL to SQL Server Source
Configuring SSL to MySQL Source
Monitoring Backlogs with the Storage Monitor
Specifying a primary key with SQ_IXLIST
Port Usage
Contacting StarQuest
Configuring Remote Journaling on the DB2 for i Source
Journaling
Autojournaling
Creating Unique Journals
Maintaining Journals and Log Files
Removing the SQDR Plus/iSeries Exit Program
Exit Program Reason Codes (DB2 for i Source)
Recovery
Set Startup Mode
Taking Subscriptions Offline/Online
"quiesce" Shutdown Option
Change Journal Start Position
Maintaining the Order of Transactions
whgdata/
70 pages
starlicense/
5 pages
StarQuest Product Release Notes
StarLicense Server for UNIX Release Notes
https://docs.stelodata.com/Products/starlicense/starlicunix.pdf
StarLicense System Requirements
StarLicense makes it easy to manage licenses for StarQuest products
starpipes/
3 pages
StarPipes for Windows provides access to IBM DB2 hosts
StarPipes for Windows Release Notes
StarPipes System Requirements
starsql/
15 pages
StarSQL System Requirements
https://docs.stelodata.com/Products/starsql/ssqlwin.pdf
StarSQL for Windows Release Notes
https://docs.stelodata.com/Products/starsql/ssqljava.pdf
StarSQL for Java Release Notes
https://docs.stelodata.com/Products/starsql/ssqlunix.pdf
https://docs.stelodata.com/Products/starsql/readlinux.txt
StarQuest Product Release Notes
unixODBC Driver Manager Notes
https://docs.stelodata.com/Products/starsql/ssqlwin56.pdf
StarSQL for Windows Release Notes
https://docs.stelodata.com/Products/starsql/ssqlunix5.pdf
StarQuest Product Release Notes
StarSQL for Java Release Notes
StarAdmin Release Notes
staradmin/
6 pages
StarAdmin: Welcome
StarAdmin: Connecting to a Database
StarAdmin: Binding SQL Packages
StarAdmin: Binding SQL Packages
StarAdmin: Troubleshooting Errors and Warnings
StarAdmin: Contacting StarQuest Ventures
Supportdocs/
4 pages
Index for StarQuest Quick Start Guides
StarQuest FAQ's
Technical Documents by Product
redirect to new StarQuest home page
techSQDR/
50 pages
SQDR Frequently Asked Questions
Index to SQDR Technical Documents
Installing SQL Server for a Control Database
Using SQDR for Limited Incremental Replication from SQL Server (Advanced)
How to Automatically Pause and Resume an SQDR Incremental Replication Group
Using SQDR Key Logging Data
How to Enable SQDR Logging for an Incremental Replication Subscription
Index to SQDR v6 Technical Documents
Troubleshooting SQDR Installation and Configuration Issues
Troubleshooting SQDR Usage Issues
SQDR: Recommended ODBC Drivers
Upgrading SQDR & SQDR Plus
Upgrading to 64-bit SQDR
Migrating SQDR control database from SQL Server to DB2 LUW
SQDR Advanced Settings
Quick Start Guide to Using the StarQuest Data Replicator
Configuring SQDR with an Existing Control Database
Creating a Secure, 2-Tier SQDR Environment
How to Avoid a Baseline Replication after Source Table Schema Change
SQDR Using Truncate to Minimize Logging Activity for DB2 Targets
SQL Server Authentication Considerations
Cloning SQDR Subscriptions
Using SQDR for Limited Incremental Replication from SQL Server
Replicating DB2 Date and Time Data Types to the SQL Server Datetime or Smalldatetime Data Types
Improving SQDR Performance
SQDR Technical Document: Login failed for user 'sa'
Preserving Non-Unique Indexes
Error Replicating Text or Image Data to SQL Server
Replicating Oracle DATE Data Types to DB2 DATE Data Types
Derived Columns Hints
SQDR 5.x: Programmatic control
How to Configure a Notification Alert for an SQDR Replication Event
SQDR and Temporal Tables
SQDR - Partition Key for Many-to-One Replication
SQDR: CSV to ADLSg2
SQDR Change Data Processing
Using the SQDR Kafka Producer
SQDR and Amazon Managed Streaming for Kafka
Change Data Procesing - Java example
SQDR ir_keylog table
Transferring SQDR Control Database Information to Files
Troubleshooting Replicator Service Exceptions
Collecting Information for StarQuest Technical Support
SQDR/Linux Quick Start Guide
Upgrading to SQDR v6
Using PowerShell with SQDR
Using SQDR Streaming Support
Using SQDR Streaming with Azure Databricks
Upgrading from a Prior Release of SQDR
Upgrade Considerations for SQDR 4.5
scripts/
1 pages
https://docs.stelodata.com/Supportdocs/techSQDR/scripts/GetSubscription.cs
techSQDRPlus/
81 pages
Quick Start Guide to Using SQDR Plus v4
Quick Start Guide to Using SQDR Plus on Windows (Part 2)
SQDR Plus Frequently Asked Questions
SQDR Plus Technical Documents
Quick Start Guide to Using SQDR Plus on Windows with IBM Db2 for i (Part 1)
Quick Start Guide to Using SQDR Plus on Windows with IBM Db2 for LUW (Part 1)
Quick Start Guide to Using SQDR Plus on Windows with Microsoft SQL Server (Part 1)
Quick Start Guide to Using SQDR Plus on Windows with Oracle (Part 1)
Quick Start Guide to Using SQDR Plus on Windows with Informix (Part 1)
Quick Start Guide to Using SQDR Plus on Windows with MySQL (Part 1)
Quick Start Guide to Using SQDR Plus on Linux with IBM DB2 for i (Part 1)
Quick Start Guide to Using SQDR Plus on Linux with IBM Db2 for LUW (Part 1)
Quick Start Guide to Using SQDR Plus on Linux with Microsoft SQL Server (Part 1)
Quick Start Guide to Using SQDR Plus on Linux with Oracle (Part 1)
Quick Start Guide to Using SQDR Plus on Linux with Informix (Part 1)
Quick Start Guide to Using SQDR Plus on Linux with MySQL (Part 1)
Quick Start Guide to Using SQDR Plus on Windows (Part 2)
Quick Start Guide to Using SQDR Plus on Windows (Part 2)
Quick Start Guide to Using SQDR Plus on Windows (Part 2)
SQDR: Postgres Tips
SQDR Plus Technical Frequently Asked Questions
SQDR Plus V4 Documentation Updates
Case Study: Troubleshooting Slow Replication - rollback
Case Study: Troubleshooting - memory overcommitted
SQDR: Security Best Practices
SQDR: TCP KeepAlive
SQDR Plus on AIX
SQDR Plus: Tips for Db2 for i Replication
SQDR Plus: Tips for Db2 for i journaling
SQDR Plus IBM i User Authorities
SQDR Plus: Creating an IBM i subsystem
SQDR Plus OS/400 Resource Utilization
SQDR Plus IBM i CL setup scripts
Using SQDR Plus with IBM iASPs
SQDR Plus IBM i High Availability Role Swap
SQDR Plus: Tips for Db2 LUW Source
SQDR Plus DB2 LUW Resource Utilization
SQDR Plus:Db2 LUW Log Reader Stored Procedure
SQDR Plus: Tips for SQL Server Replication
SQDR Plus: SQL Server CDC
SQDR Plus SQL Server User Authorities
SQDR SQL Server Performance
SQDR Plus: Tips for Oracle Replication
SQDR Plus Oracle User Authorities
SQDR Plus: Managing Oracle Log Files
SQDR Plus: Oracle XStream support
SQDR Plus: Oracle XStream Licensing
SQDR Plus: Locating Oracle Patches
SQDR Plus: Oracle XStream Recreate Outbound Server
SQDR Plus: Oracle XStream Diagnostics
SQDR Plus: Tips for MySQL Source
SQDR Plus: Tips for Informix Source
SQDR Plus Informix Resource Utilization
SQDR: Salesforce Tips
SQDR Plus DB2 LUW Hints
DB2 LUW Storage Maintenance
SQDR Plus Tier 2 UserID Considerations
SQDR Plus: DB2 Activate script
SQDR Plus: Db2 Cleanup
Installing Db2 LUW
Reinstalling Db2
Updating to IBM Db2 11.5.5
Updating to IBM Db2 11.5.7
SQDR Plus: SSL for Db2 LUW
Creating a Custom Db2 LUW staging database
SQDR Plus Derby Hints
SQDR Plus: SSL for Jetty (SQDR Control Center)
Deleting an SQDR Plus Staging Agent
SQDR - Using Tablechecker
SQDR Plus: Cleanup Unused Groups
SQDR and SQDR Plus: Migrating to a new server
SQDR Plus: Migrating to a new server
Reinstalling SQDR Plus
SQDR and SQDR Plus: Partitioned Snapshots
SQDR Plus: Distributed Network Examples
Preparing IBM i for use with SQDR Cloud Services
Configuring SQDR Cloud Services
SQDR: configuring SSL
SQDR Plus: Windows Failover Cluster
SQDR and SQDR Plus: Migrating to a new server
SQDR Plus: Distributed Network Examples
PDF/
1 pages
https://docs.stelodata.com/Supportdocs/techSQDRPlus/PDF/IBM_DB2_Cluster_0301nomani.pdf
scripts/
3 pages
https://docs.stelodata.com/Supportdocs/techSQDRPlus/scripts/PROD_EXPC.rsp
https://docs.stelodata.com/Supportdocs/techSQDRPlus/scripts/PROD_SERVER.rsp
https://docs.stelodata.com/Supportdocs/techSQDRPlus/scripts/ControlDB.txt
techSQDR400/
1 pages
Migrating SQDR Plus Subscriptions from a Test Environment to a Production Environment
techSQDRUDB/
5 pages
Quick Start Guide to Using SQDR Plus Worksheet
Quick Start Guide to Using SQDR Plus (Part 2)
SQDR Plus Troubleshooting Tips
Using SQDR Plus for Bidirectional Synchronization
redirect to the new StarSQL product page
techStarLicense/
10 pages
Quick Start Guide to Using StarLicense for UNIX
Quick Start Guide to Using StarLicense for Windows
Index to StarLicense Technical Documents
How to Add StarLicense to the Boot Process
Configuring TCP KeepAlive Parameters
How to Configure a Failover StarLicense Server
StarLicense Licensing Recommendations
StarLicense Troubleshooting
StarLicense/UNIX: Non-root user
StarLicense: Using starlic-remote-admin
techStarPipes/
4 pages
Quick Start Guide for StarPipes for Windows
StarPipes for Windows Frequently Asked Questions
Index to StarPipes Technical Documents
How to Generate DRDA and Debug Traces Using StarPipes
techStarSQL/
1 pages
Index to StarSQL Technical Documents
StarSQLJDBC/
16 pages
Quick Start Guide to Using the StarSQL for Java JDBC Driver
Logging StarSQL for Java Activity
Sending Client Information to DB2 for OS/390 and z/OS using StarSQL for Java
Using StarSQL for Java to Access DB2 from an Oracle Stored Procedure
How to Report a StarSQL for Java Problem
Using StarSQL for Java with Websphere Application Server
Using StarSQL for Java with Websphere Community Edition and Apache Geronimo
Using StarSQL for Java with Oracle WebLogic
Using StarSQL for Java with ColdFusion
Using StarSQL for Java with IBM Data Studio
Using StarSQL for Java with DbVisualizer
Using StarSQL for Java with DBeaver
Silent Installation of StarSQL for Java
StarSQL for Java Licensing
StarSQL for Java Troubleshooting
https://docs.stelodata.com/Supportdocs/techStarSQL/StarSQLJDBC/SJ003_StarSQLforJavaToOracleCode.txt
StarSQLODBC/
HostConfiguration/
6 pages
Enabling DRDA over TCP/IP for OS/400 v4r2 and later
AS/400 iSeries tuning tips to improve performance when using StarSQL
Preventing Users from Creating Packages in DB2/400
Creating Restricted Views in DB2 for z/OS
How to Return Result Set Column Names from a DB2 Stored Procedure
StarSQL User Requirements for Dynamic SQL Catalog Queries
Installation/
12 pages
Quick Start Guide to Using the StarSQL ODBC Driver for Windows
Quick Start Guide to Using the StarSQL ODBC Driver for UNIX
Binding StarSQL Packages Using StarAdmin
Upgrade Considerations for StarSQL 6.1 & Later
How to Bind Packages with StarAdmin Classic
StarSQLJumbo Packages
How to Distribute StarSQL Data Source(s) to Your Users
Silent Installation of StarSQL
Creating a Custom StarSQL 5.x/6.0 Installable Image
Deploying a Silent Installation of StarSQL using Microsoft Systems Management Server (SMS)
Linux Prerequisites for StarSQL & StarLicense
How to Resolve InstallShield Error 1607: Unable to Install InstallShield Scripting Run Time
Internationalization/
2 pages
StarSQL Character Conversion and National Language Support
Error: CCSID 500 is invalid or not supported
Programming/
17 pages
Sample Visual Basic 6.0 ADO Code to use RecordCount property for an ADO Resultset
Sample Visual Basic ADO Code to Issue a SELECT to a DB2 Host Binding a Parameter
Using Visual Basic for Applications (VBA) and ADO with StarSQL
Sample Visual Basic ADO Code to Access Static SQL
Sample Code: ASP Script for use with Microsoft IIS
Using a DSN-less Connection with StarSQL
How To Execute DB2 SQL Parameterized Stored Procedures from a Visual Basic .NET Application Using StarSQL
How To Execute a DB2 Query from a Visual Basic .NET Application Using StarSQL
How To Execute a DB2 Query from a C# .NET Application Using StarSQL
Using VBScript and OLEDB with StarSQL
Using PowerShell with StarSQL
Using StarSQL with the Perl DBI Module
Using StarSQL with PHP and php-odbc
Using StarSQL with PHP and PDO to Execute Stored Procedures
Sample ADO Code to Call a Stored Procedure and Return Output Data
Sending Client Information to DB2 for z/OS & DB2 UDB Using the StarSQL ODBC Driver
https://docs.stelodata.com/Supportdocs/techStarSQL/StarSQLODBC/Programming/CSharpSample.cs
ThirdPartyApplications/
15 pages
How to Use a Microsoft SQL Server Linked Server to Access DB2 with StarSQL
How to Use a StarSQL Data Source in a SQL Server 2005/2008 SSIS Package
Considerations for using StarSQL (64-bit) with SQL Server 2005/2008
Using StarSQL and StarSQL for Java with ColdFusion
Using StarSQL with Oracle Database Gateway for ODBC
Using StarSQL with Informatica PowerCenter
Using StarSQL with IBM DataStage
Using StarSQL with Tableau
Using StarSQL with Microsoft Access FAQs
How to Create a SQL Pass Through Query in Microsoft Access
How to Join a DB2 Table and a Local Microsoft Access Table
How to Enable Connection Pooling
StarSQL Workaround For Updating DB2 Tables with Timestamps in Microsoft Access and Visual Basic
Cognos Imprompt returns error when connecting to AS/400: [Microsoft][ODBC Driver Manager] Invalid argument value
Using StarSQL for UNIX with the DataDirect ODBC Driver Manager
Troubleshooting/
6 pages
How to Report a StarSQL for Windows (ODBC Driver) Problem
How to Report a StarSQL ODBC Driver for UNIX Problem
How to Generate an ODBC Trace
How to Generate a DRDA Trace with the StarSQL DRDA Trace Recorder
How to Resolve StarSQL Error: "Invalid section number"
Tips for StarSQL/UNIX
Usage/
14 pages
StarSQL Frequently Asked Questions
StarSQL Technical Frequently Asked Questions
StarSQL Login FAQs
Common StarSQL Error Messages
Calling an AS/400 Program with QCMDEXC
Using StarSQL to Access Multi-Member Files
How to Automate StarSQL Logins
Using the DYNAMICRULES Bind Option With StarSQL
How to Change the Read-Only Attribute of StarSQL
SSL Hints for StarSQL and StarPipes on Windows
SSL Hints for StarSQL/UNIX
Error: Connection refused by remote host or Connect Host <hostname> not found
StarSQL and IIS FAQ
Sample SQL for Registering a Stored Procedure on the AS/400