(Robert Catterall) I recently gave a presentation on DB2 stored procedure trends and technology to a room full of application developers and DB2 DBAs, part of a “lunch and learn” program organized by a large company in the retail industry. Seated next to me at my table was a DB2 DBA manager, and as

(Deb Jenson) This article provides a brief overview of the functionality and packaging of some of the key Data Studio products from the IBM integrated data management portfolio, including Data Studio, Rational Data Architect, Data Studio Administrator, Data Studio Developer, and Data Studio pureQuer

(Mark Mulligan) If you have application jobs or users that run the DB2 load utility and would like to keep track of this information over time there is valuable information stored in the DB2 diagnostic log file that can help you accomplish this. Detail information about each table load and index bui

(Allan Luo and Gary Chen) Learn how to configure and customize a client application authenticated to IBM InfoSphere Master Data Management (MDM) Server through its authentication services, in Part 2 of this series. This article provides the detailed configuration and implementation for two scenarios

(Nelson King) You can’t step into the same stream twice, said the Greek philosopher Heraclitus. Of course, he wasn’t thinking of data streams or stepping at millisecond speed.

(Martin Gandar) BMC Software is one of the leading players in the market for DB2 database administration solutions with a portfolio of products (BMC Database Administration for DB2) that help optimise the effective use of DB2 on the mainframe. (pdf)

(Michael Sansoterra) I’m trying to set up a stored procedure on our iSeries that can change the server connection to whatever the calling program needs before it runs its query. Your article, Using DRDA to Execute SQL Statements on Another iSeries, seems to address the issue of running SQL statement

(Colin White) To satisfy increasing information volumes, a variety of new database techniques are appearing on the market. Does this mean that after over a quarter century of development, relational database systems are reaching the end of their useful lives?

(Dave Beulke) Last time I wrote about some of the application performance aspects. This week well delve deeper into DB2 Checkpoint aspects for recoveries and index definitions over your busiest tables and their potential performance impact.

(Willie Favero) After about the 10th e-mail asking if I could forward the queries that determine the size of your warehouse on DB2 for z/OS so you can join our Terabyte Club, I thought I would make them available to everyone here.