(Troels Arvin) DB2 is usually a rather strict database system: It doesn’t allow you to drop a procedure which is being used by a function. It uses pessimistic locking. It typically forces you to back up a tablespace if you aggressively load data into a table if the database isn’t using circular logg

(Srinath Duvuru and Mirav Kapadia) The B-tree scanner is a feature of IBM Informix Dynamic Server (IDS) that cleans dirty index items and compresses B-tree leaf pages. In this article, you’ll gain a better understanding of how the B-tree scanner works and learn techniques for leveraging this feature

(Craig Mullins) Availability requires much more than just having a reliable hardware and database platform. Most companies cannot afford significant downtime, and some cannot afford any! As such, it is crucial for unplanned outages to be as short as possible. But it is not just a business requiremen

(Suresh Krishna) IBM Rational Team Concert is a collaborative software delivery environment that empowers project teams to simplify, automate and govern software delivery. In this tutorial, you import a sample application from the Google Web Toolkit (GWT) into Rational Team Concert using Subversion,

(Bonnie Baker) In my previous column, I promised to solve three DB2 for z/OS mysteries, one at a time. That article addressed the first one: the mysterious SIX lock and one situation in which this useful lock might occur. This column explains the second: the anomaly of index-only updates and deletes

(GGZ) DB2 for z/OS clients are very CPU-conscious. So are we the developers in DB2, and performance has been one of the most critical factors during our design and development for XML support. We probably have one of the most efficient XML parsers implemented in software in the world, co-designed an

(Aay Dee) Today I will show you a simple way to link values from multiple rows to a single column on a DB2 SQL DBMS. In my sample table I listed the Formula 1 Championship world champions of the last 10 years. The table contains one entry for each year.

How can I tell if a character column contains a valid representation of numeric data? I have a column expression in a Select statement that needs to convert character Column A to numeric only when it contains a valid numeric representation. If Column A doesn’t contain a numeric representation, then

(Robert Catterall) I recently fielded, via e-mail, an entertaining question about "pinning" a DB2 table in memory (i.e., having the whole table resident in virtual storage on the DB2 server). I use the term "entertaining" not to poke fun at the question (or the questioner), but to convey that I enjo

(Neelam Solenki) This article describes the step by step procedure for integrating IBM Lotus Connections with IBM Tivoli Access Manager V 6.0. It is intended to help administrators protect the features of IBM Lotus Connections via the Tivoli reverse proxy solution known as WebSEAL and provide the co