Home » Products » Cyber & Security » AP Journal

iSecurity AP-Journal for IBM i

Database Security Monitoring

Database Monitoring and Reporting

AP Journal hipaa compliance

iSecurity AP-Journal protects business-critical information from insider threats and from external security breaches, and notifies managers of any changes to information assets and streamlines IBM i journaling procedures.  iSecurity AP-Journal logs the who, what, when and which of activities. It logs database access (READ operations) directly into the journal receivers, which is not provided by IBM i journaling and is an important component of compliance.

AP-Journal, database monitoring
Play Video

Technical Workflow

  • Monitors changes to objects, application files and members.
  • Supports periodic file structure changes to application files.
  • Enables monitoring application files across changes to file structures.
  • Programmable field-specific exit routines.
  • Real-time alerts indicating changes in business-critical data; these application alerts are activated by user-defined thresholds.
  • Comprehensive reports displaying all application changes on a single timeline in various formats.
  • Reports can integrate information from all the organization’s applications.
  • Efficient long-term storage based on special journal containers rather than IBM i journal receivers; reports can be based on these journal containers or on receivers
  • Alerts and reports enable users to meet regulatory requirements such as GDPR, SOX, HIPAA, and PCI.
  • Flexible filtering capabilities for selection of detail level and categories
  • Easy to use, requires minimal setup and disk space
  • Complements high availability IBM i products by ensuring full journal receiver synchronization

iSecurity AP-Journal is an Application Security and Business Analysis Solution for the IBM i.

AP-Journal protects business-critical information from insider threats as well as external security breaches. It keeps managers closely informed of important changes in their business-critical data and streamlines journaling procedures.

Users can integrate information from various files and view all changes relating to a specified business item. In addition, AP-Journal helps enforce business rules by triggering external functions.

With its unique technology, AP-Journal logs database access (READ operations) directly into the journal receivers. This functionality, which OS/400 journaling does not provide, constitutes an important component of compliance.

By providing a timeline report of all changes relating to application data, AP-Journal reduces unauthorized activity and enables users to meet regulatory requirements. It also issues real-time alerts to inform managers of any changes in application databases or unapproved access to critical data.

  • Addresses PCI, SOX, HIPAA, etc. requirements
  • Long-term storage of sensitive information, independent of journal receiver lifecycle
  • Advanced filtering enables saving only important information, to suit storage limits
  • READ operations selectively added to Journal, for compliance with PCI requirements
  • Real-time alerts on changes in business-critical data & access, sent as operator messages, e-mail, SMS, SYSLOG; CL Scripts execution
  • Timeline and cross-application reports based upon user-defined business items
  • Report data can include key fields, description fields and modified fields (highlighted)
  • Output as Online, Print, HTML, PDF, Outfile & Email
  • Filter according to “before” or “after” values of each database field. Boolean And/Or, EQ, GT, LE… N/LIKE, N/LIST… conditions refer to percentage or absolute value changes
  • Runs on a High Availability system, reducing performance impact on Production Systems
  • Real-time or scheduled operation mode
  • Who modified file PAYMENTS between 20:00 and 06:00 during vacation; among those, who reduced the PAYMENT_AMOUNT by more than 15%?
  • Who worked on the SALARY file during non-standard business hours, and accessed employees whose salaries exceed $5,000 monthly?
  • Provide John with a timeline report of all changes made to his MORTGAGE (covering the dozens of files in the MORTGAGE application), during the past 25 years.
  • Send an SMS message and e-mail to the company’s Chief Security Officer when the PRICE_OF_ITEM changes by more than 4%.
  • Send a SYSLOG message and operator message when the PRICE_OF_ITEM for an ITEM shipped last month changes by more than $6.20.
  • Send an e-mail when anyone accesses the record of an employee whose monthly SALARY is greater than $5000.
  • What users who are not in the HR department modified the SALARIES table?
  • What changes to the hospital’s PATIENTS file were made via utility application DFU?

Related IBM i Auditing Products