8.1.1.1 install.cfg file
Configuration information resides in the
<INSTALL_DIR>/database/db_tools/mantas_cfg/
install.cfg configuration file. The configuration file contains
modifiable instructions for Oracle database drivers and provides information that
each utility requires. It also provides the user name and password that you need to
connect to the database. In this file, you can modify values of specific utility
parameters, change the locations of output files, and specify database details for
extraction and data loading.
The install.cfg file contains information unique to each utility and
common configuration parameters; headings in the file clearly identify a
utility's parameters. You can also modify the current logging configuration
(for example, activate or deactivate particular logging levels and specify
locations for logging entries).
The following snippet provides a sample install.cfg file with
common and utility-specific information. Logging information appears at the
end of the file. You should ensure that all schema names (that is,
MANTAS, BUSINESS, and
MARKET) are in uppercase.
# This configuration file supports the following database utilities: # Calendar Mangager
# Batch Control
# Truncate Manager # Scenario Migration # Alert Purge
# Data Retention Manager # Email Notification
# Data Analysis Tool #
# The file contains some properties that are common and specific properties for each
# of the tools.
################ COMMON CONFIGURATION ENTRIES #######################
database.driverName=oracle.jdbc.driver.OracleDriver utils.database.urlName=jdbc:oracle:oci:@Ti5O10S10 utils.database.username=DB_UTIL_USER_TEST58 utils.database.password=DB_UTIL_USER_TEST58
schema.mantas.owner=mantas_TEST58 utils.miner.user=KDD_MNR_TEST58 utils.miner.password= utils.altio.username=KDD_ALTIO_TEST58 schema.business.owner=BUSINESS_TEST58 schema.market.owner=MARKET_TEST58 utils.data.directory=/users/mantast/
Solaris10_mantas58_b09_Ti5O10S10_Iron_13080_WAS/database/db_tools/data ingest.user=INGEST_USER_TEST58
ingest.password=
################ CALENDAR MANAGER CONFIGURATION ##################
# The look back and look forward days of the provided date.
# These values are required to update the KDD_CAL table. The maximum look back or forward
# is 999 days. calendar.lookBack=400 calendar.lookForward=14
############### TRUNCATE MANAGER ################################
# Specify the database username and password for truncation manager truncate.database.username=${ingest.user} truncate.database.password=${ingest.password}
################ SCENARIO MIGRATION CONFIGURATION ####################### #### GENERAL SCENARIO MIGRATION SETTINGS
#Specify the flags for whether scoring rules and wrapper datasets must be extracted or loaded
score.include=N wrapper.include=N
#Specify the Use Code for the scenario. Possible values are 'BRK' or 'EXP' load.scnro.use=BRK
#Specify the full path of depfile and name of fixfile used for extraction and loading
#Note : fixfile need not be specified in case of loading
sm.depfile=/users/mantast/Solaris10_mantas58_b09_Ti5O10S10_Iron_13080_WAS/ database/db_tools/mantas_cfg/dep.cfg
sm.release= #### EXTRACT
# Specify the database details for extraction extract.database.username=${utils.database.username} extract.database.password=${utils.database.password}
# Specify the jdbc driver details for connecting to the source database extract.conn.driver=${database.driverName} extract.conn.url=jdbc:oracle:oci:@Ti5O10S10
#Source System Id extract.system.ID=
# Specify the schema names for Extract extract.schema.mantas=${schema.mantas.owner} extract.schema.business=${schema.business.owner}
extract.schema.market=${schema.market.owner} extract.user.miner=${load.user.miner} extract.miner.password=${utils.miner.password}
# File Paths for Extract
#Specify the full path in which to place extracted scenarios
extract.dirname=/users/mantast/Solaris10_mantas58_b09_Ti5O10S10_Iron_13080_WAS/ database/db_tools/data
#Specify the full path of the directory where the backups for the extracted scripts would be maintained
extract.backup.dir=/users/mantast/ Solaris10_mantas58_b09_Ti5O10S10_Iron_13080_WAS/database/db_tools/data/temp
#Controls whether jobs and thresholds are constrained to IDs in the product range (product.ID.range.min
# through product.ID.range.max). Values are Y and N. If the range is not restriced, you can use range.check
# to fail the extract if there are values outside the product range. extract.product.range.only=N
extract.product.range.check=N
#### LOAD
# Specify the jdbc driver details for connecting to the target database load.conn.driver=${database.driverName} load.conn.url=${utils.database.urlName}
#Target System ID load.system.ID=Ti5O10S10
# Specify the schema names for Load load.schema.mantas=${schema.mantas.owner} load.schema.business=${schema.business.owner} load.schema.market=${schema.market.owner} load.user.miner=${utils.miner.user}
limit_matches=N purge=Y batch_size=5000 job=null scenario=null
# enter dates, with quotes in the following format:
# 'DD-MON-YYYY HH24:MI:SS'
start_date=null end_date=null alert_status=NW
#Base Working Directory required to put the temporary log from Database Server ap.storedproc.logdir=/tmp
#The common Path required to put the SQL files to execute
commonSQLFilePath=/users/mantast/ Solaris10_mantas58_b09_Ti5O10S10_Iron_13080_WAS/database/db_tools/data
######### DATA RETENTION MANAGER CONFIGURATION ######################## #
# Set the Data Retention Manager input variables here. ##
drm_operation=P drm_partition_type=D drm_owner=${schema.business.owner} drm_object_name=A drm_weekly_proc_fl=N
######### Email Notification ########################################## #
# The following sections contain information on configuring email
# notification information. If you wish to use Exchange, you must purchase
# Java Exchange Connector, obtain a license and the jec.jar file. The license # file must be placed in the mantas_cfg file, and the jec.jar file must be
# copied to the db_tools/lib directory. Then, edit the file
SMTP settings email.smtp.host=
# smtp port is usually 25 for smtp, 465 for smtps email.smtp.port=25
email.smtp.auth=false email.smtp.user= email.smtp.password= email.smtp.useHTML=true
# Exchange settings *** See above for instructions to enable this *** # Your Exchange administrator should help identify these settings
#
email.exchange.server= email.exchange.domain= email.exchange.user= email.exchange.password= email.exchange.prefix=Exchange email.exchange.mailbox= email.exchange.useSSL=true email.exchange.useFBA=true email.exchange.useNTLM=false email.exchange.draftsfoldername=drafts email.exchange.useHTML=true
#HTML email styles
email.style.header=font-family:Arial, Helvetica, sans-serif;font-size:10pt; color:black;
email.style.hr=color: #555; background-color: #f00; height: 1px;
email.style.title=font-family:Arial, Helvetica, sans-serif;font-style: bold;font-size:12pt;
email.style.message=font-family:Arial, Helvetica, sans-serif;font-size:11pt;
email.style.table=font-family:Arial, Helvetica, sans-serif;border:1px solid #000; border-collapse:collapse;
email.style.th=font-style: bold;border:1px solid #000; border- collapse:collapse; padding: 4px; background:#C7DAED
email.style.tr=font-size:10pt
email.style.td=border:1px solid #000; border-collapse:collapse; padding: 4px
email.style.footer=font-family:Arial, Helvetica, sans-serif;font-size:10pt; color:black;
email.style.disclaimer=font-style: italic;
######### HIGHLIGHTS GENERATION CONFIGURATION #########################
# Set the default currency code.
# See /mantas_cfg/etc/xml/CUR_Currencies.xml for supported currency # codes.
#
currency.default=USD
######### HDC CONFIGURATION #########################
# Set the maximum number of hdc threads. #
hdc.maxthreads=1 hdc.batchsize=10000
######### Data Analysis Tool CONFIGURATION #########################
# Username and password for connecting to the database
dat.database.username=${ingest.user} dat.database.password=${ingest.password}
# Input file for analysis dat.analysis.input=/users/mantast/
Solaris10_mantas58_b09_Ti5O10S10_Iron_13080_WAS/database/db_tools/mantas_cfg/ analysis_aml.xml
# Output file and file format control
dat.analysis.output=/users/mantast/ Solaris10_mantas58_b09_Ti5O10S10_Iron_13080_WAS/database/db_tools/data/ analysis.html
# Valid values for dat.output.format are HTML and TEXT dat.output.format=HTML
# Delimiter only applies to TEXT output format dat.output.delimiter=, log.fatal.synchronous=false log.warning.synchronous=false log.notice.synchronous=false log.diagnostic.synchronous=false log.trace.synchronous=true
# Specify the hostname of syslog if syslog was chosen as the log output location # anywhere above.
# Logging will go to the console if syslog was selected and this property is # not given a value.
log.syslog.hostname=
# Specify the hostname of the SMTP server if an e-mail address was chosen as # the log output location anywhere above.
# Logging will go to the console if an e-mail address was selected and this # property is not given a value.
log.smtp.hostname=
# Specify the maxfile size of a logfile before the log messages get rolled to # a new file (measured in MBs).
# If this property is not specified, the default of 10 MB will be used. log.max.size=
#NOTE: The values for the following variables need not be changed # Specify the ID range for wrapper datasets dataset.wrapper.range.min=113000001 dataset.wrapper.range.max=114000000 product.ID.range.min=113000000
product.ID.range.max=200000000