(Willie Favero) Have you noticed a decrease in performance of some queries after migrating to DB2 for z/OS Version 8? I’m referring to those long running applications with SELECTs and FETCHs that process lots of rows and return lots of columns. Those queries that also ran just fine while you were in

(Willie Favero) I actually have my fingers crossed that this entry is one of those warnings that only affect a small handful of customers migrating to DB2 V8. I addressed this issue in a previous entry a few months ago. However, back then, this was just a few sentences in the middle of a whole lot o

(Justin Whitney) Problem: your company is going through yet another “process re-alignment” and you’ve been given the unenviable task of merging multiple databases into one Damn Big Mega System (DBMS). To make the project even more unappealing, your sales group has been using Informix, billing is in

(Michael L. Gonzales) Most business intelligence (BI) and data warehousing initiatives are planned from the top down. BI architects spend many hours on business requirements. Unfortunately, this careful planning is frequently undermined by a lack of attention to the foundation of any successful BI p

(Philip Howard) xkoto is a relatively new company—it only came to market late last year—however, it has some neat technology. The company’s product, called GRIDIRON, provides dynamic load balancing for DB2 in transaction processing environments.

(Craig S Mullins) DSNTEP2 is an application program that can be used to issue DB2 dynamic SQL statements. It is sometimes referred to as “Batch SPUFI” because it allows you to submit SQL in batch similar to how SPUFI allows online SQL execution.

(Paul C. Zikopoulos) In Part 1 of this series, I discussed how to use the Database Explorer view in the IBM Rational Application Developer for WebSphere Software (Rational AD) product to create and work with IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows database connections. Part

(Chris Eaton) Are you the kind of person that can’t sleep at night because you don’t know for sure if you turned the lights off in your living room? So you get up and go downstairs just to make sure only to find out they are already off. And then you get into the office and see that your previous […]

(Cindy Wong and Samuel Poon) This article provides a list of DB2 UDB for Linux, UNIX, and Windows application development materials available on the Internet. The DB2 UDB Information Center is also a good source of information. Many of the items listed below are published as articles on IBM develope

(Omer Brandis) I remember when I first started researching db2 v8 more then one year ago. I remember reading the IBM redbook “Db2 for z/os version 8: everything you ever wanted to know, and more”, over 1000 pages of useful & important information, all of it having to do with Db2 v8 for z/os.