The OpenEdge DBA Files

SuperGeek Video Series: the -hash Parameter

The -hash parameter is one of those little-known, often misunderstood parameters that can cause you a LOT of pain if set incorrectly. Trust us, we’ve seen it kill performance on numerous occasions!

Check out the video below and JC’s blog post “The Smoking Gun” (2021-07-05) where he talks about a real-world production environment where they just couldn’t figure out why performance was sooooo bad!

 

 

Read More

User Died, DB Crashed, Business MAD!

Anyone who has been around the OpenEdge world for a while has had to face the dreaded “User died holding shared memory latch. ABNORMAL SHUTDOWN” crash. While this sometimes happens as a result of a Progress OpenEdge bug, more often than not it’s a human error. Here are three key points to understand in order to minimize the chance of crashing your database when trying to terminate a shared memory client.

 

Read More

ProTop Newsletter May 2021

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.

In this month’s issue: Programmer Mode, and why every developer should have the free version of ProTop RT (Real Time) up on their screen when writing queries.

Read More

New DBA Series: Frequently Useful Numbers

“One Size Fits ALL” may be acceptable when talking about thong sandals or knit caps (it’s not entirely true even then). However, it is an obvious mistake when talking about bicycles, swimwear, and all manner of measures used in administering OpenEdge databases. That said, below is a list of metrics that can provide properly fitted insight into your database’s operational status.

Is the DB up?

Okay, so it’s not a number or a statistic, but it is certainly the most critical question. Along with this, who do the users call first? Is it you or somebody else? Know who’s going to get the call, and be sure they can always answer that question!

Read More