Database Maintenance / Best Practices

01 Mar

Posted at 08:00h in Business Continuity, Database Maintenance / Best Practices, High Availability, New DBA by

Unless it's a read-only database, no OpenEdge production database should run without after-imaging. Period. After-Imaging (AI) is an OpenEdge continuous change logging system that stores database changes in specially formatted log files. It allows the DBA to restore a database from a backup then apply all...

07 Jun

Posted at 19:52h in Business Continuity, Database Maintenance / Best Practices, High Availability, Linux, OpenEdge by

In the past few months, two White Star Software customers experienced one-in-a-million interruptions in availability of their OpenEdge application. I’m not talking about FIRE and BRIMSTONE DISASTERS. It was not Irma nor Harvey nor any other natural disaster. I’m talking about events like a construction...

30 Mar

Posted at 19:15h in Database Internals, Database Maintenance / Best Practices, Hints and tips, Migrations, OpenEdge, Performance Tuning, Reorgs and Upgrades by

Congratulations! You finally decided to join the modern world and take advantage of Type II Storage Areas (SAII). Hey – better late than never. There’s a lot of old, out-of-date or just-plain-wrong information out there, so ignore all that stuff. I have conveniently digested some...