Db2 Experts on a Data Science Quest
Usually, there’s an admin (well, lots of them for different clients) I ask when I have basic questions about system configurations, but like all DBAs, sometimes I need to figure it out myself. Enter db2pd -osinfo.
The -osinfo option on db2pd can give you some of the basic information on OS configuration without having to know or google OS level commands to find it.… Read the rest
Continue reading »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 »Over the last few weeks, I’ve done some pretty in-depth coverage of the IBM DB2 Information Center. One commenter suggested I do similar coverage for the IBM DB2 LUW Support Portal, and it sounded like a good idea to me. Since the IBM Support Portal can be used in a number of ways, I’ll share the main things I do with it.… Read the rest
Continue reading »This post is specific to WebSphere Commerce.
I’m usually pretty critical of the IBM webcasts about WebSphere Commerce. There have been some pretty bad or incomplete ones in relation to WebSphere Commerce databases(“run dbclean” is the most frustrating, general advice ever).… Read the rest
Continue reading »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 1: Navigating
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 »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 »Note: this post refers to an obsolete version of the IBM DB2 Knowledge center, and therefore many of the links are broken. For details on the current version, see The New IBM DB2 Knowledge Center
The IBM DB2 Information Center is a wonderful resource if you know what you’re looking for.… Read the rest
Continue reading »I generally suggest both my readers and my clients turn on the monitor switches using the DFT_MON* parameters in the DBM CFG. However, I find myself using traditional snapshots less and less. The main time I still use them is when I’m panicked and my older training kicks in.… Read the rest
Continue reading »In recent releases, DB2 has offered more and more opportunities for using SQL to get to data we need to maintain our databases. I’m a big fan of some of this new functionality, particularly the mon_ stuff (see My New Best Friend – mon_ Part 1: Table Functions and My New Best Friend – mon_ Part 2: Views).… Read the rest
Continue reading »This series started with Explain Part 1 – Explain and the DB2 Optimizer. This is the second post in the series. I want to cover my favorite method for generating Explain Plans, and in the process, discuss some of the elements.… Read the rest
Continue reading »Generating an Explain Plan is easy…
Properly reading an Explain Plan is harder…
Taking appropriate action is harder still.
When I started my career as a physical DBA with IBM Global Services, generating Explain Plans or even general analysis of SQL was not really a part of my job description.… Read the rest
Continue reading »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 »