The OpenEdge DBA Files

QAD Midwest User Group, September 16-18, 2018 at the Hilton Cleveland Downtown

White Star Software is proudly sponsoring the MWUG’s Fall 2018 conference at the Hilton Cleveland Downtown. The Midwest User Group is a fast-growing body of QAD users and Associates (vendors/service providers) who are improving their business practices and manufacturing processes through the use of QAD’s enterprise application and manufacturing management software.

Read More

The Top 5 Business Continuity Excuses I Hear Every Day

Reader beware: this is going to get ugly

Before we start: if you’re a technical person reading this, please forward to your boss, your boss’ boss and your boss’ boss’ boss. Forward it all the way up the org chart. Print it out and tack it to the bulletin board in the cafeteria. Make sure no one in I.T. management or at the C-level can pretend they didn’t know.

Read More

Dump and Load Strategies Part II: Dumping Data

If you read Part I, you’ve already analyzed your data and designed your Type II storage areas and you’re ready to dump your existing data and load it into the new structure. If you’re still using Type I storage areas, this will probably be the slowest part of the entire D&L process so don’t despair. The load and the index rebuild should take considerably less time than the dump.

Read More

Diagnosing Performance Issues (Part 1 of 8192)

Picture a Rubik’s cube in your mind: at the core is the holy grail of system performance, and every colored tile is a potential bottleneck preventing you from attaining that perfection. On one side, you find database issues, another side is the network, there are the physical servers, and mixed throughout is plain old bad code. Today we’ll focus on a few big red flags related to your physical system resources: CPU, memory and disk.

Read More

Migrating OpenEdge to Linux is Easier than You Think

Over the past 10 or so years, the number of [AIX, HPUX, Solaris] to Linux migrations have been increasing steadily, along with the “safe” recommended maximum number of concurrent users. The reason is simple, of course: cost. Unless your OpenEdge application is serving thousands of users, Linux can probably do the job just as well as one of the proprietary Unix flavours. If you have less than 250 concurrent users then this should be a no-brainer for 98% of you.

Read More

OUCH! Backup Time Stamp on Windows

I was called in to consult at a site where the backups were exhibiting strange behaviour. The backup file was the normal 15Gb in size and the time stamp was from last night, but when they restored it in test there was no new data.  In fact, the most recent data they could find was from a couple of weeks ago.

Read More