The global Information Integration event of 2005 – IBM Information Integration Live! Learn from industry experts, customers, and partners. Mark your calendars now and check back for more details and updates.

(Roman Melnyk) The definition of a materialized query table (MQT) is based upon the result of a query. MQTs can significantly improve the performance of queries. This article introduces you to MQTs, summary tables, and staging tables, and shows you, by way of working examples, how to get up and runn

(Chris Eaton) So now we are ready to get into some SQL scripts to actually monitor your database (hooray). For the monitoring equivalent of “hello world” let’s look at the DB2 buffer pool hit ratios (yes I’m aware that many folks know that BP hit ratios can be deceiving but it’s the monitor thing th

(Kent Milligan) I created the following function successfully in green screen STRSQL: CREATE FUNCTION MYLIB/FrstMthDay (DateIn DATE) RETURNS Date LANGUAGE SQL RETURN Date(DateIn – Day(DateIn) Days + 1 Day) (R)

(Rita-Lyn Sanders) With more than 175 enhancements to Notes/Domino 7, IBM says there is something for everyone in the latest release of its collaboration portfolio. Yesterday, the company announced that the next-generation version of its e-mail collaboration platform, as well as the newest iteration

(Philip Howard) Or, more precisely, it has started to swoop. As this may be opaque I had better explain: “Hawk” is the codename for the next release (version 8.0) of what used to be the Ascential product suite and is now the IBM WebSphere Data Integration Suite. However, most of the product suite ha

(Susan L. Cline) Building dynamic Web applications is easy using Eclipse, the Web Tools Platform (WTP) for Eclipse, Derby, and Jakarta-Tomcat. Learn how to install and configure all of the required Open Source components, and build a complete web application using JSPs and servlets to store and retr

(Michael Dougherty) Sharing is hard. Even when employees and partners are willing to share, business and technology impediments get in the way. Simply finding shared corporate resources can be a challenge. Sharing documents brings a host of challenges including ownership, access rights, version cont

(Alex Woodie) Five years ago, XML was seen as a cure-all for the escalation of disparate document formats and the new common language for conducting business online. While XML has become a key standard, it hasn’t replaced other types of documents, such as EDI and flat files, which are still in wides

(Chris Eaton) So I’ve talked about what monitoring is in DB2 and how to turn on switches (and their potential impact), now let’s look at how to get monitor data out of DB2. There are three ways to access snapshot information in DB2. The first way is for those folks that write monitoring tools. For t