Please go to http://www.dbisoftware.com/blog/db2nightshow.php?id=425 and scroll to the bottom to fill out the “Show Survey” to vote. If you’re reading this, chances are you’ve gotten something out of my blog. A tip when you needed it, a reminder when you weren’t thinking about something, or the answer to a problem when you were searching. Now [...]
{ 2 comments }
I don’t often make changes to existing tables. The WebSphere Commerce database comes with defintions in place. We make customizations that are largely adding columns or adding tables or adding indexes. It is pretty rare that we have to alter one of the handful of custom tables in some way. What this means is that [...]
{ 1 comment }
Friday, March 8, I’ll be presenting on DB2′s Got Talent on the DB2Night Show again. My topic is “A few tips for finding problem SQL using MON_GET_PKG_CACHE_STMT”. I’ll post the replay once it’s available and at that time will ask for your votes in round 2 of the finals. Here’s a blog post that is [...]
{ 0 comments }
Introduced with DB2 9.7 were a large number of table functions starting with ‘mon_’. Plus a few views and other interesting tidbits. The more I use them, the more I become addicted to them. In part 1 of this series, I covered the MON_GET table functions. In this post, I’ll talk about some nifty views [...]
{ 0 comments }
This is clearly a broad topic, and this post is intended to serve as an introduction. Authentication The first step in accessing a db2 database is Authentication. Authentication is what tells DB2 that you are who you say you are. Simply put, DB2 does not do authentication. It relies on some other facility to perform [...]
{ 0 comments }
Ever notice that the DB2 Info Center goes down sometimes? The DB2 Info Center is a critical reference for DBAs, and if you cannot get to it, sometimes you can’t do your job fully. When I worked for IBM Global Services, I could get discounted rates on the Books themselves, so kept a bookshelf-wide copy [...]
{ 5 comments }
As the judges flipped roles to become the contestants this week, I thought I’d flip roles and write a summary blog like Susan Visser often does of the show. Review of Show We had 4 talented participants this week! It is intimidating to present in front of an audience, and I’d like to thank the [...]
{ 2 comments }
Don’t call them indices in the United States – most American DBAs agree that they are ‘indexes’, though either plural form is grammatically acceptable in American English. Indexes are arguably one of the most important aspects of database design. They’re also something that we can pretty easily change and add to over time. Even overly [...]
{ 2 comments }
Especially with TSA and db2haicu, sometimes you see an error, and you have a bag of tricks that you try, even though you don’t understand exactly why they work. In this case, I had a brand-spanking-new server, with DB2 installed the very same day, and no matter what I did, db2haicu would fail on creating [...]
{ 0 comments }
This post should be a quick one. In older versions of DB2, we had to worry a lot more about tablespace states. Within my career, I can remember that a LOAD operation would put a whole tablespace into “LOAD PENDING”, and if that LOAD operation failed in certain ways, the tablespace would get stuck in [...]
{ 0 comments }
