The OpenEdge DBA Files
This week, Patrice Perrot from PROGINOV joins Paul Koufalis to talk about deleted key placeholders.
After a massive data purge, you run idxcompact, right? You want to remove all those deleted key placeholders polluting your index.
Guess what? Idxcompact doesn't remove those placeholders the way you think it does.
What is a Deleted Key Placeholder?
From the Progress Documentation:
Today’s blog post comes from Jaison Antoniazzi, a 20+ year OpenEdge expert from Brazil and author of two books in Portuguese on OpenEdge.
Jaison has embarked on an ambitious project for 2022: 365 days of Progress OpenEdge development tips, which he is sharing on LinkedIn!
Tip #1: Setting up a development env
This first tip is to create a development shortcut for building programs. First step is to collect three files that we will use in this shortcut, these are:
Blocked sessions are the silent killers of enterprise applications. No one in IT notices there's a problem until the business is seriously affected.
Read on for more soul crushing, database corrupting, career killing ways to CRASH your OpenEdge database!
Linux "Out of Memory Killer"
A Linux self-preservation mechanism, the OoMK terminates a process when memory is over-committed. Unsurprisingly, the OoMK kills the process consuming the most memory, which, most likely, is the database broker process.
A quick Google search will turn up numerous interesting articles on how to avoid this situation, including ways to tune "oom_adj". In practice, though, it is unlikely that your database will be spared and you are better off making sure that you have ample memory to handle the expected workload on your server.
ProTop is a living breathing entity. It is growing and changing all the time. Be sure to regularly update your installation to ensure you have access to all of the great new features, enhancements and fixes. Here's how...
A catalog of wince-inducing practices to be avoided for the OpenEdge or, indeed any, database.
Why is storage so important in a world of 99.9% buffer hits? I’m glad you asked!
Welcome to our monthly ProTop newsletter, where you’ll find out what’s new, tips and tricks and other cool ways to use both the free and commercial versions of ProTop.
Visibility is one of the key themes when it comes to ProTop, and having the ability to see how the various objects in your database are growing is the focus of the storage statistics trends dashboard.
You may have heard that there is a critical security vulnerability in the “log4j” library that is used by many applications in the Java ecosystem and you might be wondering if this impacts your OpenEdge environment.