Configure single sign-on for WebSphere Portal V5.0.2 and DB2 Content Manager using a common LDAP directory.

(Paul Holm) Many of you are familiar with the capabilities provided with the green-screen product called Query/400. As you know, businesses use Query/400 to generate reports by selecting and sequencing files and fields using DB2/400 files. With the world moving away from green screen toward browser-

(Christopher Byrne) In the last article, I talked about the introduction of DB2 as an optional back-end data store in Lotus Notes & Domino 7. This discussion centered on what the new threats and vulnerabilities are that need to be recognized by application developers, what information systems au

This document describes a set of DB2 Replication performance measurements collected on a single zSeries LPAR, non-data sharing z/OS system environment. (R,pdf)

(Craig Mullins) I have a process that loads data through a nightly job. Say for example the job drops all the indexes and then loads the data and rebuilds the indexes. Is there an easy way to check if the indexes exist before even starting the dropping of the existing indexes. In some cases the proc

(Christopher Byrne) Though Lotus Notes/Domino developers and administrators may think that someone on mind-altering substances created relational database concepts relating to systems controls, I am not talking about The Electric Kool-Aid Acid Test, made famous by Tom Wolfe in the 1960s. And I do no

(Alexander Kuznetsov) This article uses examples to illustrate cases in which adding a column or two to an index can boost a query’s performance by “covering” the columns used in a SELECT statement. The DB2 optimizer is very good in recognizing such situations and can choose a very efficient executi

(Paolo Bruni) DB2 for z/OS is the database of choice for critical data for many enterprises. It is becoming more and more important to protect this data in case of disaster and to be able to restart with a consistent copy of the DB2 data as quick as possible and with minimal losses. A broad rang

SmartDBA solutions optimize performance of your DB2 UDB for z/OS and OS/390 databases by providing a comprehensive solution for monitoring and managing your environment through a single, integrated console. You can reclaim space and proactively prevent outages as well as analyze, diagnose, and tune

(Susan Lawson) Explore some of the more powerful features of DB2’s SQL language. Learn about the extended programming features, User-Defined Functions (UDFs), table functions, triggers, and user-defined data types (UDTs).