(Knut Stolze and Marcel Kutsch) Get the details on how to use the common SQL API (CSA), a set of stored procedures that exist across all IBM data servers. Learn to employ the common SQL API and integrate it in an application. Explore a small J2EE Web application, based on the common SQL API, that co

(Vijay Budde) If a table in the database gets corrupted because of any reason (say a hardware problem), attempts to access the table through SQL may not work and db2 might drop all the connections to the database and even mark the database as BAD.

(Troy Coleman) This is the final installment in a five-part series on tuning batch jobs. In part four I covered Checkpoint Restart.

(Craig Mullins) One of the fun things about publishing is getting questions from readers that make you think. A recent question I received went something like this: “Can I get the odd and even number of rows from a DB2 table?”

(Monty Wright) High availability of data is a key requirement for critical database systems. In this article, get a summary of the features in DB2 9.5 that provide these capabilities. Learn the pros and cons of the different solutions and decide which method is best for you.

(Scott Hayes) The database is often presumed guilty if there is a performance issue. But your database seems fine; all the symptoms of good performance are present, so now how do you prove your databases innocence?

I always hated DB2 for the way it had structured the rollforward to work post restore from an online backup. Most of the times, while restoring to a target database on a different system, I just wanted to rollforward my database till the end of backup and would have liked a single straightforward c

(Anson Kokkat) Hello all. I’m the product manager for Rational Data Architect (RDA), IBM’s strategic data modelling tool. I visit lots of customers and talk to my own colleagues about this product, and I would like to take this opportunity to clear up a few things that I keep hearing over and over

(Peggy Zagelow) I’ve received a few questions about text search in DB2 9 for z/OS lately, so I thought I’d share the basic information here.

(Andre Tost) One of the most critical elements of business process management (BPM) is the availability of information to a business process. This article looks at how you can integrate the notion of Information as a Service, supported by the IBM InfoSphere Information Server product family, with yo