Author: Ember Crooks

3

A Newbie Going to IOD

I’m a big fan of the IDUG conferences, so have generally focused my funding and management-convincing on getting to go to the IDUG North American Technical Conference. But now that I’m starting to present at IDUG conferences, I want to consider presenting at IOD as well. But I have never even been to this conference. I’ve been to all or...

31

Transaction Logging Details

Transaction log files are one of the core strengths of a DBMS, if you ask me. The ‘D’ in ACID refers to ‘Durability’. What Durability means is that once a transaction is committed, it is not lost, even if the database crashes or the server it is on has to be restarted. Transaction Logging in DB2 DB2 writes transactions to...

0

A New Guest Blogger is Coming!

I’ve asked another IBM Champion for Information Management – Ian Bjorhovde – to write a guest blog entry on IOD (IBM’s Information On Demand conference for 2013). The conference is in Las Vegas at the beginning of November. This is the first year I am attending IOD, and I am used to the smaller atmosphere of IDUG. Just figuring out...

2

DB2 Naming Standards

Last week, I read this article by Craig Mullins: https://www.sswug.org/craigmullins/sql-server/whats-in-a-name-on-database-naming-standards/. Go read it, this blog entry will still be here when you get back. I have to say that in large part, I agree. I don’t like having differing naming standards for tables and views. And certainly not for aliases. I do like to have a naming standard for constraints...

0

Another TSA State Issue

One of the features I would most like IBM to add into DB2 is the managing of TSA States through DB2 commands. I’m not a TSA expert, but I would like to find a class or opportunity to study it further. There are plenty of scenarios where I have to go in as root and run various commands to get...

3

HADR_TIMEOUT vs. HADR_PEER_WINDOW

It has taken me a while to fully understand the difference between HADR_TIMEOUT and HADR_PEER_WINDOW. I think there is some confusion here, so I’d like to address what each means and some considerations when setting them. In general, you’ll only need HADR_TIMEOUT when using HADR and only need HADR_PEER_WINDOW when using TSA(db2haicu) or some other automated failover tool. HADR_TIMEOUT HADR...

4

Rest In Peace, Adam Schneider

When you go to conferences, you tend to develop a group of friends that you hang out with and compare notes with and spend your evenings chatting with. As a blogger, I also spend time and energy trying to help other DBAs and give them opportunities. Adam Schneider was one of a small group of DBAs I spent my free...