Binding Packages

I approach binding from a physical/system DBA point of view. I’m not an application developer, and don’t understand all the possible intricacies of binding. But there is some information and tips I can share on binding packages in DB2. There are definitely some application developer topics included here.… Read the rest

Continue reading »

Tips for Using the IBM DB2 Information Center Part 3: Information Structure – Parameter and Message Reference and General Guidance

This article is the third in a series about the IBM DB2 Information Center. Please check out the other articles in this series:

Tips for Using the IBM DB2 Information Center Part 2: Information Structure – System Monitor and Syntax

Tips for Using the IBM DB2 Information Center Part 1: Navigating

Adminstration Guide: Performance / Parameter References

Man, it would be hard to choose a favorite if I had to choose one of these sections I'm describing in this post.… Read the rest

Continue reading »

Tips for Using the IBM DB2 Information Center Part 2: Information Structure – System Monitor and Syntax

My goal with this series is to provide some tips and tricks you might not be aware of for finding information in the IBM DB2 Information Center.

Check out Part 1 in this series: Tips for Using the IBM DB2 Information Center Part 1: Navigating

As I mentioned in Part 1, I started working with IBM DB2 documentation just before the IBM DB2 Information Center became the standard.… Read the rest

Continue reading »

When is ‘AUTOMATIC’ Not STMM?

Somewhere along the line, I associated ‘AUTOMATIC’ settings for parameters with DB2’s Self-Tuning Memory Manger (STMM). But the two are not associated. Sure, if STMM is set to ON, then some parameters set to AUTOMATIC will be tuned by the STMM, but many parameters can be set to automatic whether STMM is ON or not.… Read the rest

Continue reading »