Db2 Experts on a Data Science Quest
A story of fail and recover.
Sometimes, I think that I subconsciously knew that something was wrong. I woke up before 5 AM and couldn’t get back to sleep for no real reason that I could figure out.… Read the rest
Continue reading »I’m spoiled. While we build a fair number of environments each year, we also have basic starting standards. Because of this, I sometimes miss the basics when a problem shows up. Or at least it takes me longer to get there.… 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 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 »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 »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 »Have you ever had to alter foreign keys in a way not supported by mere alteration? Dropping and re-creating all of them can be quite a chore, but a little SQL can make it easier. In this post, I’m sharing my experience and SQL in hopes of helping others who have to do the same thing.… Read the rest
Continue reading »This post is specific to DB2 for UNIX or Linux. SQL1042C can have a number of causes and be received as an error from a number of different commands. The IBM Support Portal does a good job of coming up with the issues and solutions.… Read the rest
Continue reading »As I mentioned in a recent post, I do a lot of restoring databases to get them from one server to another. On rollforward after a recent restore, I saw this:
$ db2 force applications all; db2 deactivate db WC037P01; db2 "restore db WC037D01 from /app/IBM/db2/db_bkup taken at 20120723030327 into WC037P01 logtarget /app/IBM/db2/db_bkup/logs replace existing without prompting" DB20000I The FORCE APPLICATION command completed successfully.… Read the rest Continue reading »
This was a new one for me, so I thought I’d write up a quick blog entry on it. After creating a new instance and a new database, and even after executing one db2set command successfully, I got this:
> db2set DB2_CAPTURE_LOCKTIMEOUT=YES DBI1306N The instance profile is not defined.… Read the rest Continue reading »
This is a new blog post format I’m introducing. I’m declaring Wednesday Parameter Day. That means each Wednesday, I’ll pick a parameter and cover it in excruciating detail. Some of the details will come straight out of the info center, but I’ll add my own experiences and insight geared towards e-commerce databases and throw in specifics for WebSphere Commerce from time to time.… Read the rest
Continue reading »