Author: Ember Crooks

3

Happy 5th Blogiversary to db2commerce.com!

This week marks the 5th blogiversary of db2commerce.com! Wow, 5 years! A few statistics: Total posts published (including guest bloggers): 384 Years of averaging one or more posts per week: 3.5 (started in 2012) Total words published (including guest bloggers): 401,245 Longest post: 13,043 words (HADR Tools: HADR Calculator) Shortest post: 27 words (DB2 Haiku – Building Skills) Words published...

2

DB2 Basics: db2look

I was a bit shocked when I searched my own blog for entries on db2look and came up with nothing. While it’s not a complicated tool, db2look is an essential tool. What db2look Can Do db2look is a tool provided with DB2. db2look’s primary purposes are: Mimic Statistics – To generate the SQL to update statistics with the idea that...

nhkoningshof 1

Ember Speaking at DB2 Symposium in Eindhoven on 11 June

For the 5th blogiversary of db2commerce.com, I’m taking a European trip. It has been more than decade since I’ve been overseas, so I’m very much looking forward to it. I’ll be speaking at the DB2 Symposium in Einhoven on 11 June! I’ll be giving a day-long intensive on Lessons Learned Running DB2 for E-Commerce. An outline of what I’ll be...

4

Binding DB2 Base Packages for Various Versions

When connecting between different versions of DB2, you generally need to bind packages from the different versions against the DB2 database. Just because you’ve bound db2ubind and db2cli on the server does not mean that all possible clients connecting in are covered. Sometimes binds happen implicitly, but sometimes they don’t. And you don’t necessarily want to grant a user rights...

6

Giving Automatic Maintenance a Fair Try

I’m a control freak. I think that control freaks tend to make good DBAs as long as they don’t take it too far. My position for years has been that I would rather control my runstats, reorgs, and backups directly than trust DB2’s automatic facilities. But I also try to keep an open mind. That means that every so often...