AccessPath Product 2

[Company Logo Image]

AuditTrail/400

Audit Trail/400 delivers cost-effective database change logging for iSeries customers. Tracking database changes may be required to achieve compliance with aspects of Federal or Corporate regulations, or simply for improved control. Often existing ERP applications do not provide audit trails and customers may be faced with major development projects to implement them.

Audit Trail/400 is simple to use and requires no changes to your ERP software. The product uses database triggers to log changes, not journaling. Changes from all sources are logged. So in addition to ERP application user changes, updates from utilities such as Interactive SQL, DFU and DBU are also tracked. Audit Trail/400 gives you, and the auditors, the complete picture.

Sophisticated Management, Inquiry & Reporting

Audit Trail/400 builds powerful inquiry and reporting functions. Reports show you the complete chronology of field value changes. Inquiries allow you to step backwards and forwards through the history on screen, highlighting the changes. In both cases the before and after values are easy to see.

Audit Trail/400 includes API commands to let you incorporate standard reporting and inquiry functions within local programs. Tracked data is output to DB2 UDB/400 physical files and you can use these like any other file on your system. For example you could develop local programs that use the audit logs, or inquire on them using SQL or Query.

Feature Summary


Ø	Application independent
Ø	Fast performing
Ø	Simple configuration
Ø	Menu driven interface to all functionality
Ø	Uses standard database functionality - DB2/400 triggers (introduced in OS/400 V3 Release 1)
Ø	Triggers only fire if something changes
Ø	Data only logged if selected fields affected
Ø	Tuned to do the minimum of in-line interactive processing, offloading build processing to a server program
Ø	ILE throughout, SAA compliant displays
Ø	User chooses which files, controls, keys and fields to audit using simple panels
Ø	Hard and soft trigger 'suspend' and 'resume' functions for control during system maintenance
Ø	No ERP program changes required so reduces cost of future application software upgrades
Ø	If triggers are being used already you can integrate the Audit Trail/400 trigger with your local trigger
Ø	If the file layout is changed Audit Trail/400 will automatically detect the changed layout
Ø	You can track the program name or database utility that made the change. Identifies the application program name, DFU, Interactive SQL and DDM. Identifies changes made using popular OEM utilities DBU, Surveyor/400 and WRKDBF
Ø	API commands available to call from your code or scheduler for inquiry, report, supersede, purge, suspend and resume tracking
Ø	Self-managing, optional automatic purging of tracking file data
Ø	Data management includes a 'Supersession' function. This lets you segment and 'park' old tracking data, and create a new version of the tracking data file on the fly. After splitting the audit trail data into manageable blocks the older file can be retained for legacy inquiry or deleted when no longer required

Click here for a iSeries Network Product Review: iSeries Network Product Review

Official Audit Trail 400 website: www.cosynsoftware.com

Information Request

[ Home ] [ Up ]

Copyright © 2005 AccessPath Software Solutions Inc.