IB LogManager product family
Introduction
The IB LogManager Product Family is a suite of tools which helps you to keep track of data changes in your InterBase® and Firebirdtm database.
But, it's more than simply integrating a logging/auditing mechanism in your InterBase® and Firebirdtm database, because the available add-on's will help you to manage and to process log data in different ways.
Key Features
Below is a list of key features for IB LogManager.
Your version of InterBase and Firebird is supported
The IB Logmanager Product Family supports InterBase version 5 and up and Firebird version 1 and up
Server-side mechanism avoids application changes
- No need to change existing applications
- Log data-changes for third-party applications
Controlled and extensive auditing
- Table operation based auditing
- Audit certain columns only
- BLOBs are supported too
- User defined conditional auditing
Viewable results
You and your users (or database administrators) can browse, export and print the logged data changes.
Add-on tools
- IBLMPump: Command-line utility to pump/transfer logged data
- IBLMRedo_cmd: Command-line utility to re-apply logged operations on standby databases
- IBLMViewer: Browsing log data as a separate tool
Products & Tools in the Family
The IB LogManager Product Family currently consists of the following products/tools:
IB LogManager
The core product to integrate a server-side logging/auditing mechanism in your InterBase/Firebird database. IB LogManager logs data changes in the database for different data manipulation operations (Delete/Insert/Update) on user-definable database objects (tables, columns). A point-and-click interface enables you to define easily, which database objects should be logged. If you are interested in logging a history of price changes in a table ARTICLE, just define it with one mouse-click and relax.IBLMPump
A command-line utility to pump/transfer logged data from the production database into an external "transaction log" database using the two phase commit (2PC) protocol. By using IBLMPump regularly, you keep your production database tight (logged data will not "pollute" your production database) and in case of a crash of your production database, logged data will not be lost. To regularly pump logged data you can either schedule the pump process by using any task scheduling facility like 'AT' under Windows NT/2000/XP or by using the background pumping option (timer or InterBase®/Firebird event based) of IBLMPump.IBLMRedo_cmd
A command-line utility to re-apply logged operations in your production or transaction log database to one or more hot standby databases. This tool is crucial for keeping your standby databases and your production database in-sync.IBLMViewer
A read-only version of IB LogManager, that uses the existing logging schema. Ideal for users who should be able to browse and export log data, but without the permission to change the logging schema.