(Joshua Steffan) Today, databases are at the foundation of a business computing architecture that often includes Web servers, application servers, client workstations, application logic, networks, and other components. Since the database acts as the data server, it can quickly turn into an applicati

(Abdul H. Al-Azzawe) The DB2 Development Center is a great new tool specifically designed for developing server-side stored procedures, user-defined functions (UDFs), and EJB structured data types. This article contains information to help make your Development Center experience a pleasant one. It r

(Manish Verma) The XML Key Management Specification (XKMS) outlines an easy mechanism for accessing and integrating with Public Key Infrastructure (PKI). In this article, Manish Verma explains the objective behind XKMS and then offers a step-by-step guide to using the XKMS service to register and re

(Brenda Castiel) To tame the surprisingly complex challenges catalog publishers face, A2i added its own unique technology on top of a solid DB2 UDB base. Imagine searching a database containing millions of products, each with dozens of searchable attributes and related images and text blocks. Is

(David Kline) DB2 Universal Database uses log files as a primary means of ensuring the consistency and recoverability of data. In an earlier article, An Overview of Transactional Logging in DB2 Universal Database, I introduced transactional logging concepts and explained how logs are managed. In thi

(Clint Boulton) IBM will unravel even more of the yarn of its forthcoming DB2 Universal Database at EclipseCon to curry support from developers. While IBM has previously announced that Stinger will help DB2 interoperate with .NET development tools, IBM will pad DB2’s Java support at the show in

(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip) Transfer of control statements are used to specifically tell the SQL procedure where to continue execution. This unconditional branching can be used to cause the flow of control to jump from one poi

(Howard Fosdick) Certification has arrived, no question. But as a DB2 professional, should you certify? Will it increase your abilities or help your career? How can you do it quickly and inexpensively? That last thought is key — knowing the inside story on DB2 certification before you proceed will

(John Lynch and Yong Ju Li) Recently we decided to evaluate the impact of changing our DB2 Connect software from Cursor Stability (CS) to Uncommitted Read (UR) for ERwin-our database modeling tool. Using the ERwin tool we ran a before and after comparison of the two settings and came back with an in

(Marin Komadina) In the last article, we discovered the DB2 instance memory structure and fast communication manager, together with all of the DBM parameters influencing memory utilization. In this article we we will continue along those lines with an inside view of FCM tuning and troubleshooting te