(Troy Coleman) IBM just released an alert regarding potential data corruption for IMS and DB2 for z/OS following rebuild of lock structures in data sharing mode.

(Conor O’Mahony) Those of you who follow DB2, are only too aware that IBM is doing everything in its power to provide the very best value in database software. IBM made a massive investment to develop pureXML—true native XML storage that is clearly superior to the confusing array of XML storage opti

(HongDong Zhao and XiaoLing Cui) The ECM step completion widget is designed to satisfy many companies’ requirements for building a business process management solution. In ECM Widgets 4.5.2, the ECM step completion widget provides several events to enable you to create a custom step completion widge

(Scott Hayes) In episode #31, special guest Sheryl Larsen, IBM DB2 GOLD Consultant and Owner www.SMLSQL.com, aired her dirty laundry! Well, her client’s dirty laundry that is! In this informative episode, Sheryl examined SQL performance lessons learned from recent consulting engagements with clients

(Edward F. Moltzen) More than anything, the database software market is in the throes of a massive brawl, major changes in IT deployment, and big changes in what’s available to solution providers to deliver value.

(Vitor Rodrigues) pureQuery is a high-performance data access platform that makes it easier to develop, optimize, secure, and manage data access. It consists of tools, APIs, a runtime, and client monitoring services. The previous articles in this series introduced the use of data access objects (DAO

(Henrik Loeser) On October 5th IBM announced a new edition of DB2 for Linux, UNIX, and Windows: The DB2 Advanced Enterprise Server Edition (AESE). It is based on the Enterprise Server Edition (ESE) and bundles several of the most valuable (in terms of usefulness) features into a single package.

(Willie Favero) You keep hearing about this and that trace that you should be running: statistics class 1,3,4,5, and 6, accounting class 1,2,3,7,8, audit, performance, etc… Even in this blog, every few months I discuss some trace that you should consider starting or expanding.

Please complete the following form to receive a complimentary copy of “Using formulas to partition DB2 for z/OS tablespaces” by DB2 expert Daniel L. Luksetich and learn key SQL tuning tips, including:

(Craig Mullins) After publishing the last blog post here on the topic of pesky problems that crop up when dealing with nulls, I received a comment lamenting that I did not address the IS [NOT] DISTINCT FROM clause. So today’s blog post will redress that failure.