Track Structural Changes in DB (Auditing not enabled)

[kasundha]

OE 11.7.19
OS : - AIX 7.2.0.0

As an audit requirement, I want to track structural-level changes in the DB.

1. Adding new extents.
2. Loading DF files.
3. online backups.

or any other changes in the db. (Not data level changes).

 

[Rob Fitzpatrick]

If you have an audit requirement, i.e. you need to provide data from an audit trail that is uninterrupted, unimpeachable, authenticated, and secure, to satisfy an auditor, use OpenEdge Auditing. Any solution short of that, which captures similar information, is just logging.

If you don't want to use OpenEdge Auditing for some reason, you could look at enabling key event logging.
https://docs.progress.com/bundle/openedge-database-management-117/page/Stored-key-events.html

OE 11.7.19
OS : - AIX 7.2.0.0

If you're planning to stay with OpenEdge, you should also have a plan to migrate away from AIX. Progress no longer supports AIX after release 12.5. Note also that OpenEdge 11.7 will retire in April 2025.
https://docs.progress.com/bundle/openedge-life-cycle/page/OpenEdge-Life-Cycle.html

 

[kasundha]

If you have an audit requirement, i.e. you need to provide data from an audit trail that is uninterrupted, unimpeachable, authenticated, and secure, to satisfy an auditor, use OpenEdge Auditing. Any solution short of that, which captures similar information, is just logging.

If you don't want to use OpenEdge Auditing for some reason, you could look at enabling key event logging.
https://docs.progress.com/bundle/openedge-database-management-117/page/Stored-key-events.html


If you're planning to stay with OpenEdge, you should also have a plan to migrate away from AIX. Progress no longer supports AIX after release 12.5. Note also that OpenEdge 11.7 will retire in April 2025.
https://docs.progress.com/bundle/openedge-life-cycle/page/OpenEdge-Life-Cycle.html

Thanks.

Yes, we are planning to move AIX to Linux and upgrade the OE version too.