A hub for sharing relational database knowledge and experimentation
(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 rest
Continue reading »To eliminate any confusion – I am not Ember. Ember is a little shorter, with a big smile, and glasses. I was lucky enough to meet her through a mutual friend at the IDUG 2012 Conference in Denver just a few weeks ago.… Read the rest
Continue reading »Edited 9/6 to correct syntax and Grammar.
9.7
HADR_PEER_WINDOW
Database Configuration
> db2 get db cfg for sample |grep HADR_PEER_WINDOW HADR peer window duration (seconds) (HADR_PEER_WINDOW) = 0
OR
> db2 "select name, substr(value,1,16) value, value_flags, substr(deferred_value,1,16) deferred_value, deferred_value_flags, substr(datatype,1,16) datatype from SYSIBMADM.DBCFG… Read the rest Continue reading »
This is my second post in my TSA/db2haicu series. The first porst, Using TSA/db2haicu to automate failover – Part 1: The Preparation, is a must-read before trying anything lined out in this post.
If you’ve done the preparation properly, you have the following already defined/done:
In our example, I’ll be using:
174.13.101.192 spp05db01r 4032312-Prod-db1.adomainl.com… Read the rest Continue reading »
Edited 8/3/2012 to add a detail about db2cptsa and to put db2nodes.cfg in its own section.
I’ve actually been hating db2haicu lately. I had 3 different environments where I had to set it up over the course of about 2 weeks, and none of them went simply and smoothly.… Read the rest
Continue reading »My goal here is to inspire you to test at least some small part of your recovery strategy. This post is tied to my spot in the Talent Search portion of the DB2’s Got Talent competition on the DB2Night Show, but it can also stand alone.… Read the rest
Continue reading »So believe it or not, when I was a newbie dba doing the very basics on internal databases at my first job, I didn’t even know what some of the databases I supported did. I learned over time, but sometimes it was months before I knew or understood.… Read the rest
Continue 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 rest
Continue reading »HADR is DB2’s implementation of log shipping. Which means it’s a shared-nothing kind of product. But it is log shipping at the Log Buffer level instead of the Log File level, so it can be extremely up to date.… Read the rest
Continue reading »