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.
Below is a list of key features for IB LogManager.
You and your users (or database administrators) can browse, export and print the logged data changes.
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.
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.
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.
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.