(Leons Petrazickis) Technology Explorer for IBM DB2 is a nifty and light-weight monitoring console written in PHP. It’s a fast and modern way to take a look at a database’s internals and get a very specific idea of how things are. For example, it presents tablespace details in an accessible way.

(Robert Catterall) I was in Denver last week for the North American Conference of the International DB2 Users Group (IDUG). More so than in recent years past, plenty of the talk during this conference was about index enhancements. Several important index-related features have come out over the past

(Willie Favero) In a little more than an hour I am going to present on DB2’s compression (mainframe flavor) at IDUG in Denver. While reviewing my slides I realized that it has been years since I have looked into how effective data compression is on DB2 for z/OS. With that thought in mind, and realiz

(Tian Tan, Chuan Feng Li, Bei Bei Wang, Xiao Xing Liang, Zhe Yan and Yu Chen Zhou) Learn how to enable asset-based development by integrating your applications with IBM Rational Asset Manager. This article describes the capabilities of various APIs for retrieving and modifying repository-based asset

(Bonnie Baker) In Example 4 in my last column (“The Mystery of DB2 Sorts,”), I wrote about how an index could be used for the following SQL statement:

(Leon Katsnelson) This week I am presenting at the International DB2 User Group (IDUG) conference in Denver Colorado. I am presenting sessions on DB2 and Cloud Computing and sessions on building Ruby on Rails applications with DB2. I am also meeting with a number of customers. Yesterday during a mee

(Charlie Jin) This tutorial teaches you how to enable IBM OmniFind Enterprise Edition to retrieve WebSphere Portal Document Manager content from search results through the HTTP streaming servlet that is provided in Information Integrator Content Edition.

(David Beulke) Another situation when a transaction runs into problems is when it must check something outside of the critical transaction path or its normal activity. For example, when a transaction uses seven different discrete web services to accomplish a complete transaction unit-of-work and af

(Venkatesh Gopal) Hi, this is my first time blogging here. I’m an architect in the Data Studio development team, and I work on integrations, heterogeneous database access, and more. I wanted to use this opportunity to tell you about some work I did with pureQuery and Enterprise Generation Language.

(Troy Coleman) The translate function can be a very powerful tool in the SQL coder’s tool belt. TRANSLATE converts a string expression character by character using a “from string,” or translation table, with a matching character in the “to string.”