IM Relationship Resolution Information Center, Version 4.2

Configuration file for the UMF database conversion utility

Configuration settings for the UMF database conversion utility are stored in a configuration file.

Table 1 defines two sections in the UMF database conversion utility configuration file.

Table 1. Configuration File Sections
Section Header Description
[gda] Contains configuration data for a UMF database conversion utility. Do not change the name of this section.
[SQL] Defines the database connection for both the configuration and source databases.

[gda] section parameters

ErrorLimit =n
Number of errors that occur before the node stops (default = 10).
ErrorPause =n
Number of seconds to pause after an error (default = 1).
ErrorResetInterval =n
Minutes before resetting the error count (default 0 1440 minutes/24 hour1s).
Note:
The ErrorLimit and ErrorResetInterval interact. If the error limit is not exceeded within the ErrorResetInterval, upon reaching the ErrorResetInterval the error count is reset to 0. The next error that occurs is then counted as error #1, and the Pipeline does not stop unless the ErrorLimit is exceeded within the ErrorResetInterval.
SyncLogName
Allows a different sync log name to be specified in the INI file (default = SYNC_LOG). The default value is `sync_log'. This can be used with the $$REPLACE(SYNC_LOG) macro to allow multiple nodes to share one set of configuration entries in the database.
ConfigName
(Optional parameter) Used to specify which configuration records are used for this node (default = SYNC_LOG_TEST). It must match the value in the ACQ_NODE_QUERY.ACQ_NODE and ACQ_NODE_MAP.ACQ_NODE.

This allows multiple nodes to use the same configuration database tables. Default value is the node name.

SelectCount
Determines the number of records processed in one select statement - typically around 1000 (default = 4). Some performance tuning might be required to discover the optimal value for this parameter.
  • Setting this value too high may cause excess locking on the source database.
  • Setting this value too low (close to 1) might cause slow performance because of the added overhead of each select statement being executed more often.
  • Changing the value of this parameter can be used to tune the speed at which messages are sent to the pipeline queues (higher number typically means faster sending to queues).
DsrcCode
(Optional string) Can be used in mappings by using $$REPLACE(DSRC_CODE) in ACQ_NODE_QUERY.SELECT_STMT (default = `Source1'). Typically used to allow multiple acquisition nodes to use the same db configuration entries.
PropertyCode
(Optional string) Used in mappings by using $$REPLACE(PROPERTY_CODE) in ACQ_NODE_QUERY.SELECT_STMT. Typically used to allow multiple acquisition nodes to use the same db configuration entries.
String1 (String2 through 5 also exist)
(Optional string) Can be used in mappings by using $$REPLACE(STRING1) in ACQ_NODE_QUERY.SELECT_STMT (default = 'E,G,H'). Typically used to allow multiple acquisition nodes to use the same db configuration entries.
RoutingField
The UMF tag determining the UMF field used to split target UMF messages between all the pipelines defined in the node's routing rules (default = DSRC_ACCT). This field is the customer reference number (typically DSRC_ACCT). All non-numeric characters are stripped from the field and a modulus is performed on the resulting number.
ConfigEntryLessThanEqualT =n
Used to run more than one node against a single sync log (default = 4). Forces the node to only run with ACQ_NODE_QUERY entries where ACQ_QUERY_SEQ <= value
ConfigEntryGreaterThanEqualT =n
Used to run more than one node against a single sync log (default =1). Forces the node to only run with ACQ_NODE_QUERY entries where ACQ_QUERY_SEQ >= value

[sql] section parameters

ConfigDatabaseName = datasource
The configuration database:
  • Oracle = SID
  • MS SQL Server =DSN.
  • DSN must have the default database set to the target database.
  • DB2® = ODBC
ConfigLoginName =username
Login name for the config database. This can be blank in Windows® if the ODBC connection is using Windows authentication.
ConfigLoginPassword =password
Password for the config database.
ConfigDbType =databasetype
The config database type:
  • MSSQL (default)
  • DB2
  • ORACLE
SourceDatabaseName
The source database:
  • Oracle = SID
  • MS SQL Server =DSN.
  • DSN must have the default database set to the target database.
  • DB2 = ODBC
SourceLoginName
Login name for the source database. This can be blank in Windows if the ODBC connection is using Windows authentication.
SourceLoginPassword
Password for the source database.
SourceDbType =databasetype
The source database type:
  • MSSQL (default)
  • DB2
  • ORACLE
DBTimeOut =n
Time (in seconds) UMF database conversion utility waits for a response from the database before timing out. (default = 10)
DebugLevel =n
Controls messages sent to the SQL Debug log: nodename.SqlDebug.log
  • 0=No log created, use for debugging (default)
  • 1=Log performance stats
  • 2=Log all SQL
  • 3=Debug levels 1 and 2


Feedback

Last updated: 2009