(Kent Milligan) Occasionally, a programmer or user issues an SQL-based report that runs much longer than anticipated. The long-running query may be caused by the user underestimating the complexity of the query or by the size of the data sets being searched. In these situations, it’s nice to be able

(Jun Tao (Tony) Cui and Yu Wu) In this series you’ll learn how to monitor a process in WebSphere Process Server (Process Server) using WebSphere Business Monitor (Monitor). Part 1 describes the configuration steps for integrating Process Server and Monitor. Without enabling security, the integration

(Craig Mullins) Database performance problems are not caused by magic. Indeed, all performance problems are always caused by change. That statement flies in the face of what I normally say, which is “Almost never say always or never”… but in this case, it is true.

(Manas) With the holidays just around the corner, this is the right time to add to the spirit by announcing the new release of Data Studio 2.2.0.1 (the complimentary tooling for DB2 and IDS). Along with improved quality, following are the two significant functionalities we added:

(Derek Tempongko and Paolo Bruni) This IBM Redpaper provides information about how to setup and configure DB2 9 for z/OS with Secure Sockets Layer (SSL) using the z/OS V1R10 Communications Server: IP Application Transparent -Transport Layer Security (AT-TLS) services. This paper also covers the basi

In this screencast Rav Ahuja walks you through getting started with IBM DB2 9.7 database server on Amazon Elastic Compute Cloud using pre-built AMIs from IBM for DB2 Express-C – the free edition of DB2.

(Shalom Momi Sabag) This post is somewhat related to a previous post about comparing access path selection between test and production systems.

(Mike Kwong) I am the software architect for InfoSphere Data Architect, and I wanted to spend a few minutes telling you what we’ve been cooking at the Lab over the past few months to deliver Fix Pack 1 for IDA 7.5.2, which was made available on December 11.

(Craig Mullins) Today’s blog entry is a continuation of yesterday’s post in which we began a brief review of the history of DB2 for z/OS. That post covered Versions 1 through 3; so today we pick up our historical review with Version 4.

(Santhosh Kotte, Kartika Garg and Ritesh Kumar Gupta) InfoSphere Information Server’s DataStage module provides many operators and plug-ins for various data sources such as Oracle, DB2, XML, Teradata, and SAP. But the DataStage module does not include a dedicated plug-in or operator to fetch Lotus N