Db2 Experts on a Data Science Quest
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 »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 »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 »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 »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 »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 »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 »This is part of a series focusing on the details of each item that needs to be pruned in a Commerce database.
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 »