(Leons Petrazickis) DB2 Express-C 9.7.2 packages for Ubuntu 10.04 LTS are now available in the Canonical Partner Repository. Andre has kindly provided the following installation instructions:

(Paul Mayhew) One of the things I find very powerful in my day to day work as a DBA, is the use of inline shell/awk scripts. I use this technique when I need to do the same thing to many objects. I often use it when I want something quick and dirty or create a base script to work from.

(Kent Milligan) Many applications have logic to capture and record a timestamp that indicates when certain business events occurred, such as when an order was placed or changed. While this application logic is fairly simple, there is still a cost to coding, testing, and maintaining this code. You ca

(Henrik Loeser) Somehow, I had a mental blackout earlier today when I tried to obtain information about the installed DB2 version and couldn’t remember the command. Of course, you can always look into the db2diag.log file. Because DB2 writes an entry with version information and data about the syste

(Abhay Sadadekar) XML is increasingly becoming common as a means for information exchange. A web service application is an example of the type of application that uses XML to exchange information. Any business intelligence product or solution that uses web services must therefore have sufficient cap

(Whei-Jen Chen, David Jay, Javier Sagrera, Krishna Doddi and Manoj Ghogale) IBM Informix is a low-administration, easy-to-use, and embeddable database that is idea for application development. It supports a wide range of development platforms, such as Java, .NET, PHP, and Web services, enabling deve

(Dave Beulke) Materialized Query Tables (MQTs) are really great for DB2 data warehousing situations and also for all types of reporting applications. Combining multiple MQTs is one technique that is good for providing all types of reporting capabilities and answers.

(Qiu Hui Ling, Kuo Yang and Gang Zhan) Learn about advanced query statistics, a new feature introduced in IBM OmniFind Enterprise Edition V9.1, based on query log index technology. This new feature offers access to three critical types of statistical information about searches executed using OmniFin

(Rav Ahuja) This demo shows the functioning of a DB2 pureScale cluster. You can see how the system responds to increase in demand, unexpected failures, and addition/deletion of cluster members.

(Troy Coleman) Years ago when I was a DB2 database consultant, I went into a company that had turned off all ability to sort in DB2. The ORDER BY clause of the SQL statement couldn’t be used because no DSNDB07 sort work was defined. I was told this was done because DB2 sort was so slow and resource-