Today’s blog post comes from Jaison Antoniazzi, a 20+ year OpenEdge expert from Brazil and author of two books in Portuguese on OpenEdge.
Finding code : Lock Table Overflow
Use ProTop to monitor and alert for lock table usage and discover the cause of lock table overflows in your database application.
OpenEdge Collections: What are they? Why use them?
Why are Collections practical when developing Progress OpenEdge applications?
It's Time to Manage Your Extents!
"Will ProTop tell me when it is time to add a new fixed and or variable extent to my OpenEdge database?" It most certainly can.
New Programmer Series: Adding a Test Database
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 #2 - Creating a test database
Now that we have a shortcut opening the Desktop or the GUI Procedure Editor and the AppBuilder ready to develop (see Jaison's tip #1), I am throwing cold water... Calm down! We must create and set up the test database for what we are going to do!
Schema Area Gotchas
The schema area should not be used to store application data. And, if you are getting ready to dump & load, certain schema attributes require special attention.
The Curse of Deleted Key Placeholders
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:
New Programmer Series: Getting Started with the OpenEdge ABL
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:
Finding Code: Blocked Sessions
Blocked sessions are the silent killers of enterprise applications. No one in IT notices there's a problem until the business is seriously affected.
New DBA Series: Please Don't CRASH Your Database AGAIN!!
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.
