Sample Configuration File

#######################################################################

# #

# DATABridge Enterprise Server #

# #

# Sample Configuration File #

# #

# #

# Copyright (C) 2012 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 DATABridge Server 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 DBServer 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 DBServer.

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.