Each audit log record contains the following transaction items:
* User Info
* Response Time in Milliseconds
* Input Data
* Output Response
Roll-forward Transaction Recovery
With the database backed up daily and transactions logged to a daily audit file, if disaster strikes the server the database can be restored from the backup and the logged transactions can be replayed to bring the database current. This avoids the need for operators to reenter lost data.
Scenario Based Regression Testing
Using a test database, multiple test scenarios can be run and logged to test audit files. At any point in the future, the test database can be restored and the test audit files can be replayed to verify that all the transactions function identically. This allows more thorough and consistent testing of software changes.
Robert Camacho, Director of Software Development, added "During the playback process, date and time functions are adjusted to use the log’s timestamps rather than the current system time. This insures that all time dependent edits and calculations match the original transactions. Each property of the output response is then compared with the log’s original response using Unit Testing Assert statements."
About LPS Founded in 2009, LPS specializes in the automated translation of IBM enterprise and enterprise-compatible COBOL applications into well organized and maintainable C# programs at a fraction of the cost and risk of manual rewriting. LPS also offers: a web transaction server for CICS replacement, conversion of BMS Maps to MVC Models/Views, general JCL translation as well as VSAM and DB2 to SQL Server and DB2 for Linux, UNIX and Windows database migration.