And the great content continues. Friday was another great show of DB2’s Got Talent on the DB2Night show. This was the first show where folks in the finals round were eliminated. A great wealth of knowledge, and good presenters too. I suggest downloading the show at http://www.dbisoftware.com/blog/db2nightshow.php?id=493… Read the rest
Continue reading »Category: Uncategorized
DB2Night Show 2014 – Round 1 of the Finals
Judge Klaas Brant had a surprise birthday party thrown for him today, so I stepped in at the last moment to guest judge. I had technical issues – I could talk to the others just fine before the show, but then no one could hear me when it came to show time!… Read the rest
Continue reading »DB2’s Got Talent 2014 – Search Show #4
The entertainment and education of DB2’s Got Talent on the DB2Night Show continues. I recommend watching the download here: http://www.dbisoftware.com/blog/db2nightshow.php?id=488 Also on that page is an extra discount code for the IDUG North American Technical conference in Phoenix in May – it’s even better than the early enrollment discount, so if you are going, check it out.… Read the rest
Continue reading »IDUG NA 2013 Brain Dump
Wait, don’t avoid reading this because you didn’t go to the conference. There is still valuable stuff here. In fact, it is even more valuable for those who did not go. Last year, I posted my brain dump by basically re-writing all of my paper notes.… Read the rest
Continue reading »Heading to IDUG 2013? Learn from my experience.
I don’t know about you, but the first time that I got my approval to go to IDUG’s technical conference – I actually stood up on my desk, did a small jig, clouds parted, and angels sang.
I really did. Don’t look at me like that.… Read the rest
Continue reading »Blogging for DBAs
To go with today’s presentation on the DB2’s Got Talent competition, I wanted to write about blogging and getting involved in the DB2 community. Blogging has brought me great benefits, and just about everyone could contribute to the DB2 community by writing about their own experiences.… Read the rest
Continue reading »Using TSA/db2haicu to automate failover Part 4: Dealing with Problems After Setup
Updated March 2019 with the command to get the first output
Most of what you’ll need to set up and test TSA using db2haicu is in my first few posts on the topic:
Using TSA/db2haicu to automate failover – Part 1: The Preparation
Using TSA/db2haicu to automate failover – Part 2: How it looks if it goes smoothly
Using TSA/db2haicu to Automate Failover Part 3: Testing, Ways Setup can go Wrong and What to do.… Read the rest
A Bit of Friday Fun – a Map of RDBMS Geneology
Are you ever, like me, shocked at the smorgasbord of RDBMSes that some projects seem to want to use these days? Sometimes it seems like database management systems that someone on the project’s sister’s cousin’s aunt heard of are used. A colleague of mine shared with me that a project he’s working on is using MongoDB, S3, DynamoDB, and MySQL.… Read the rest
Continue reading »db2commerce.com Year in Review
In October of 2011, I switched my blog that I had been sporadically writing (post every week for a month or two, then get busy and not post for 6 months) from a free blog to a self-hosted blog. I knew I had a spot coming up on the DB2Night show in January, and I wanted to get serious about this blogging thing.… Read the rest
Continue reading »How to Delete Data From a DB2 Table and Release Disk Space
Edited on 7/18/2012 to reflect lesson learned from a commenter.
First, a disclaimer. This process is only going to work for tables in AST tablespaces. It also will only work for tables that are not MDC, and do not have a clustering index.… Read the rest
Continue reading »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.… Read the rest
Continue reading »DB2 Version 10
There are certainly more authoritative souces on 10 than me, but having just come from the conference and learned at least enough to get certified, I thought I’d share. They seem to be pushing the big data/data warehousing angle, which I find a bit annoying as a OLTP DBA, because I think there are some good/interesting features for OLTP/e-commerce too.… Read the rest
Continue reading »