(Keith McDonald) On a busy system, sometimes the amount of data returned by our monitoring tools can be overwhelming. Fortunately, db2top was designed with this in mind and has a very flexible and powerful feature for extracting the information critical to your decision-making from reams of monitori

(Robert Catterall) More items of information from the 2010 International DB2 Users Group North American Conference, held earlier this month in Tampa (in fact by the bay — the convention center is on the waterfront).

(Conor O’Mahony) I just saw some very interesting information that I thought was worth sharing. It concerns that amount of time needed to certify new releases of IBM DB2 and Oracle Database for SAP.

(Sergiy K. Fastovets and Andre Weiser) The article explains how to troubleshoot deadlocks occurring in a WebSphere Process Server (hereafter called Process Server) application configured with a DB2 database. The most common reasons for deadlocking are discussed and suggestions are provided for deadl

(Curt Cotner) As I’ve been visiting various customers and presenting at conferences, I’m finding that there is a lot of interest in our new performance monitoring capabilities in Optim Performance Manager. One of hottest topics in that area is the new statement-level performance metrics. These wer

(Keith McDonald) If you remember the previous post, I showed how moving some logic from an anonymous block into a scalar function caused the program to start reporting an SQL0577N, saying that the underlying procedure was trying to modify SQL data even though it was doing no such thing. The clue to

(Robert Catterall) A growing database can be a good news/bad news thing. On the one hand, a database that’s getting bigger is something to smile about if it reflects growth in a company’s business: more sales, more customers, more prospects. On the other hand, bigger can be bad when the increase in

This demo showcases native support for PL/SQL in DB2 9.7, which makes it easy to enable Oracle applications, procedures, packages, etc. to DB2.

(Conor O’Mahony) IBM is continuing to play the role of liberator, allowing users who thought they were locked-in to another DBMS vendor to switch to DB2. Last year, IBM added support to DB2 for syntax and features that make it easy for users to switch from Oracle Database to DB2 (See PL/SQL Support

(Paul Pendle) Storage isn’t “just storage” anymore. There are high speeds, low speeds, and in-between speeds, and each is best suited for different uses. Where should you store data to achieve the best return on investment? This article will explore how to create a tiered approach to storage with IB