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 SectionsSection 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