Category: Uncategorized

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

7

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

1

Come Listen to Me on the DB2Night Show on Friday!

I’ve got a spot coming up on the DB2Night Show – a popular db2 webcast. My topic is: “Do what I mean, not what I say! Back-Out Strategies for DB2 Database Changes”. Come and listen!   It’s scheduled for 10 AM Central Time on Friday, December 14th. Sign up using the link on the DB2 Night Show’s page: http://www.dbisoftware.com/db2nightshow/ You...