SOJOURN

The Problem

Journaling is the process by which changes made to data are tracked in a database. The data is not stored by AS/400 journal management system user friendly format. There is no facility available to query data. There is no security measure that will allow one to monitor any unauthorised changes to data. The journal reports are extremely difficult to decipher and read. Being a dynamic requirement, programs to extract reports from the Journal will be very time consuming and require high level of programming knowledge.

The Solution Sojourn a tool for tracking changes to database transactions for the IBM iSeries platform. It can be used by auditors/systems staff to review database transaction history over a selected period of time for any part/s of the database.

The Benefits Users can define application areas to separate out portions of 'the data' belonging to different business areas. Provides focus into specific components of the data of particular interest. Ability to format the way data is presented Assistance with journal management. Transaction history over 'long periods' of time- unlike Query/400 which only reports on the 'current' content, and only the current content, of database records. Query/400 also will not track what changes have taken place against a given record - such as a travel booking, or an order no or a bank account no unless the customer's application has taken the trouble of recording these changes in other separate files. Sojourn can also report on who made the change, using what program (and they can see whether this is standard or otherwise) when and what the record contained before and after. This is totally different to Query/400. Preserve system security· Avoidance of system performance overhead.

ALLIANCES & PARTNERSHIPS - UK - USA - SINGAPORE - ARABIAN GULF