(Willie Favero) I know that it seems like DB2 for OS/390 and z/OS Version 7 is trying to hang on forever and ever… but I think we may be getting closer to finding out when it’s really going to go out of service (or at least closer than we have to this point). Here is the current state of affairs […]

(Farnaz Erfan and Thomas Friedrich) In today’s information-driven business world, it is very common for database administrators and application developers to face challenges such as accessing and integrating information from disparate and distributed sources and consolidating it into a single unifie

(Chris Peters) Microsoft Excel is probably the most powerful data-access and analysis tool in Microsoft Office. Excel allows for the easy creation of lists, graphs, and reports, and it provides many exceptional features to help make advanced data analysis simple. This excerpt from i5/OS and Micr

(Ming Wei Xu and Yun Feng Guo) WebSphere DataStage is one the foremost leaders in the ETL (Extract, Transform, and Load) market space. One of the great advantages of this tool is its scalability, as it is capable of parallel processing on an SMP, MPP or cluster environment. Although DataStage Enterp

(Bonnie Baker) In this column, we’ll look at how DSNZPARMs are used to control the maximum number of locks we may acquire, the length of time we’ll wait for a lock, and other system-level issues. We will also explore timeouts, lock escalation vs. lock upgrades, and deadlocks. And, we’ll find out how

(Willie Favero) This entry had its real beginnings a few weeks ago when I talked about private protocol really getting removed from DB2… finally. That discussion started in my blog entry on August 11, 2006: Countdown to the end of DB2’s Private Protocol. At that time I mentioned a REXX exec being sh

(Dave Warner) Apache Derby signals a sea change in both desktop and Web-based applications. For the first time, that elusive target for developers — complete data portability — is easily attainable. This tutorial, the first in a series, shows how you can use Derby as a data store to overcome row-l

(Craig Mullins) When designing DB2 databases a frequently heard request is for a column that contains sequentially generated numbers. For example, each row has a counter associated with it. When a new row is inserted, the counter should be incremented by one for the new row. This way, each new DB2 r

(Hernando Bedoya, Nicolas Bueso Quan, Monti Abrahams, Luis Guirigay, Sabine Jordan, Dave Martin, Barry Thorn, Steve Tlusty and JaeHee Yang) The IBM System i family, which encompasses the IBM AS/400, eServer iSeries, eServer i5, and System i5, has a successful 24-year history of satisfying hundreds o

(Krishnakumar Balachandar) This tutorial shows you how to set up an SQL realm to implement database security for a Web application using the no-charge Java kick-start package. (R)