MAI
22
0

The Top 5 Business Continuity Excuses I Hear Every Day

The Top 5 Business Continuity Excuses I Hear Every DayReader 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.

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 crew 3 kilometres away cutting through a fibre link, or a random operating system bug corrupting files left, right and centre. My customers felt the wrath of events that were totally random and completely unavoidable. One customer was prepared and the other was not. Even for the one that was completely prepared, the costs to the business were significant.

Lire la suite
264 Hits
SEP
07
0

Diagnosing Performance Issues (Part 1 of 8192)





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.

My CPUs are on FIRE! 

When it comes to CPUs, you need to know one thing and check three:

Lire la suite
8609 Hits
MAI
01
2

Dump and Load Strategies Part II: Dumping Data

Dump and Load Strategies Part II: Dumping Data

Wow - it's been a month since my last blog entry. Time flies!

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.

You have three choices when it comes to dumping your data:

  1. ASCII Dictionary Dump
  2. ASCII Custom Dump 
  3. Binary Dump

This blog post is going to concentrate on the binary dump as that's what most of you are going to use. Unless the database is very small or you need to do some conversions during the dump, there's really no reason to use the dictionary dump for anything other than users and sequence current values.

Lire la suite
Commentaires récents pour ces articles
Paul Koufalis
I did not mean "in series". I really meant "in parallel". I try to run as many binary dumps as possible all at the same time. Yes ... Read More
jeudi 7 mai 2015 09:35
30979 Hits
MAR
30
4

Dump and Load Strategies Part I: Type II Storage Areas

Dump and Load Strategies Part I: Type II Storage Areas

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 useful, pertinent and correct information right here.

Basic stuffYou need OpenEdge 10DB Block Size: Pretty self-explanatory. Typically 8Kb on UNIX and 4Kb on Windows and LinuxBPC = Blocks Per Cluster: The number of database blocks formatted each time an object requires more spaceValid values are 8, 64, 512RPB = Records per Block: How many ROWIDs should be reserved for each database blockValid values are 1, 2, 4, 8, 16, 32, 64, 128 or 256Keep data, indexes and LOBs segregated Storage area are typically defined in a file called dbname.st Controversial Assumptions 

A few seasoned DBAs will disagree with the following assumptions. These DBAs are wrong except in very specific cases (0.1% of you) and I can and have proven it mathematically.

Lire la suite
Commentaires récents pour ces articles
Paul Koufalis
For such small databases (10 Gb), I wouldn't even bother with any of that. I would just create two SAII for data and two SAII for ... Read More
mercredi 6 mai 2015 20:02
Paul Koufalis
You are correct. I will fix.
vendredi 8 mai 2015 13:38
32903 Hits
MAR
08
5

Is Progress Going to Audit Your Licences? YES!

Is Progress Going to Audit Your Licences?  YES!

Disclaimer: I am not a lawyer and this is not legal advice. The information below may or may not be applicable in your environment.

How many of you have been through a licence audit recently? If you haven't then expect it...and soon. Progress has relied on honour-based licensing for 30 years and now...well...maybe now they're questioning your honour just a little bit!

Lire la suite
Commentaires récents pour ces articles
Tom Bascom
One small comment -- do not assume that you are under-licensed. Many clients discover that they have a bunch of licenses that the... Read More
lundi 9 mars 2015 11:33
Paul Koufalis
@Montoya: I would expect yes.
mardi 17 mars 2015 18:09
Paul Koufalis
Eric, Having dealt with a number of SAM auditors at Progress, I can tell you that there are some that do understand the technolog... Read More
lundi 16 novembre 2015 13:33
32276 Hits
FéV
23
3

Migrating OpenEdge to Linux is Easier than You Think

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.

Here are some points to consider for the OpenEdge migration:

Lire la suite
Commentaires récents pour ces articles
Kandavel Elangovan
Very useful info!! Waiting for your blog on OE Upgradation
mardi 24 février 2015 13:07
Paul Koufalis
I usually setup my printers as raw and manage the interface scripts from the application or through a simple bash script.
mardi 23 janvier 2018 11:24
33979 Hits
FéV
13
0

OUCH! Backup Time Stamp on Windows

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.

Looking at the DB log file, it didn't take long to ascertain that the backups were actually failing.  On Windows, if the backup file already exists, probkup just writes on top of it without resetting the size to zero. Furthermore, even if no backup ever occurred, probkup still "touched" the file, changing the time stamp.  The result: a full sized backup file with a valid date and time stamp but still the contents from two weeks ago.

Lire la suite
30000 Hits