(Ambrish Bhargava and Mario Briggs) When extended with the downloadable IBM Integration Module, the IBM Optim pureQuery Runtime simplifies the process of generating DB2 static SQL for Hibernate and iBATIS applications. It does this without requiring you to make changes to your application code or to

(Willie Favero) I received this notification yesterday from the System z Red Alert subscription service. it seems there is the potential for data lose in a data sharing environment when locks are lost during a rebuild. The actual Red Alert is reproduced in its entirety below.

(Dan Burger) You are sitting on a gold mine of database technology and probably don’t even know it. You have many of the essential pieces undiscovered in your existing system. Untapped capabilities in DB2 for i, the integrated relational database at the heart of IBM i 6.1 and 7.1, can be put to use

(Jennifer Nelson) Learn about the latest feature in the IBM DB2 Utilities Enhancement Tool for z/OS, the Utility Monitor. The Utility Monitor helps you to establish and maintain company-wide best practices for controlling DB2 utilities. By using the Utility Monitor, you can control which DB2 utiliti

(Craig Mullins) A null represents missing or unknown information at the column level. A null is not the same as 0 (zero) or blank. Null means no entry has been made for the column and it implies that the value is either unknown or not applicable.

(Raul F. Chong, Xiqiang Ji, Priyanka Joshi, Vineet Mishra and Min Wei Yao) Getting started with DB2 application development couldn’t be easier. Read this free ebook to: –Discover DB2 application development using DB2 Express-C –Write SQL, XQuery, and understand pureXML technology –Learn how

(Jacques Roy) Learn how to use triggers to implement fine-grained auditing. This article covers the use of the datablade API to generate auditing events from transactions. It also introduces a feature called trigger introspection that allows you to create a generic auditing function that can be appl

(Dave Beulke) Being an IT consultant is always interesting especially when visiting a variety of shops around the country analyzing their designs, practices and performance. The major theme that comes through all these shops is that every company is trying to save money and trim their IT budget.

(Troy Coleman) DBAs who design and organize data warehouses should take the time to read the IBM Redbook, “Enterprise Data Warehousing with DB2 9 for z/OS.” In addition to offering a detailed explanation of data warehousing’s evolution on z/OS, it provides a great description of star schema database

(James M. Siddle and Stephen Godwin) WebSphere Business Events V7 (hereafter called Business Events) is a REST-based API for defining event processing logic. This article describes how to use the new interface to define and publish simple event processing logic through REST resources such as project