(Bill Arledge and Judy Quenet) DB2 for z/OS incorporates unique relational characteristics with traditional database capabilities, including robust locking mechanisms that ensure data integrity while maximizing concurrency for the world’s most sophisticated DB2 applications. DB2 locking is a broad

(Jason V. Ma and Ming-Pang Wei) One of the daily challenges facing application developers and database administrators is dealing with performance issues. While many performance issues lie with database servers, some are associated with the client application. This article brings insight into diagnos

(David Beulke) Supporting multiple systems and dealing with application developers and managers who often don’t have a clue makes the DBA’s job a challenge. Fortunately, DB2 9 for z/OS offers a new optimistic locking feature that can improve system performance-and perhaps the DBA’s (and application

(Willie Favero) If you’re a z/OS person (or still refer to yourself as an MVS System Programmer) I can almost guess what goes through your mind every time you find out that there is a new version of DB2 available to install. You think “new version means new EARLY code means another IPL of my system”

In our previous posts, we had covered re-naming of objects in SQL Server and re-naming of tables and columns in Oracle. In this post, we will cover how one can re-name a table in DB2 LUW. In DB2, there is no straight way to rename the column. One has to drop and re-create the table with new column n

(Russell Butek) Many consider the aggregation function as an integral part of an Enterprise Service Bus (ESB). While the IBM WebSphere ESB product does not provide an aggregation function and includes no aggregation primitives, you can write your own. This article provides two sample aggregation pri

Based on feedback from early users, Deep Compression is a hugely-popular feature of DB2 9 for Linux/UNIX/Windows, IBM’s latest data server. To highlight this feature, the International DB2 Users Group (IDUG) is pleased to announce the IDUG DB2 9 Deep Compression Challenge, a non-competitive industry

(Craig Mullins) DB2 Version 9 improves support for coding optimistic locking techniques. What is optimistic locking? Sometimes referred to as optimistic concurrency control, optimistic locking is basically just what it sounds like. We are optimists and think that usually we will be the only ones wit

(Willie Favero) Sound cryptic enough? Actually, it’s not meant to be. Rather, this is my way of giving you a heads up about a blog entry from last month (July 21, 2007). That post described the ODBC related APAR PK15288 that closed ( “Are you running ODBC applications? Then here’s a nice APAR for yo

(Burt L. Vialpando and Vikram S. Khatri) In DB2, a materialized query table (MQT) is a table whose definition is based on the result of a query. As such, the MQT typically contains precomputed results based on the data existing in the table or tables that its definition is based on. If the query com