How the Tanker Accessory Works

The Tanker Accessory writes multiple, filtered audit files simultaneously. This means that multiple DATABridge clients (each with their own filters) can replicate a DMSII database without the Engine having to read the entire audit file for each client. Thus, I/O time on the host is reduced and overall throughput is increased, as shown in the following diagram:

global db linked file template

Filtering refers to any filters you create for a tailored support library. Typically, you create filters to select certain records and data items for replication. See “DATABridge Support Library Filtering” in the DATABridge Programmer’s Reference for information on creating filters.

Example:

Suppose a bank has 30 branches, each with a DATABridge client replicating to an SQL Server database. Further, the bank creates a filter for each branch that selects the records that branch should receive.

Without the Tanker Accessory, each time any of the 30 DATABridge clients ran, the Server Accessory would request that DBEngine read the entire audit file. Then, the Server Accessory would request that the Support Library (or whatever library is specified in the Server Accessory parameter file) filter the audit file. Then, the filtered data would be sent to the DATABridge client. This would be repeated for each DATABridge client.

With Tanker, however, DBEngine would read each audit file once and the Tanker Accessory would create a filtered audit file for each branch with only that branch’s records. When the DATABridge client at the branch runs, the Server Accessory uses the filtered audit file for that particular client. You can remove the original audit file any time after the Tanker Accessory finishes reading it and starts creating the filtered audits for the next audit file.

Related Accessories

The Server Accessory (explained in Chapter 5, Server Accessory) and the Span Accessory (explained in Chapter 6, Span Accessory) can both use filtered audit files. For either accessory to use the audit files filtered by the Tanker Accessory, set the PREFILTERED and FILTER options in their respective parameter files.