The initial settings for all properties are loaded from the replbase<verson#>.ini file. The file can be found in the root Pro2 install folder. You can modify the properties manually or use the Properties tab in the user interface.

Use the following table as a reference for the configurable Pro2 properties and their default configurations.

Property Default Value Description
ADMIN_TITLE Pro2

You can define the title of a particular Pro2 instance.
ALERT_1_PER_DAY YES
Sends 1 replication thread status email per-day.
Note: This property overrides all other alert properties and settings.
APPSRV_QUEUE_COMPRESSION NO

Enables or disables queue compression for replication threads.
Bulk_Max_Cache 25

Sets the maximum number of rowids that are cached per-table during bulk loads. This value is used during bulk load restarts.
CDC_MAX_PROCESSED 10

The number of rows a CDC Admin processes before it goes into sleep mode. If is value of 0 is set, then all rows are processed.
CDC_PURGE_DAYS 10

CDC records with create dates older than this value are be purged during the CDC purge process. This value is used in conjunction with a disposition of "mark as applied."
CDC_QUEUE_COMPRESSION NO

Enables or disables queue compression for CDC threads.
DBDOWN_RETRIES 5

Sets the number of attempts allowed to reset database instance if it stops working.
DB_LOCATION db

Contains the location of the Pro2 database instances (repl, replperf, source and target database instances).
DELETE_TRIG_DIRECTORY bprepl/repl_d

Contains the location of the REPLICATE-DELETE schema trigger procedures.
DEL_TRIG_TEMPLATE tplt_repltrig.p

Contains the default information used in generating the REPLICATE-DELETE schema trigger procedures.
EXCEPT_TGT_FIELDS pro2created | pro2modified

Contains a list of all the target side fields which are not to be included in the mapping process for replication.
EXTENT_DELIMITER ##

GenSQLSchema.p and GenSQLDiff.p use this value as the delimiter for definitions of Progress array fields.
HEARTBEAT_CHECK_MINUTES 15

Sets the time stamp to detect a replication threads most recent replication activity and to detect if a replication thread is stalling.

INCLUDE_DIRECTORY bprepl/repl_inc

Contains the tables present in the source database.

INCLUDE_LOB NO

Enables or disables the inclusion of LOB fields in the replication process.
JAVA_TRIGGER_DIR bprepl/repl_jtrig/

The folder name to where Java triggers are generated.
LOG_ALERT_DAILY_LIMIT 10

Sets the daily limit on replication log generation process.
LOGICAL_DELETE_TABLES XXX_so_mstr,XXX_sod_det

A comma delimited list of table names that are logically deleted, as opposed to physically deleted, from the target database

.
LOG_DIRECTORY bprepl/repl_log

The folder location of Pro2 log files.
LOG_FILE_SUFFIX .log

An extension used for Pro2 log file names.
LOG_RETENTION_DAYS 10

Sets the maximum number of days that a log file is stored before being purged from the disk.
MASS_LOAD_DIRECTORY bprepl/repl_mproc

This property designates the folder that Pro2 Bulk Load procedures are generated.
MASS_LOAD_LOG_DIR bprepl/repl_mproclog

Designates the Bulk Load log files storage folder location.
MASS_LOAD_TEMPLATE tmpl_mreplproc_restart-auto-push.p

Sets the name of the template procedure that is used during the bulk-load generation.
MASS_LOAD_TEMPLATE_PRO2ORA tmpl_mreplproc_oracle.p

Sets the name of the template procedure that is used during the bulk-load procedure for a target Oracle database.
MASS_LOAD_TEMPLATE_PRO2PRO tmpl_mreplproc_pro2pro.p

Sets the name of the template procedure that is used during the bulk-load generation when the source as well as target databases belong to OpenEdge.
MASS_LOAD_TEMPLATE_PRO2SQL tmpl_mreplproc_restart-auto-push.p

Sets the name of the template procedure that is used during the bulk-load generation for a target MS SQL database.
MAX_CHAR_WIDTH 250

Sets the maximum character width.
MAX_DEC_PREC 38 Maximum number of positions to the right of the decimal when generating a target schema for Microsoft SQL Server.
MERGED_TRIGGER_TEMPLATE tmpl_mrgdtrig.i

Contains the default information required to list tables that require merged triggers.
MERGED_TRIG_DIRECTORY bprepl/repl_mgtrig

Contains the directory listing tables that require merged triggers.
MERGED_TRIG_TEMPLATE tmpl_mrgdtrig.i

The name of the template that is used to generate merged triggers.
MSS_DB_PF MSS-DB-EXAMPLE.pf
Example .pf file for MSS database connections for Pro2 user interface.
Note: Actual .pf file should be named after the logical database name.
ORA_DB_PF ORA-DB-EXAMPLE.pf
Example .pf file for Oracle database connections for Pro2 user interface.
Note: Actual .pf file should be named after the logical database name.
OUTPUT_BASENAME replproc

Contains the replication processorlog file name. Queue thread number and log file suffix are appended to the basename.
PF_DIRECTORY bprepl\Scripts

Directory containing the .pf files, scripts, and shortcuts to start the Pro2 web user interface, replication processors, and bulk-load procedures.
PROC_DIRECTORY bprepl/repl_proc

Sets the operating system directory where the replication processor procedure library is located.
PROGRESS_DB_PF PRO-DB-EXAMPLE.pf

The folder location of the Pro2 database PF files.
PROC_TEMPLATE tmpl_replproc.p

Sets the name of the template procedure used during the creation of the replication procedure library.
PROC_TEMPLATE_PRO2SQL tmpl_replproc.p

The name of the template that is used to generate replication procedures for Microsoft SQL Server based targets.
PROC_TEMPLATE_PRO2ORA tmpl_replproc.p

The name of the template that is used to generate replication procedures for Oracle based targets.
PROC_TEMPLATE_PRO2PRO tmpl_replproc_pro2pro.p

The name of the template that is used to generate replication procedures for OpenEdge based targets.
PRROWID_ADD_DB NO

When this property is set to YES Pro2 prefixes the source database name to the PRROWID column that is stored in the target database.
PURGE_DIRECTORY bprepl/repl_export

Contains the data of change records in WAN bulk-load process.
REFRESH_DASHBOARD 60

Sets the refresh time interval for the Pro2 user interface dashboard.

REFRESH_REPLICATION_INTERVAL 60

Sets the refresh time interval for the replication threads on the Pro2 user interface dashboard.
REPL_RESTART_ON_SKIPPED NO Use this property to indicate if a thread should go through the replqueue before attempting to reprocess skipped events.

Threads check for shutdown events every 1000 reads of the replqueue table. If set to “YES”, during the shutdown check the thread indicates in the thread log that REPL_RESTART_ON_SKIPPED is enabled and leaves the replqueue processing block. It then goes through the standard sleep interval and restarts processing from the top of the queue, oldest records first.
REFRESH_WATCHBOXES 60

Sets the refresh time interval for all the Watchboxes present on the Pro2 user interface dashboard.
REPL_LOG_BASENAME repllog

Contains the name of file for logging replication of records during each replication cycle. Date, queue thread number, and log file suffix are appended to name.
SCHEMA_DEL_DIRECTORY bprepl/repl_d

Contains the directory for the Pro2 generated database replication delete trigger procedures.
SCHEMA_WRI_DIRECTORY bprepl/repl_w

Contains the directory for the Pro2 generated database replication write trigger procedures.
SMTP_AUTH username, password
Contains the username and password authentication details for email alerts.
Note: The username and password details must be separated by a comma.
SMTP_DEBUG NO

When this property is set to YES a debug log for troubleshooting email send issues is created.
STATUS_CHECK_DEBUG NO

When this property is set to YES a debug log for troubleshooting the status check procedures is created.
SQL_DIRECTORY bprepl/repl_sql

Directory for the direct MS SQL assign include files, bulk copy procedures and replication procedures.
SQL_EXCLUDE_LIST ReplControl, ReplCustAsgn, ReplCustDefs, ReplCustFlds, ReplDBXRef, ReplFieldXRef, ReplProperties, ReplQueue, ReplTableXRef, and ReplThreadControl.

Contains the excluded list of tables in the MS SQL database.

TEMPLATE_DIRECTORY bprepl/repl_tmpl

Directory containing the templates used for various code generation.
TRIGGER_FORCE_LOWERCASE NO

When this property is set to YES the file names that are used for trigger generation are set to lower case and the case of the source table names is ignored.
TGT_USE_LITERAL_NAMES NO

Property to use the same naming convention as the source database for tables and columns without modifying them to meet the requirements of the target database (SQL only).
TRIGGER_EXTENSION .t

The extension that is used when Pro2 trigger files are generated.
USE_3RD_PARTY_EMAIL NO

When this property is set to YES Pro2 calls bprepl/Scripts/mail.bat or mail.sh. These files contain third party specific email calls.
USE_SQL_TRIGGERS NO

This property is used for backwards compatibility with data servers that require SQL triggers for maintaining the PROGRESS_RECID column.
WRITE_TRIG_DIRECTORY bprepl/repl_w

Sets the operating system directory where the REPLICATION-WRITE trigger procedures are located.
WRI_TRIG_TEMPLATE tplt_repltrig.p

Contains the template file used by GenReplTrigs.p to create the replication triggers.
Table 1. WAN only properties
Property Default Value Description
APPSRV_GET_PROGS_DIR bprepl/AppSrv/as_mproc

Stores the WAN process libraries.
APPSRV_LOG_DIRECTORY bprepl/repl_log

Stores the Pro2 application server log file on the source database server.

APPSRV_LOG_FILE appsrv.log

Sets the name of the Pro2 application server log file on the source DB server.
APPSRV_MASS_LOAD_DIRECTORY bprepl/AppSrv/as_mproc

Stores the details of a bulk-load procedure on the Pro2 server.
APPSRV_MASS_LOAD_TEMPLATE tmpl_ASmproc.p

Contains the default information used in generating WAN bulk-load procedures.
APPSRV_PROC_DIR_TGTDB bprepl/repl_as_tgt

Contains details of WAN replication procedures on the Pro2 server.

APPSRV_PROC_TEMPLATE tmpl_asTgtDb.p

Contains default information used in generating WAN replication procedures.

ASCII_BULK_EXP_DATA_FULL_PATH /apps/Pro2/XXX/bprepl/repl_export/data

Contains the location on target database server of ASCII bulk export data files.
ASCII_BULK_EXP_DIR /apps/Pro2/XXX/bprepl/repl_export

Sets the Bulk export root directory.
ASCII_BULK_LOAD_DATA_FULLPATH C:\Pro2\XXX\bprepl\repl_export\data

Contains the location of the target database server for ASCII bulk export data files.
ASCII_BULK_TGT_ROOT_DIR C:\Pro2\XXX

Contains the location of the target database server for ASCII bulk load SQL scripts.
APPSRV_FETCH_COUNT 1000

Specifies how many records are sent across a WAN connection to the Pro2 server at each replqueue records request.
APPSRV_FETCH_COUNT_MASS_BULK 50000

Specifies the number of bulk-load replications that are sent across the WAN connection to the Pro2 server at each replqueue records request.