(Craig Mullins) Anyone accustomed to application programming when access to a database is required understands the potential for concurrency problems. When one application program attempts to read data that is in the process of being changed by another, the DBMS must forbid access until the modifica

(Willie Favero) Six (6) of the DB2 9 for z/OS product publication have been updated in June 2009; “Administration Guide”, “Application Programming & SQL Guide”, “Application Programming Guide and Reference for Java”, “Codes”, “Internationalization Guide”, and “Messages”. In addition, the “DB2 Access

(Sonali Surange) Optim Development Studio, previously known as Data Studio Developer, takes new strides towards realizing IBM’s Integrated Data Management vision. This article explains how developers, architects, and database administrators (DBAs) can collaborate in new and productive ways in hetero

(Willie Favero) Way back on April 10, 2007 (yes, that’s more than two (2) years ago) I published a blog entry about the RANDOM keyword on the CREATE/ALTER INDEX statements that was introduced in DB2 9 for z/OS. That entry was titled "DB2 may help fix contention from index hot spots" . There wasn’t m

(Robert Catterall) A few days ago, I was working with a team of people from a large company, trying to improve the performance of some queries executing in a DB2 for z/OS-based data warehouse environment. One query in particular was running much longer than desired, and consuming a lot of CPU time,

(Alan Yaung and Mimi Vo) IBM Content Manager is a scalable, high performing content repository, while IBM FileNet Business Process Manager (BPM) is a comprehensive suite of products for managing business processes involving people, content, and systems. The integration of IBM Content Manager with Fi

Getting started with DB2 couldn’t be easier. Read this book to: –Find out what DB2 Express-C is all about –Understand DB2 architecture, tools, security –Learn how to administer DB2 databases –Write SQL, XQuery, stored procedures –Develop database applications for DB2 –Practice us

(Troy Coleman) Even after more than 20 years of working with DB2 for z/OS, I still wonder which IBM product I need to connect an application running on a workstation to DB2 for z/OS. What’s confusing is the myriad of options and product name-changes.

(Nitin Gaur) HTTP session management is a function offered by Java Enterprise Edition (JEE) application servers. It allows JEE applications to store state information about a given user across many HTTP requests. The JEE specification provides an API to store and retrieve information specific to the

(Dave Beulke) Going through the DB2 9.7 Cobra beta was very educational for learning about the new features and functions. In the video below I and several of the other beta customers talk about their companies’ experiences with DB2 Version 9.7 and what features they liked best about the new DB2 rel