Configuration

The configuration element contains the configuration parameters of the environment. The following elements configure the environment:

Element	Purpose
file	Configures the file I/O routines.
log	Configures the log handling.
tracking	Configure the database job execution tracking.
datacomparison	Configures the data comparison routines.
dataconversion	Configures the data conversion routines.
sort	Configures the external sort engine
reports	Configures the report generation parameters

File

The file element contains the I/O routines configuration parameters. The following elements configure the I/O:

Element	Type	Purpose	Default
buffersize	string	Defines the file buffer size: default (4 Kb), record or size in bytes	default

Log

The log element contains the log handling configuration parameters. The following elements configure the log handling:

Element	Type	Purpose	Default
path	string	Sets the path where logs are stored.
stacktrace	bool	Enables/Disables the errors stack trace.	false
ansioutput	bool	Enables/Disables the ANSI colors on console log.	false
systemqueries	bool	Enables/Disables the logging of queries on system tables.	false
file	bool	Enables/Disables file logging.	true
layout	element	Configures the log file layouts. Refer to Layout for detailed description.
debugtraces	bool	Enables/Disables full traces for the “Debug” executable.	false
mode	string	Defines the log file mode (normal, task, buffered). See Log Modes	normal

Log Modes

File logs may have three different behaviours:

• Normal: task log entries are written in the job log file and emitted as soon as produced. So, in case of multithreaded jobs, the logs of different, parallel tasks are mixed up in the log file.
• Buffered: task log entries are written in the job log file but emitted when the task ends. So, in case of multithreaded jobs, logs of each task are grouped together. The downside is that the task logs is visible only when the task completes.
• Task: the job log files contains only relevant job execution traces; each task logs in a dedicated log file.

Layout

The layout element defines the log record layouts, as NLog layout string. The following elements configure the log record layouts:

Element	Type	Purpose	Default
console	string	Defines the console log layout.	[${level:lowercase=true}] ${message}
file	string	Defines the file log layout.	[${longdate}] [${logger}] [${level:lowercase=true}] ${message}

Tracking

The tracking element contains the database tracking configuration parameters. The following elements configure the database tracking:

Element	Type	Purpose	Default
enabled	bool	Enables/Disables the database tracking.	false
log	bool	Enables/Disables the log message tracking.	false
diffs	bool	Enables/Disables the tracking of table and file differences.	false
datasource	string	Specifies the datasource ID of the database to use for the job tracking

Datacomparison

The datacomparison element contains the data comparison routines configuration parameters. The following elements configure the data comparison routines:

Element	Type	Purpose	Default
ignoretrailingnulls	bool	When set to true, CHAR/VARCHAR columns comparison ignores any trailing NULL contained in the column value.	false
ignoretrailingspaces	bool	When set to true, CHAR/VARCHAR columns comparison ignores any trailing NULL contained in the column value.	false
ignoreinbinaries	bool	When set to true, (VAR)CHAR FOR BIT DATA/(VAR)BINARY columns comparison ignores trailings chars as set for CHAR/VARCHAR columns.	false
ignorenullexcessinbinaries	bool	When set to true, (VAR)CHAR FOR BIT DATA/(VAR)BINARY columns comparison ignores any remaining NULLs on one side of the comparison	true
db2timestampfix	bool	When set to true, DB2 TIMESTAMP get cast as CHAR and date/time errors admitted by DB2 are automatically normalized	false
replace	element	Enables and defines the string replacement patterns for database comparison tasks. See replace.
padmode	string	Default pad mode for mixed mode filecopy or filecompare task. Can be Can be either end or shift-out	shift-out
compareebcdicbycollate	bool	When set to true, EBCDIC CHAR fields are compared using EBCDIC collating sequence. If false, comparison is dony by ASCII value	false

Replace

Character or String replacement is enabled by the replace element, that must contain the following elements:

Element	Type	Purpose	Default
from	string	The source string to replace
to	string	The replacement string

Dataconversion

The dataconversion element contains the data conversion routines configuration parameters. The following elements configure the data conversion routines:

Element	Type	Purpose	Default
converthighvalues	bool	Enables/Disables the conversion of file fields set to HIGH-VALUE (0xff).	false
explicitlayoutconversion	bool	Global setting for explicitconversion mode in layout conversion	false
replace	element	Enables and defines the string replacement patterns for table copy task. See replace.

Reports

The reports element contains the report generation parameters. The following elements configure the report generation:

Element	Type	Purpose	Default
enabled	bool	Enables/Disables the report generation.	false
path	string	Sets the path where reports are stored

Sort

The sort element contains the external sort engine configuration parameters. The following elements configure the report generation:

Element	Type	Purpose	Default
engine	string	Set the sort engine (ianus or mfsort)	ianus
removesortfiles	bool	Enable/Disable the automatic sort files deletion.	true
exepath	string	Path to the external sort engine (MFSORT.EXE)