I have a client that has been having some issues that cause both HADR servers to go down at the same time. Ignoring for the moment that it’s a bad idea to share resources that can cause this to happen, they seem frustrated that when both servers come back up, DB2 does not automatically come back up.… Read the restContinue reading »
When I was a kid, I was always the one when my family went to a mall or amusement park or something to say “If we get separated, we’ll meet here”. I’ve carried that early caution into my adult life. Often, I have two or three different levels of backout strategy – even for simple database changes.… Read the restContinue reading »
(For Part 1 of this series, please click 10 Minute Triage: Assessing Problems Quickly, Part 1).
One of my favorite commercials is from a motor oil company. The scene begins with a man who is sleeping soundly. His slumber ends abruptly when he is physically grabbed by the collar, shoved on a treadmill and forced to run in an all out sprint from a cold start to prove a point about the abuse we give our cars in the morning.… Read the restContinue reading »
This is an issue I’m currently seeing on about 2 out of 3 9.7 databases. First, a little background. My reorg script determines if reorgs are needed using reorgchk formulas, and the last couple of weeks, it has picked up the unformatted event monitor tables and done inplace reorgs on them.… Read the restContinue reading »
So if you’re in a multiple-dba situation, you’ve probably got one DBA who is the “scripting guru”. If you’re a lone DBA, you’ve either written or acquired from others the scripts for basic automation of the most simple tasks. Everyone has their shortcuts and tricks.… Read the restContinue reading »
What do you do to prepare for the holidays? We’re starting to think about Black Friday for our retail clients in September or maybe even August. Each business has its Black Friday equivalent – the few days each year that account for 5%(or more) of your online revenue for the year – even if they aren’t anywhere near November.… Read the restContinue reading »