Category: Random

38

DB2 Database Restore and Rollforward: Details of Log Files

I do at least one restore a week. Usually between environments or for setting/resetting HADR, but sometimes real-world recoveries too. Since I’m almost always restoring from online full backups, I’ve developed my restore method and stick to it. It works for the relatively homogenous and standard enviroments that are the bulk of what I support. I’m pretty sure I can...

0

Coming Next Week: A Guest Blogger!

I’ve been thinking about having guest bloggers for a while now. The advantage to me is that I get some help with generating content, which takes hours a week of my time. The advantage to my readers is that you get a different point of view and writing voice. I met Mike two different ways. First, he’s the social media...

13

How to Find the Size of a DB2 Database

How big is it? How much space do we need if we copy it? How big will it be in a year? These are common questions for a DBA. Sometimes we know the answer intimately, and sometimes we have to look it up. If the person asking the question is not a DBA, they expect a hard number that won’t...

2

Happy Blogiversary to Me

It was two years ago I started this blog. In June 2010, I started with a free blog on wordpress.com. At that time, I was a binge blogger. I would blog every day for a week or every week for a couple of months, and then as work got busy, I would skip a few months. I also did absolutely...

0

IDUG 2012 – NA Tech Conference in Denver

Many of my blog posts are ones that can be read two years down the road and still have technical relevance. This is not one of those. This is about how excited I am to go to the IDUG DB2 Tech Conference next week. I have several things I plan to attend and get out of this conference. Certification One of the things...

0

Why DB2 Certification is Cool

You may have noticed that I’m down to one new post a week at this point. I have two big excuses. The first is that I had a big go-live last week that required the movement of user data from one WebSphere Commerce database to another on a more recent version of Commerce, a more recent version of DB2(8.2 to...

1

VARCHAR: Friend or Foe

I read an article from Craig Mullins on “Working with variable data“. The rest of this post is going to assume you’ve read it, so click through and then come back. I’ve seen performance issues caused by VARCHAR before, and Craig makes some interesting points. VARCHARs are actually one of the big reasons to Reorg frequently. His post is geared...

0

Influential People and Moments in My Career

Sorry for the earlier 404. I think this should work. With my 15 minutes of fame as a contestant on the DB2Night Show’s DB2’s Got Talent competition, I’ve been thinking about the turning points and formative forces in my career. I started out as an accounting clerk, and wanted to be an accountant. That was after I got my first...

6

Data Pruning – Do You Have a Strategy in Place?

One of my items to check before go-live is to see that data pruning is in place. Yes, before a website my company supports even goes live, I have at least made the attempt to start pruning the data that hasn’t been collected yet.  I saw this video today: http://smarterquestions.org/2012/02/video-marc-hebert-of-estuate-on-cleaning-data-cholesterol-from-the-enterprise/, and thought I’d write a short post inspired by it. Go check it...