Db2 Experts on a Data Science Quest
This one seems to baffle some, though like redirected restores, it’s something that is only tough the first few times. If you attempt to restore a 64-bit database on a 32-bit instance using a compressed backup image, you get this scary error message:
SQL2570N A database cannot be restored on a platform that does not match the platform on which the backup image was created.… Read the rest Continue reading »
So questions in this area most often come from DBAs from other RDBMS’s or from developers. I’ll probably write other posts on locks, but here are the basics on deadlocks vs. timeouts.
Ah the wisdom that went into grouping these under a single error code with different return/reason codes.… Read the rest
Continue reading »So my posts on speific error codes that are frequently seen in commerce databases, and what to do about them seem pretty popular. My #1 and #2 posts in # of views (after “Home Page” ) are ones that describe specific errors and what to do about them.… Read the rest
Continue reading »Ok, so this is an issue I ran into recently. The Commerce guys were trying to install a Feature Pack, and got this:
SQL0569N Authorization ID "<authorization-name>" does not uniquely identify a user, a group or a role in the system.… Read the rest Continue reading »
This probably falls more in the DB2 newbie category, but I suspect I may have some readers who are DB2 newbies or at least not veterans.
Several years ago (ok, probably more than 5), DB2 seemed to be considering a “Problem Determination Mastery” certification.… Read the rest
Continue reading »I went through the most common cause of SQL0803 back in a previous post. There’s a rarer cause that can look very similar, and I thought I’d detail it.
The following appears in the stagingprop log.… Read the rest
Continue reading »