Using the DataExchange Utilities and Services

This program activates an enabled database by registering it with the local replication runtime environment.

If the replication engine is running and control tables have been populated, the first replication with the initial Partner Site will be performed automatically. Once this first replication has succeeded, the newly activated database will be fully aware of all administrative data in that network, including all replication schedules.

dxact [options] <DSN>

Argument	Description
<DSN>	Data Source Name for the database to be activated.

Option	Description
/DES[CRIPTION]=<string>	Description of this replication site, e.g. "My First Site". Database name will be automatically appended to it. [default=MyFirstSite]
/DL[LPATH]=<string>	Full path to the event handler DLL, if specified. [default=<null>]
/FI[RSTSITE]	Use this switch only if this is the First Site at which this release is being activated
/FO[RCEINSTALL]	If specified, allows activation of a database that is a copy of an already-activated site
/LOG={flags}	Specify which messages types to log: I = informational messages W = warning messages E = error messages For example, '/log=e /log=w' or '/log=we' (the default) logs errors and warnings only. Any message type left unspecified is suppressed. [default=iwe]
/LOGF[ILE]=<string>	File name for log messages. Specifying '/LOGFILE=' alone sets logging to the console. [default=C:\ProgramData\Actian\PSQL\Replication\LogFiles\DXACT.log]
/LOGH[ISTORY]=nnn	Number of files to maintain in the log history [default=5]
/LOGS[IZE]=nnn	Maximum size of the log file (0 means 'no limit') [default=0]
/LOGW[IDTH]=nnn	Log messages are wrapped to fit within this line length. (minimum 50) [default=79]
/NOI[NITIALREPL]	If specified, the replication engine will not perform an initial replication after the release has been activated.
/NOL[OGO]	Do not display starting logo.
/ODBCC[ONNSTR]=<string>	Additional ODBC connection string parameters in the form: <name>=<value>[;<name>=<value>...] [default=<null>]
/ODBCN[AME]=<string>	User name for ODBC connection [default=PDUSER]
/ODBCP[ASSWORD]=<string>	Password for ODBC connection [default=<null>]

Running the following example from a command prompt on a First Site activates a DSN named Demodata on a First Site machine.

dxact /FIRSTSITE Demodata

The next example, if run from a Partner Site, would activate a DSN named Demodata on a Partner Site machine replicating with a machine named Win10Server.

dxact /PARTNERNETADDR=Win10Server Demodata

This example activates the DSN named Demodata on the First Site machine and sets the dxact logging to the console.

dxact /FIRSTSITE /LOGFILE= Demodata

This example activates the DSN named Demodata on the Partner Site machine replicating with a machine addressed as Adminserver and sets the dxact logging to a file named adminlog.txt located in C:\ProgramData\Actian\PSQL\Reports.

dxact /PARTNERNETADDR=AdminServer /LOGFILE=C:\ProgramData\Actian\PSQL\Reports\adminlog.txt Demodata

dxcleanup

DataExchange Control Table Cleanup Configuration Utility

This program sets or shows the control table cleanup schedules for an activated database.

dxcleanup [options] <Operation> <DSN>

Argument	Description
<Operation>	Valid arguments include SET or SHOW
<DSN>	Database datasource name

This example displays the number of days set for the cleanup period and the age (in days) of the oldest allowed record currently in place for the data source name demodata.

Option	Description
/C[LEANUPPERIOD]=nnn	Time (in days) between cleanup cycles [default=7]
/DXA[DMIN]=<string>	DX administrator name [default=ADMIN]
/DXP[ASSWORD]=<string>	DX administrator password [default=password]
/LOG={flags}	Specify which messages types to log: I = informational messages W = warning messages E = error messages For example, '/log=e /log=w' or '/log=we' (the default) logs errors and warnings only. Any message type left unspecified is suppressed. [default=iwe]
/LOGF[ILE]=<string>	File name for log messages. Specifying '/LOGFILE=' alone sets logging to the console. [default=C:\ProgramData\Actian\PSQL\Replication\LogFiles\DXCLEANUP.log]
/LOGH[ISTORY]=nnn	Number of files to maintain in the log history [default=5]
/LOGS[IZE]=nnn	Maximum size of the log file (0 means 'no limit') [default=0]
/LOGW[IDTH]=nnn	Log messages are wrapped to fit within this line length. (minimum 50) [default=79]
/N[OLOGO]	Do not display starting logo.
/ODBCN[AME]=<string>	User name for this database (if security enabled) [default=<null>]
/ODBCP[ASSWORD]=<string>	Password for the user specified as ODBCName (if security enabled) [default=<null>]
/OL[DESTALLOWED]=nnn	Age (in days) of oldest allowed record [default=90]
/H[ELP]	Displays the command usage help text.
/PA[RTNERNETADDR]=<string>	The network address of the Partner Site we should replicate with first. If this switch is not specified, DXact will display a prompt for the user to enter the partner network address [default=<LocalHost>]
/PN[LICENSE]=<string>	Specifies name of PNLicense file to register (specify at network First Site only) [default=C:\Program Files (x86)\Actian\PSQL\bin\repllicense.pnl]
/PR[EPROCESS]	If specified, preprocessing of starter data will be performed. This should be done unless it is known that no database changes occur between design and activation, and that starter data was preprocessed at design time. Otherwise, starter data will not get replicated.
/REC[ONCILEREP]	If specified, the replication engine will perform reconciliation processing during the initial replication after the release has been activated. Should be specified unless data is identical between the site being activated and the First Site. Otherwise, reconciliation will not be performed.
/SI[TETYPE]=<string>	Override new site's default site type. Must be one of: COMPLETE or HIGH [default=COMPLETE]
/SU[BSCRIBESITES]	If specified, this site will be automatically subscribed to all new sites (via the dSite table).
/H[ELP]	Displays the command usage help text.

Example

dxcleanup show demodata

A message should display that lists the name and version of the control table cleanup configuration utility, and additional information such as the following:

Cleanup Period is 7 day(s)

Oldest Allowed is 90 day(s)

dxdeact

DataExchange Deactivate a Project Release

This program deactivates a release that was previously activated using DXact and removes the activated database from the list of those available for replication. If you want to delete a replicated database from physical storage, you must deactivate it first.

dxdeact [options] <DSN>

Argument	Description
<DSN>	Database datasource name

Option	Description
/K[EEPINFO]	Keep Activation Information in system database (by default, that info is removed)
/LOG={flags}	Specify which messages types to log: I = informational messages W = warning messages E = error messages For example, '/log=e /log=w' or '/log=we' (the default) logs errors and warnings only. Any message type left unspecified is suppressed. [default=iwe]
/LOGF[ILE]=<string>	File name for log messages. Specifying '/LOGFILE=' alone sets logging to the console. [default=C:\ProgramData\Actian\PSQL\Replication\LogFiles\DXDEACT.log]
/LOGH[ISTORY]=nnn	Number of files to maintain in the log history [default=5]
/LOGS[IZE]=nnn	Maximum size of the log file (0 means 'no limit') [default=0]
/LOGW[IDTH]=nnn	Log messages are wrapped to fit within this line length. (minimum 50) [default=79]
/N[OLOGO]	Do not display starting logo.
/ODBCN[AME]=<string>	User name for this database (if security enabled) [default=<null>]
/ODBCP[ASSWORD]=<string>	Password for the user specified as ODBCName (if security enabled) [default=<null>]
/H[ELP]	Displays the command usage help text.

This example deactivates the data source name demodata and retains the activation information in the system database. By default, activation information is removed.

dxdeact /keepinfo demodata

dxdeploy

DataExchange Deploy

This program deploys DataExchange on two sites using settings given in the XML Deployment Descriptor file. This utility streamlines replication processes by combining functionality of Dxact and Dxsynctables.

dxdeploy [options] <XML File>

Argument	Description
<XML file>	XML Deployment Descriptor file. XML Descriptor file templates (EXPRESS.XML and CUSTOM.XML) are located in C:\Program Files (x86)\Actian\PSQL\Replication\docs on 64-bit systems.

XML Descriptor File Templates

Option	Description
/LOG={flags}	Specify which messages types to log: I = informational messages W = warning messages E = error messages For example, '/log=e /log=w' or '/log=we' (the default) logs errors and warnings only. Any message type left unspecified is suppressed. [default=iwe]
/LOGF[ILE]=<string>	File name for log messages. Specifying '/LOGFILE=' alone sets logging to the console. [default=C:\ProgramData\Actian\PSQL\Replication\LogFiles\DXDEPLOY.log]
/LOGH[ISTORY]=nnn	Number of files to maintain in the log history [default=5]
/LOGS[IZE]=nnn	Maximum size of the log file (0 means 'no limit') [default=0]
/LOGW[IDTH]=nnn	Log messages are wrapped to fit within this line length. (minimum 50) [default=79]
/N[OLOGO]	Do not display starting logo.
/S[ITE]=<string>	Choose which site in Sites list to deploy: First \| Partner (This setting is optional and is used for demonstration purposes only.) [default=<null>]
/H[ELP]	Displays the command usage help text.

DXdeploy is used to implement 1-way Real-Time Backup and 1-way and 2-way Data Synchronization. The DXdeploy utility uses an XML descriptor file that you create to capture information about your database and replication environment. As shown in the syntax example, this file is included as an argument when you execute the utility. DXdeploy uses the XML descriptor file to handle the processes required for replication.

DataExchange includes two different XML descriptor templates you can use to create your specific XML descriptor file to use with DXdeploy. You must edit the template to include necessary information in order for DXdeploy to successfully replicate your data.

Caution You cannot use these template files as is and successfully replicate your data. You must create a template file to include specific information about your replication environment.

EXPRESS.XML

See 1-Way Deployment Using DXdeploy for an example deployment using the EXPRESS.XML template file.

CUSTOM.XML

See 2-Way Deployment Using DXdeploy for an example deployment using the CUSTOM.XML template file.

dxdynpath

DataExchange Dynamic Table Configuration and Test Utility (Real-Time Backup Only)

Append, replace or show the existing include and exclude patterns and/or regular expressions for a given designed database. Optionally test existing or hypothetical patterns or regular expressions.

dxdynpath [options] <Operation> <DSN>

Argument	Description
<Operation>	Valid arguments include APPEND, REPLACE, SHOW or TEST.
<DSN>	Database datasource name created by DataExchange.

Any file used with the dxdynpath utility requires system keys.

Option	Description
/F[ILEPATH]=<string>	Absolute file path to test (valid only for <Operation> TEST). The path used here is the absolute path to the database created by DataExchange. [default=<null>]
/LOG={flags}	Specify which messages types to log: I = informational messages W = warning messages E = error messages For example, '/log=e /log=w' or '/log=we' (the default) logs errors and warnings only. Any message type left unspecified is suppressed. [default=iwe]
/LOGF[ILE]=<string>	File name for log messages. Specifying '/LOGFILE=' alone sets logging to the console. [default=C:\ProgramData\Actian\PSQL\Replication\LogFiles\DXDYNPATH.log]
/LOGH[ISTORY]=nnn	Number of files to maintain in the log history [default=5]
/LOGS[IZE]=nnn	Maximum size of the log file (0 means 'no limit') [default=0]
/LOGW[IDTH]=nnn	Log messages are wrapped to fit within this line length. (minimum 50) [default=79]
/N[OLOGO]	Do not display starting logo.
/ODBCN[AME]=<string>	User name for this database (if security enabled) [default=<null>]
/ODBCP[ASSWORD]=<string>	Password for the user specified as ODBCName (if security enabled) [default=<null>]
/P[ATTERN]=<string>	Glob-style pattern (e.g. "dir newfile*.mkd") or regular expression. For <Operation> APPEND or REPLACE, PATTERN is applied to Dynamic Table Configuration. For <Operation> TEST, PATTERN is used to test for a match, otherwise ignored [default=<null>]
/T[YPE]=<string>	INCLUDE, EXCLUDE or BOTH (BOTH is valid only for <Operation> SHOW) [default=INCLUDE]
/H[ELP]	Displays the command usage help text.

Remarks

Before we explain how DataExchange automatically includes or excludes files using pattern matching, let’s first discuss the types of expressions you can use.

Note Dxdynpath should only be used with the Real-Time Backup Edition.

Types of Expressions

You may use the following types of pattern-matching expressions with the dxdynpath utility:

•

Dir expressions

•

Regular expressions

Dir Expressions

This type of expression is based on the Windows directory (dir) command, and provides an alternative to using regular expressions. Dir expressions have the following characteristics:

•

Must contain dir as the first characters (dir is not case-sensitive).

•

May include a relative path to the dictionary files. See Relative Paths. Absolute paths are not allowed.

•

Must include the names of files. File names may include the ? or * wildcard. Note that a period (.) designates a period. It is not the same as the ? wildcard.

•

May include the slash (/) character, backslash (\) character, or a combination of the two.

•

May include the /s option to specify files in subdirectories. The /s option may not be the first characters in the expression. Other than that, the option is not positional.

•

Must include a space character as the separator between the elements of the expression.

•

May be used in a series, separated by semicolons (;). A space character may precede or follow the semicolon if you choose, but is not required.

The following dir expressions are valid examples:

•

dir mydbase\*.mkd /s

•

dir ..\..\acct/acct*.?db

•

dir ../payables/custdb/??posted??.pay

•

dir mydbase\*.mkd /s ; dir ..\..\acct/acct*.?db

Regular Expressions

Regular expressions are a pattern-matching technique to parse and manipulate text. DataExchange uses the same regular expressions as the Windows version of the programming language perl.

Regular expressions have the following characteristics:

•

May include literal or relative paths. If relative paths are used, see Relative Paths.

•

May include the slash (/) character, backslash (\) character, or a combination of the two as characters in a relative path. When paired with the double period (..) characters in a relative path, slash and backslash are interpreted as part of a path structure. For example, ..\..\.*bak. If relative paths are used, see Relative Paths.

•

May be used in a series, separated by semicolons (;). A space character may precede or follow the semicolon if you choose, but is not required.

•

May use uppercase characters, lowercase characters, or a combination of the two.

•

Must be surrounded by double quotation marks if the expression contains characters that are meaningful to the command-line interpreter. For example, the “|” character is legitimate in a regular expression to indicate “or.” That same character, however, represents a pipe directive to the command-line interpreter. Any regular expression that uses the “|” character must be surrounded by double quotation marks. If you are unsure about a character, surround the regular expression with double quotation marks.

•

Must use valid regular expression syntax, with the exceptions noted above in this bulleted list. Consult the regular expression syntax in your perl documentation.

The following regular expressions are valid examples:

•

“..\..\(mon|tue|wed|thru|fri)\\(([01][0-9]|2[0-3]))\\.*\.mkd” (any mkd file in a relative directory structure of weekday\hour)

•

.*bak (any backup file in or below the “home” directory)

•

day\dt\.ddf (dictionary files with a name format of day[0-9]t.ddf, such as day0t.ddf, day4t.ddf, and so forth)

•

(\w+)\\.*\\\1\\.* (all files in subordinate directories under the home directory where a subordinate directory name recurs, for example /data/acct/data/purged)

Relative Paths

Relative paths are relative to a home directory. The home directory is the one that contains data dictionary files (DDFs) recognized by DataExchange. To be recognized by DataExchange, the dictionary files must have been created by one of the DataExchange utilities or by a DataExchange replication process. If you already have dictionary files created by a replication process, the home directory is relative to their location.

Relative paths use “..\” to refer to a directory level. You may also use the slash character (/) instead of the backslash (\). Each “..\” means to move up the directory structure relative to the home directory. For example, if your home directory is c:\myapp\mydata\accounts\, then a relative path of “..\” navigates to c:\myapp\mydata. Similarly, a relative path of “..\..\” navigates to c:\myapp.

Verifying Expression Pattern Matching

Constructing valid regular expressions can be challenging. To help, DataExchange provides the utility Dxdynpath.exe to verify the pattern matching of your regular and dir expressions. The utility compares the pattern against the command line arguments and reports whether the comparison passes or fails.

Note Dxdynpath bases pattern matching solely on its command line arguments. It does not check for the existence of files or directories or navigate them. For example, if you test an expression against the file acctdata\Bbzz95.mkd, dxdynpath does not check whether this folder and file exist.

The following example compares a dir expression against a supposed file located in c:\bklog\hr or in any subdirectories to c:\bklog\hr. The example would be entered as a single line at the command prompt.

dxdynpath /f=c:\mydata\acct\dbQ299x.mkd /p="Dir ..\..\bklog\hr\dbQ2???.mk? /s" test mydbdsn

Dxdynpath reports “matches pattern” because supposed file dbQ299x.mkd matches the pattern and resides in a subdirectory of c:\bklog\hr.

By default, output from Dxdynpath is written to a log file, not to the screen. If you want output written to the screen, use the /LOGF= option.

This example displays the include and exclude patterns currently in place for the data source name demodata.

dxdynpath /t=both show demodata

If there are no include or exclude patterns configured, a message similar to the following returns:

INCLUDE pattern is ""

EXCLUDE pattern is ""

Running the following command on the First Site appends attend*.mkd as an include pattern to any include patterns that already exist for demodata.

dxdynpath /t=include /p="dir attend*.mkd" append demodata

Note Commands are case insensitive. You may use uppercase characters, lowercase characters, or a combination of the two.

dxregevnt

DataExchange Utility to read/write the event handler DLL path to the database

Registers, unregisters or shows the event handler for an activated database.

dxregevnt [options] <Operation> <DSN>

Argument	Description
<Operation>	Valid arguments include REGISTER, UNREGISTER or SHOW
<DSN>	Datasource name

Option	Description
/DXA[DMIN]=<string>	DX administrator name [default=ADMIN]
/DXP[ASSWORD]=<string>	DX administrator password [default=password]
/LOG={flags}	Specify which messages types to log: I = informational messages W = warning messages E = error messages For example, '/log=e /log=w' or '/log=we' (the default) logs errors and warnings only. Any message type left unspecified is suppressed. [default=iwe]
/LOGF[ILE]=<string>	File name for log messages. Specifying '/LOGFILE=' alone sets logging to the console. [default=C:\ProgramData\Actian\PSQL\Replication\LogFiles\DXREGEVNT.log]
/LOGH[ISTORY]=nnn	Number of files to maintain in the log history [default=5]
/LOGS[IZE]=nnn	Maximum size of the log file (0 means 'no limit') [default=0]
/LOGW[IDTH]=nnn	Log messages are wrapped to fit within this line length. (minimum 50) [default=79]
/N[OLOGO]	Do not display starting logo.
/ODBCN[AME]=<string>	User name for this database (if security enabled) [default=<null>]
/ODBCP[ASSWORD]=<string>	Password for Administrator. [default=<null>]
/P[ATH]=<string>	Absolute path to an event handler (a shared library) [default=<null>]
/H[ELP]	Displays the command usage help text.

Running this example displays if the specified database has an Event Handler DLL registered.

dxregevnt show demodata

If you do not have an Event Handler DLL registered, a message similar to the following displays:

No Event Handler is Registered

The next example registers an Event Handler DLL named dxevent.dll located in C:\Program Files (x86)\Actian\PSQL\bin with demodata on 64-bit systems.

dxregevnt /p="C:\Program Files (x86)\Actian\PSQL\bin\dxevent.dll" register demodata

If you have an Event Handler DLL registered, a message similar to the following displays:

Event Handler is "C:\Program Files (x86)\Actian\PSQL\bin\dxevent.dll"

dxrepl

DataExchange Console Replication Initiation Utility

Replicate files from DSN to Partner Site.

dxrepl [options] <DSN> [<SiteID>]

Argument	Description
<SiteID>	The target site for the replication session [default=<null>]
<DSN>	The PSQL Replication datasource name

DataExchange Table Synchronization and Check Utility

Option	Description
/LOG={flags}	Specify which messages types to log: I = informational messages W = warning messages E = error messages For example, '/log=e /log=w' or '/log=we' logs errors and warnings only. Any message type left unspecified is suppressed. [default=iwe]
/LOGF[ILE]=<string>/	File name for log messages. Specifying '/LOGFILE=' alone sets logging to the console. [default=C:\ProgramData\Actian\PSQL\Replication\LogFiles\DXREPL.log]
/LOGH[ISTORY]=nnn/	Number of files to maintain in the log history [default=5]
/LOGS[IZE]=nnn	Maximum size of the log file (0 means 'no limit') [default=0]
/LOGW[IDTH]=nnn	Log messages are wrapped to fit within this line length. (minimum 50) [default=79]
/N[OLOGO]	Do not display starting logo.
/ODBCN[AME]=<string>	User name for this database (if security enabled) [default=<null>]
/ODBCP[ASSWORD]=<string>	Password for the user specified as ODBCName (if security enabled) [default=<null>]
/H[ELP]	Displays the command usage help text.

dxsynctables

Finds modified data missed by DataExchange event handler and returns control tables to the consistent state.

dxsynctables [options] <Table> <DSN>

Argument	Description
<Table>	Name of table to be updated (*=All tables)
<DSN>	Datasource name

DataExchange includes four graphical user interface (GUI) utilities for completing replication design, administration and monitoring tasks. The following table lists the GUI-based utilities and offers a brief description for each utility.

Option	Description
/E[XCLUDE]=<string>	Optional comma-separated list of tables to exclude [default=<null>]
/F[ORCE]	Forces update of timestamped columns.
/LOG={flags}	Specify which messages types to log: I = informational messages W = warning messages E = error messages For example, '/log=e /log=w' or '/log=we' (the default) logs errors and warnings only. Any message type left unspecified is suppressed. [default=iwe]
/LOGF[ILE]=<string>	File name for log messages. Specifying '/LOGFILE=' alone sets logging to the console. [default=C:\ProgramData\Actian\PSQL\Replication\LogFiles\].
/LOGH[ISTORY]=nnn	Number of files to maintain in the log history [default=5]
/LOGS[IZE]=nnn	Maximum size of the log file (0 means 'no limit') [default=0]
/LOGW[IDTH]=nnn	Log messages are wrapped to fit within this line length. (minimum 50) [default=79]
/M[SD]	Mark the data with starter data timestamp
/N[OLOGO]	Do not display starting logo.
/ODBCN[AME]=<string>	User name for this database (if security enabled) [default=<null>]
/ODBCP[ASSWORD]=<string>	Password for the user specified as ODBCName (if security enabled) [default=<null>]
/H[ELP]	Displays the command usage help text.

GUI-based Utilities

Utility File Name	Utility Name	Description
da	Manager	GUI DX Administration utility. Sets up notifications, user access, and replication schedule information.
replmonitor	Replication Progress and Log Viewers	GUI statistics and logging view utility. Configures replication sessions, monitors data replication, and sets logging options.
dpwizard	Deployment Wizard	Wizard to deploy replication.
trwizard	Template Remover Wizard	Wizard to remove a replication template.

DataExchange Manager

Replication Progress and Log Viewers

DataExchange Manager is used to administer replication networks. It is a separate application that can be run external to PCC. You can open it by selecting Actian DataExchange 13 > DX Manager from the Start menu or within PCC by selecting DataExchange > Manager.

For more information, see Using DataExchange Manager.

replmonitor

DataExchange allows you to configure replication sessions, initiate replication, monitor it, and log it. The tools with which you perform these actions are the Replication Progress and Log Viewers. Their window is accessed from PCC.

For more information, see Using the Replication Progress and Log Viewers.

dpwizard

DataExchange Deployment Wizard

DataExchange Template Remover Wizard

DataExchange Deployment Wizard walks you through the steps necessary to deploy replication on First and Partner Sites. The wizard is an automated alternative to the DXdeploy command-line utility and can be invoked by selecting Actian DataExchange 13 > DX Deployment Wizard from the Start menu or from within PCC by selecting DataExchange > Deployment Wizard.

trwizard

DataExchange includes two services that initiate automatically at the time of startup. This topic discusses these services and includes specific information on configuring these for your specific business requirements.

Template Remover is a wizard that deletes a replication template. You can no longer use the template to activate sites. You access this wizard by selecting Actian DataExchange 13 > DX Template Remover from the Start menu or from within PCC by selecting DataExchange > Template Remover.

Services

File Name	Utility Name	Description
dxagent	DataExchange Agent	Detects critical replication failures, and notifies administrators by email.
replserv	PSQL Replication	Performs data replication between PSQL databases.

dxagent

DataExchange Agent

Detects critical replication failures and notifies administrators by email.

Failure Notification

DataExchange has the ability to notify you by email if a scheduled replication fails. The failure can be either of the following types:

•

A scheduled replication fails to replicate within a specified period.

•

Communication with a replication site fails. Perhaps the machine is down, the network has failed, and so forth.

Notification Agent

DataExchange installs a component called the notification agent if the machine contains the PSQL Server product. The notification agent, or DX Agent, provides the notification functionality when scheduled replication fails.

The agent is not available if you install DataExchange on a machine with PSQL Workgroup. If you use a Workgroup engine as a replication site, set up your replication schedule on the site that contains the Server database engine. The agent on the Server machine can detect whether replication fails on the site with the Workgroup engine.

The agent sends email if a replication failure occurs. The email subject line contains the words “DataExchange alert.” The email body contains the following primary content:

•

Identity of computer on which the failure occurred

•

Name of database

•

Time since the last successful replication

Communication Protocol

The agent requires the basic Simple Mail Transfer Protocol (SMTP) to communicate with a mail server. Each replication machine with an agent must be configured to access the SMTP server. The SMTP server correspondingly must be set up to accept email from each replication site running the agent.

The agent does not deal with authentication or encryption. It does allow a different port other than the standard SMTP port 25. Thus, if a firewall opens a different port, you can specify which one. The port must not require authentication or encryption.

If a replication failure occurs and the SMTP server cannot be reached, a pop-up message appears. The message informs you that email could not be sent and lists the name of the SMTP server that cannot be communicated with. Note that the pop-up message appears even if no one is logged on to the computer. Also, the message continues to display until replication succeeds or the SMTP server becomes available. This is true even if you click OK to dismiss the message.

Agent Configuration

DataExchange contains a configuration file with which you configure the agent.

►

To configure the notification agent

In a text editor, open the file DXAgentConfig.xml, found on 64-bit systems in C:\Program Files (x86)\Actian\PSQL\Replication\Config.

<?xml version="1.0"?>

<hostname>SMTP Server To Be Configured
</hostname

</smtpserver>

<email>

<from>DXAgent@MyCompany.com</from>

<to>Email Address To Be Configured</to>

</email>

</dxagentconfig>

Specify the following in the file:

•

SMTP Server To Be Configured – The name or IP address of the email server.

•

25 – Port number on the email server used for receiving mail. By default, set to port 25.

•

DXAgent@mycompany.com – The email address used by the agent for the sender of the notification. This address is for information only and does not have be an valid address.

•

Email Address To Be Configured – The email address used by the agent for the recipient of the notification. Only one address is allowed, but it may be a group address.

The following example shows a modified DXAgentConfig.xml file.

<?xml version="1.0"?>

<hostname>myserver.mylocation.mycompany.com</hostname>

</smtpserver>

<email>

<from>DXAgent@mycompany.com</from>

<to>mailbox@myserver.mylocation.mycompany.com</to>

</email>

</dxagentconfig>

Save your modified DXAgentConfig.xml file.

If you have not already done so, reset your replication schedule to include notification.

replserv

PSQL Replication Service