(Richard Corrihons) This document details a methodology you can use to identify the dynamic SQL statement that generated a lock escalation. It describes which traces to start, and which jobs to run to analyze the collected traces. It also explains how to analyze the trace report to find the culprit

(Vikram S. Khatri) This article presents a very simple and powerful tool that enables applications from Oracle to be run on IBM DB2 Version 9.7 for Linux, UNIX, and Windows. The tool can also be used to move data from various other database management systems to DB2 for Linux, UNIX, and Windows and

(Kent Milligan) If choosing the YES option for the reused deleted records function on a packet filter (PF) is so beneficial, why is it not the default setting when creating a physical file? (R)

(Henrik Loeser) Starting with version 9.5, DB2 switched from a process-oriented architecture to a multi-threaded system architecture. One of the reasons was to better exploit the current and upcoming HW architectures.

(Darrell Roberts) WebSphere Commerce uses primarily EJB entity beans as its persistence layer. Entity beans wrapped with access beans provide an object-oriented approach to accessing data in the database. The component services programming model uses the WebSphere Commerce Data Services Layer compon

(Kent Milligan) What is the difference between an access path and an open data path? When would an access path be created, and when would an open data path will be created? Can you provide an example of when to use each? (R)

(Henrik Loeser) When a new version of DB2 comes out, it is always very interesting to visit the DB2 Information Center (see my old post here). One reason is to read the “What is new” documents. They give a good overview about all the changes, not just what has been in the marketing focus.

(Peter M. Newby) This article provides a general solution to the problem of record selection based on a large list of non-primary-key values. It is a step-by-step guide to building a new verb which selects records based on a match between dictionary values and standard IBM UniData SAVE.LIST and SELE

(Robert Catterall) I’ve been doing a lot of presenting lately on the topic of DB2 for z/OS stored procedures. In these presentations, I’ve emphasized the benefits of native SQL procedures, introduced for the mainframe platform via DB2 9 for z/OS (I blogged on the importance of this development in an

(Jeff Olen) To encourage native System i developers to make the switch to PHP, the Zend Core provides some data access methods that closely resemble native file access on the System i. If you’re used to using SETLL, READ, CHAIN, and UPDATE in RPG, you may find these data access methods more intuitiv