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.… Read the rest
Continue reading »Category: Uncategorized
db2caem – Get Actual Row Counts in Your Explain Plans
Edit 2019-04-02: corrected typo in the explanation of the -tbspname option. Also, a colleague notes that a 16K page size table space also works for this.
db2caem is a tool in 9.7 that reports actual row counts in your explain plan alongside your estimated row counts.… Read the rest
Continue reading »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. … Read the rest
Continue reading »Top posts of the year – 2011
So it’s surely a cliché, but since many of my favorite bloggers are doing it, I thought I’d jump on board. So here’s my list of top posts this year. Given the fact that I’m nowhere near 2,000,000 views like Susan Visser, and that I’ve only been blogging for a year and a half, I’m not limiting the list to things I wrote this year.… Read the rest
Continue reading »DBClean – Guest Users
This is part of a series focusing on the details of each item that needs to be pruned in a Commerce database.
Guest Users
What is it?
Guest Users are created by Commerce in the database. Technically they are only needed for when you allow a customer to add items to their cart before logging in or registering, or for a few other actions.… Read the rest
Continue reading »Hello world!
I am at this point an expert on DB2, and on the aspects of DB2 that interact with Commerce, and frequently train clients and new DBAs on how to do what I do, so it's time to share.
Continue reading »