(Tom Huntington) Do you need to extract transaction data to your PC for analysis? Is the amount of data too large for your PC to handle? Do you need to move (pivot) the data in a spreadsheet for ease-of-use? Do you have staff members who need to take the data on the road to critical accounts?

(Willie Favero) The DB2 for z/OS Version 8 Installation Guide’s (GC18-7418) seventh edition is now available for download from the DB2 V8 library web site as of August 2007. This edition of the Install Guide is just a little more than a month old and should now be the only copy that you all will be

(Dan Jemiolo) The Project Zero development platform includes a data access library that is easy to use, allowing developers to execute SQL statements from their application code with minimal configuration. In fact, setting up a database and connecting to it requires just a four-line configuration fi

(Willie Favero) You may remember back on July 13, 2007 in a post called “A “bandage and an aspirin” for your compiler frustrations with DB2 V8″, I wrote about the DB2 Version 7 precompiler being ported to DB2 Version 8 to enable you all to move off of V7 and upgrade to V8 without worrying about upd

(Eric Long) Learn how to build a robust Web application using Rational Application Developer, DB2, and WebSphere Application Server in this two-part series. In this tutorial, you’ll learn how to install, set up, and configure trial versions of Rational Application Developer for WebSphere Software, D

(Scott Hayes) Let’s take a look at a cost measurement that can help you detect the presence of Index Leaf Page scans, BPLITX. While perhaps not as costly as data page scans, index leaf page scans can quickly suck your CPUs dry of processing capacity and rob your organization of performance that it w

(Kent Milligan) How can I access a sequential file faster with the help of index? Can we use a SELECT statement with index clause to achieve this? (R)

(Willie Favero) No, I’m not going anyplace, I hope… well at least not very soon! At least that’s what my wife thinks at least. I am pretty sure that most of my family and friends truly believe that I will someday come to my end sitting in an airport, waiting on a delayed flight, clutching my noteboo

(Deng Peng Zhou) Service-Oriented Architecture (SOA) is a popular method for designing enterprise applications, because it provides benefits like reusable components and platform-independent communication. When considering an SOA, it’s essential to factor in data integration. A great deal of legacy

(Troy Coleman) When developers are writing SQL statements to retrieve data they aren’t always thinking about how DB2 is going about accessing that data. The SQL query is written then executed to verify the correct data is being returned. Unless some kind of change control or standards are put in pla