(Alex Gorelik) Before you can implement any information-centric project like archiving, data privacy, master data management (MDM), data warehousing, data lineage, or application data consolidation, you have to know what data you have, where it is located, and how it is related between systems. For

(Dave Beulke) Within all database systems there are tables that hold transactions or some type of data based on time. These transactions unfortunately build up over time to handle regulatory compliance, infrequent access or support development of historical and trending reports.

(Craig Mullins) If you’re anything like me, you’re constantly looking for DB2 Catalog table and column names. For writing catalog queries, for examining statistics, for looking at your table and tablespace parameters, for many, many things. But it is not very easy to keep reaching for the DB2 manual

(Xiang Cheng, Zhu Liang and Pei Jian Dong) When developing a business process client program, you often need to query process instances, activities, and tasks within a certain process instance by certain business data criteria. This article shows you how to set the custom properties for the process

(Troy Coleman) In last week’s DB2utor blog entry, I listed the top 10 reasons to upgrade to DB2 10. Now comes the fun part of getting into the details of the upcoming release.

(Henrik Loeser) When I first heard about SSacSA (it’s part of the new features in DB2 9.7 FP 2), I thought that this is another typical IBM acronym I had to learn.

(Marichu Scanlon and Kathryn Zeidenstein) IBM Data Studio and Optim Development Studio are related products in the Optim portfolio of integrated data management tools. Although there has been much published on the usage of these tools, little information focuses on using these two products when acce

(Keith McDonald) With DB2 9.7’s introduction of modules and the ability to create an alias on a module, you now have the ability to program to a function or procedure’s interface rather than its implementation. Why would you want to do this? In today’s post, I will go over reasons to program to an i

(Anil Mahadev) Sure is, 1. Ever wanted to get proactive checks done for you?

(Raul F. Chong) DB2 Express-C is the free, community edition of DB2. You can use it as part of your production system, embed and distribute it in your applications, or simply use it for development purposes. All for free!