(Scott L. Forstie and Andrew J. Sloma) Understanding and implementing the best SQL query optimization goal can improve many queries’ response time greatly. DB2 for i5/OS on V5R4 delivers a new way to control query optimization through several popular dynamic SQL interfaces. This article shows how to

(Joe Pluta) Ah, it’s been a long time since I went on a serious rant. For some time now, I’ve been the kinder, gentler Joe Pluta, with lots of time spent telling you the wonderful new things in both the IBM product lines and the larger IT world in general. I’ve managed to be diplomatic and even doci

(Chris Eaton) It’s often the case that you want to find the row for which one of the columns in that row contains the maximum value for a set of rows. For example, show me the name of the person that makes the most money in department 101. Or show me the customer that made the largest single purchas

(Mike Cain and Jackie Jansen) For most people, the database engine and query optimizer comprise a “black box.” To get data-centric work accomplished in your applications, you issue structured query language (SQL) requests to tell DB2 what to do, not how to do it. The query optimizer determines the b

(Margaret Myslinska, Andrew Nere, David Swenson, Gloria Velazquez, Kathryn Lamont and David Peraza) Learn how to install PHP and DB2 on System i, and understand how to port a MySQL application to DB2 on i5/OS. Understand the history and architecture types of PHP, including the new architecture that

(Willie Favero) Since IFCID 225 (storage usage details) was introduced to DB2, it has been recognized as a critical tool in managing a DB2 subsystem’s storage. We have been telling customers to insure they have class 6 included when they start up their Statistics and/or included in their list of sta

(Howard Fosdick) IBM Content Manager helps companies manage and integrate all forms of information, including data, images, documents, audio, video, and so on. It provides a flexible, comprehensive mechanism for capturing, integrating, and managing these diverse information assets across their life

(Craig S. Mullins) It is always a good idea to keep your bag of SQL tricks filled with techniques to help you deal with troubling application development problems. Hopefully you will find something useful in the ensuing sections as you build your DB2 applications.

(Wei-Dong Zhu, Satya Bhamidipati, Elena Bogdanova, Toralf Gerstaecker, Ryan Lott and Donald Wilcox) In today’s business environment, e-mail has become one of the most commonly used form of corporate communication. It is one of the core tool to conduct business transactions and it generates a signifi

(Qing Fa Wang and Zhi Ping Yang) In this article you will learn how to integrate Microsoft Excel and XML documents using a WebSphere Information Integrator federated system. We begin with a discussion of the basic concepts of a WebSphere Information Integrator federated system, and then explain how