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…
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…
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…
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…
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.
