(Roger Sanders) In my last column, I explained how information stored in a database’s transaction log files is used during crash recovery to return a database to a consistent, usable state after a system failure or program abend occurs. Unfortunately, crash recovery can’t help when the storage media

(Anjali Betawadkar-Norwood, Eileen Lin and Ioana Ursu) Data federation gives you a way to integrate the diverse data in your enterprise. This first article in a 2-part series introduces you to federated data concepts and discusses design and configuration considerations for WebSphere Information

A vulnerability was identified in IBM DB2 Universal Database, which could be exploited by local attackers to obtain elevated privileges. This flaw is due to an error when verifying the privilege level of users, which could be exploited by malicious users, with “SELECT” privilege, to insert, update o

(Roger Smith) When IBM shook up the database market by donating its Cloudscape commercial Java database to the open-source community last year, Microsoft’s response was to introduce a free Express Edition of its latest SQL Server 2005 DBMS.

(Andrew Binstock) In a previous article, I presented DB2’s call level interface (CLI) (“Easy, Native Access to DB2 From C and C++”), which is a programming API that enables you to access DB2 from C and C++. That article discussed the many advantages of this approach and briefly touched on what CLI c

(Michael Sansoterra) With the necessity of tight integration between platforms pervading many IT shops, I wondered what interoperability exists between the DB2 Universal Database (UDB) on the iSeries and DB2 UDB for Windows. After a little investigation, I was pleased to find that DB2 SQL on the

(Paul C. Zikopoulos) In this article, I will show you how easy it is to create database objects for your DB2 UDB databases with the assistance of the IBM Explorer and a few wizards. I will not cover every step, but I will highlight key features and productivity enhancements. When features are co

(Chris Eaton) In my last posting I described the differences between SMS and DMS tablespaces. From a function benefit perspective you can summarize the differences in that SMS gives you the best manageability but there is a small (few %) performance hit because you are going through the OS filesyste

(Robert Catterall) Primary key selection decisions are among the more important choices in developing a DB2 database design. In this column, I’ll share my thoughts on primary key selection and explain how changes in recent DB2 versions (for mainframes and for Linux, Unix, and Windows) affect pri

(Jack Vaughan) While software product after software product has been tagged with the WebSphere moniker over the years, products in IBM’s tools catalog have been something of an exception. Not that they weren’t rebranded for a while. (R)