(G Michael Connolly, Jo Johnston, Erdmann Treffurth and Eran Yona) This paper book provides a detailed step by step configuration guide to setting up a Standalone WebSphere Application Server Cell and then implementing WebSphere Process Server with DB2 in that cell. We decided to configure WebSphere

(Craig Mullins) Today we continue our investigation into the new functionality in DB2 9 for z/OS… and specifically into the improvements made to IBM utilities for version 9. We will turn our attention to improved availability with IBM DB2 utilities. Under DB2 V9, three more utilities can run onlin

(Willie Favero) Continuing our conversation from Monday, I had just a few last thoughts on this subject (I assume they are my last thoughts on this subject but who really know for sure).

(Troy Coleman) Most applications on z/OS are written in COBOL and use static SQL. With static SQL you know the columns, tables and filter criteria needed before run-time execution. This is the most efficient way to access DB2. The program source code goes through a precompiler to pull out all of the

Yes, DB2 for z/OS programmers, you do acquire tablespace and table locks. Bonnie Baker cracks open the mysteries surrounding the different locking levels and when to use them. (R)

(Vaibhav Srivastava) Business Intelligence Reporting Tool (BIRT) is an open source relational reporting solution. It provides an Eclipse-based plug-in for report development and testing, and it provides J2EE deployment and APIs that can be used in custom Java applications. With IBM DB2 Data Warehous

(Willie Favero) For some reason it seems like the only time I write about multi-row processing delivered by DB2 for z/OS Version 8 lately is when I’m in a hotel. This time though I’m not stranded. This time I’m in Poughkeepsie on purpose…

(Scott Hayes) The Catalog Cache is like a special memory bufferpool dedicated to catalog objects; it stores information about tables, indexes, views, and other objects to speed up the BIND process for dynamic and static SQL. It CAN be changed online dynamically, but it DOES NOT participate in DB2 9

(Snehal Antani and Robert G. Alderman) Resiliency —defined as the continued availability and performance of a service despite negative changes in its environment—is vital in a Service-Oriented Architecture (SOA). An SOA infrastructure must ensure that a service is highly available regardless of unpr

(Robert Catterall) I don’t mean to imply that effective DB2 performance monitoring and tuning comes down to tracking one number – there are about a dozen or so DB2 monitor fields on which I tend to focus in my work. I do feel that one metric stands alone as being the most useful and most illuminatin