(Duke Ganote) Just when you think it’s safe, that you know LONG from right, something unprintable happens.

(Alex Woodie) Domino got one (the original “Bumblebee”). JD Edwards, Linux, and the high availability vendors got theirs, too. We’re talking about dedicated System i hardware–or appliances, if you will. So why isn’t there a pre-integrated i OS bundle for business intelligence, one of the fastest gr

(Willie Favero) Way back on 02/13/2008, I posted a little something that discussed a few DB2 9 changes to prefetch. That first post can be found at: Prefetch on, prefetch off, prefetch on, prefetch off, prefetch….

(Andres Voldman and Meng Fu) This article presents tools and techniques to improve the performance of online data cleanups and to minimize the impact to the store. Implementing best practices for SQL tuning, tailoring the statements to your specific requirements, and ensuring that the database is pr

(Kim Moutsos) That relational databases are today’s go-to technology for driving down costs, freeing IT funds, and speeding existing processes may surprise some. But astute observers will have noticed the steady stream of acquisitions, adaptations, and adjustments that keep data management technolog

(Duke Ganote) My DB2-to-Oracle “clone-O-matic” copies most DB2 tables easily into Oracle. But there are half-dozen I can’t just say “CREATE TABLE AS SELECT” because they have columns with LONG datatypes.

(Robert Catterall) Much of the consulting work I’ve done lately (and that I will be doing over the next several weeks) has been focused on DB2 for z/OS-based data warehouse performance tuning. As this subject is very much on my mind, I’ve decided to share some related thoughts in my blog.

Any DBA who has worked on solving performance issues would know about the problems parameter markers and host variables create during query optimization. If you use parameter markers, the query is not compiled every time it is executed, but you end up with a sub-optimal plan since db2 does not know

(Troy Coleman) DSN1COPY is used to copy VSAM, sequential or image copy data sets. As a stand-alone utility, it can function even when DB2 is down. It’s most commonly used to: –Recover a table or index space using an image copy that’s not registered in SYSCOPY. –Copy from one subsystem to anot

(Paul-John To and Ranjani M. Bettadahalli) In this article, learn how to install IBM Informix Dynamic Server (IDS) 11.50.FC2 on Mac OS X. Understand the various stages of installation, configuring the system kernel parameters, accessing the database server, and customizing the installation for use w