Author: mkrafick

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

5

Backup Compression Consideration – DB2 COMPRESS vs. GZIP

We interrupt your regular programming for a quick announcement. If you have been reading DB2commerce.com for a while you know I am an occasional guest writer on this technical blog. I’ve worked this year on expanding my comfort zone with regular articles here, a developerWorks article to be posted next week, and I have entered as a competitor on the...

7

Why won’t you just die?! (Cleaning DB2 Process in Memory)

It happens. We joke that it doesn’t. Make sure not tell our Oracle or SQL Server counterparts but occasionally DB2 becomes … How do I put this eloquently? Hosed. Snarled. Non-functional. Zombied (think the “Walking Dead” TV show). Dorked. Sometimes there is a memory leak, instance level crash, trap, or OS issue. DB2 just goes into a bad state and...

0

Twitter Debates

Twitter debates. I’ve never been in one, nor have I actually heard of them until yesterday. But when @DB2Geek hosted a debate on Tuesday, I decided to pop on and see what it was all about. (Search for hashtag #db2debate). It was fascinating. Did automation steal the role of DBA or minimize it? Will our role never die because of...