StarQuest Technical Documents

SQDR Advanced Settings

Last Update: 23 February 2018
Product: SQDR
Version: 4.50 and later
Article ID: SQV00DR039

Abstract

Most service properties are configured using the Windows applications SQDR Configuration or Data Replicator Manager.  However, some optional settings are not available in either application. These settings are documented in the Advanced Settings topic under Reference in the SQDR Help File.

Prior to v4.90 of SQDR, these settings were configurable in Windows registry, and some parts of the documentation may still refer to them as registry settings.

In SQDR 4.90 and later, these settings are now stored in the SQDR control database (either IBM Db2 or Microsoft SQL Server). When updating to SQDR 4.90 & later from earlier versions, it is necessary to run the SQDR Configuration Utility to migrate the existing registry values into the control database.

This document contains technical details on examining and modifying these advanced settings; we recommend making changes with the assistance from StarQuest Support.

Solution:

We recommend using the SQDR Service Properties utility to examine and modify the advanced settings.

The following technical information is provided as background information.

The settings are stored as a single JSON object in the column SVC_PROPS of the SQDRVER control table. A new row is added to this table when the control database is updated to a new schema format; we are interested in the contents of the most recent row.

You can use any query tool (e.g. ODBC Test, IBM Data Studio, DB2 command line, SQL Server Studio, etc) to run this query:

select id,svc_props from sqdr.sqdrver order by version DESC, created DESC

The first row contains the current property settings.

To see and edit the individual properties within the JSON string, copy the string to an online JSON editor such as http://www.jsoneditoronline.org/.

1. Select New
2. Paste the object into the left window. The object should begin and end with curly brackets.
3. Use the right arrow to beautify and create a formatted list in the right window.
4. Select and edit the properties of interest.
5. Use the left arrow to return the contents to a single string in the left window.
6. Copy the contents of the left window or save to a file.
7. Use the new string in an update statement, where ID was obtained in the SELECT statement above

update sqdr.sqdrver set svc_props = '...' WHERE ID=x' ...'

Hints

• Copy from the JSON editor to a file (rather than using select & copy/paste) to avoid the addition of line feeds.
• Make sure that values are enclosed in single quotes, not double quotes
• When using IBM Data Studio, editing the column displays only the first 100 characters of the column, so it is difficult to edit it. Instead, create an sql script and click on the result data, which will contain the full data. Then paste that into the edit box for editing column data, where you can make your changes.
• The SQL examples above were written for a Db2 control database and may vary (e.g. dbo.sqdrver instead of sqdr.sqdrver) for a SQL Server control database.