Category: Uncategorized

1

Informational Constraints – Benefits and Drawbacks

One of the most frustrating things a DBA can experience is troubleshooting due to bad data. The client is upset because rows are missing or incorrect data is returned.  The client facing web front end could be displaying gobilty-gook because the data retrieved makes no sense. Resources and energy are burned because of an issue is easily solved with the...

1

Performance Tuning LOBs in a Transaction Processing Environment

Each Monday, I post a technical blog on DB2Commerce.com referencing my “DB2’s Got Talent” presentation from the previous week. However, my topic for Episode 131 “Sit. Stay. Good LOB. Domesticating your LOBs” was based off my first developerWorks article which was published on the same day. Instead of reinventing the wheel with an abbreviated article, I would like to point...

7

(AST) Automatic Storage – Tips and Tricks

This article is based off the “(AST) Automatic Storage Tips and Tricks” presentation for the DB2 Night Show (Episode #130) – DB2’s Got Talent competition held on Friday, March 21th at 11am EST. Progression within the competition is based solely on audience voting. If you found this useful, want to see more like this, and don’t want to see a...

0

Blog Posts Related to March 8 DB2’s Got Talent Presentation

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 related to today’s topic: My...

9

DB2 Basics: What is an Index?

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 restrictive vendors tend to allow...

0

Guest Bloggers Next Week!

The week of December 17th, I’ll be welcoming guest bloggers once again. Mike Krafick, who did a couple of guest blogs for me earlier in the year (10 Minute Triage: Assessing Problems Quickly (Part 1) and 10 Minute Triage: Assessing Problems Quickly (Part 2)) is teaming up with a great SA to bring us great details on using DB2 with...