#######################################################################
# #
# DATABridge Enterprise Server #
# #
# Sample Configuration File #
# #
# #
# Copyright (C) 2010 by Attachmate Corporation #
# All Rights reserved #
# #
#######################################################################
# This is a Enterprise Server configuration file that defines
# the remote source and local sources, any of which may be cached.
# Configuration files are typically stored in the directory
# specified by the ConfigFiles registry key.
#
# To process this file use:
#
# DBEnterprise configure <thisfilename>
#
# or run Enterprise Server without any command line options and click on
# the Import button and specify this file name.
#
#
#-------------------------------------------------------------------------------
#
# Remote Source
#
#-------------------------------------------------------------------------------
# The Remote Source specifies the Server Accessory SOURCE, host name or
# IP address, and port number. Enclose the IP address with quotation marks.
# For example: "192.168.1.100".
# A configuration file can have only one remote source.
# All local sources are based on the remote source.
remote source BankDB at "192.168.1.100" port 5000
# ------
# The VIEW LOG option determines if Enterprise Server opens
# the log file at the end of each server or cacher run.
# Possible values for the VIEW LOG option:
#
# ALWAYS [ ASK ]
# NEVER
# ON FAILURE [ ASK ] (display log if result other than
# OK, COMMIT, or AUD_UNAVAIL)
#
# If ASK is specified, Enterprise Server asks if you want
# to view the log. The default setting is:
# VIEW LOG = ON FAILURE ASK.
view log = never
mirror in directory "d:\data\Mirrored" # parent directory of mirrored audits
cached in directory "d:\DATABridge\Cache" # location of cached files for this source
# When caching ...
maxwait 10 seconds # Number of seconds to wait for more audit
# or FOREVER or DONTWAIT (default).
retry 5 seconds # Number of seconds between retries.
# Default is 60 seconds.
modifies before and after images # cache both for modified records (default)
#- modifies after images only # saves space but won't work with key changes
# The following list restricts which hosts can run a DBClient
# that uses this source.
host "TURING"
host "hawking"
# When the Server Accessory sends a notification that more audit is
# available, run the following batch file.
on notify,
run "C:\Program Files\DATABridge\Enterprise\Notify.bat"
clients 2 # Number of client databases using this source.
# (Determines when to purge processed cache files.)
#-------------------------------------------------------------------------------
#
# Local Sources
#
#-------------------------------------------------------------------------------
# Local sources are accessible via Enterprise Server
# but not via the Server Accessory.
local source Warehouse
# ---------
view log = on failure ask
cache directory "d:\DATABridge\Cache"
# Individual cached audit files are titled:
#
# <directory>\<source>\<afn>
#
# where <directory> is the directory name specified in this option,
# <source> is the name of the source,
# and <afn> is the Audit File Number.
#
# For example, d:\DATABridge\Cache\Warehouse\0891
clients 1 # number of client databases using this source
# (determines when to purge processed cache files)
# Defaults to 1.
# The following list restricts which hosts can run a DBClient
# that uses this source.
host "TURING"
host "192.168.1.51"
host "192.168.16.2"
# filtering conditions
select * from BANK where ^ updatetype (delete);
select * from BRANCH where ^ updatetype (delete);
select * from ACCOUNT where ^ updatetype (delete);
select * from CUSTOMER where ^ updatetype (delete);
select * from L1 where ^ updatetype (delete);
select * from SHORT-VF where ^ updatetype (delete);
select * from TELLER where ^ updatetype (delete);
select none from TRIALBALANCES; # discard everything for this data set
select all from other data sets # keep everything for unselected data sets
# (This is set by default.)
#-------------------------------------------------------------------------------
# The following defines a filter with one formal parameter, BankNbr.
# When a local source uses this filter it must specify the actual value
# for BankNbr.
filter ByBank (BankNbr)
# ------
select * from BANK where BANK-ID = BankNbr;
select * from BRANCH where BANK-ID = BankNbr;
select * from CUSTOMER where BANK-ID = BankNbr;
select * from HISTORY where BANK-ID = BankNbr;
select none from other data sets # discard everything for unselected data sets
#-------------------------------------------------------------------------------
# The following sources are filtered but not cached. Updates are
# always read from the remote host and then filtered before
# returning them to the client.
local source OnlyBank1
# ---------
using ByBank (1) # Filter is defined above. Use 1 for BankNbr.
local source OnlyBank3
# ---------
using ByBank (3) # Filter is defined above. Use 3 for BankNbr.
local source OnlyBank99
# ----------
using ByBank (99) # Filter is defined above. Use 99 for BankNbr.
local source OnlyBank880
# -----------
using ByBank (880) # Filter is defined above. Use 880 for BankNbr.
|
