(Nilesh Ozarkar) Starting with IBM Informix Dynamic Server (IDS) Version 11.50.xC4, you can compress data and optimize storage in IDS databases. The advantages of data compression and storage optimization include significant storage savings, reduced I/O activity, and faster backup and restore. IDS p

(Willie Favero) I just noticed that I’m signed up for what sounds like an interesting teleconference next week on Tuesday, May 5 at 11:00 AM Eastern Daylight time, 10:00 Central Daylight time, and 3:00 PM UTC. With all the talk world wide about the economy, the timing for this teleconference couldn’

(Henrik Loeser) Earlier this month I had asked you about stringIDs in DB2 pureXML. Answer B) from the provided options is correct. DB2 replaces structural information such as element names, attribute names, namespace prefixes and URIs with stringIDs. But what are stringIDs and why are they used?

(Troy Coleman) Sometimes DBAs must clean house. For instance, the DB2 catalog can get cluttered with lots of old software packages. In the past when I’ve had to clean up packages, I’d follow this criteria: 1) Remove when the load module is missing. 2) Keep only three versions of a package. 3) R

(Rajiv Madassery and Sonali Samantaray) This article gives an overview of how you can use Web services for business integration, using two scenarios for integrating WebSphere Partner Gateway and WebSphere Process Server.

IBM recently announced Data Studio pureQuery Runtime 2.1, which now supports client optimization for .NET applications. This capability, previously only available for Java applications, enables transformation of .NET applications to use static SQL, without changing a line of code.

(Leons Petrazickis) New event coming up: DB2 Chat with the Lab Wednesday May 6, 2009, 11:30 AM Eastern / 10:30 AM Central / 8:30 AM Pacific / 4:30 PM London / 5:30 PM Munich

(Mark Mulligan) There are DB2 LUW configuration parameters that can be set to AUTOMATIC and managed by the DB2 automatic memory manager (STMM). One advantage of this is that DB2 will automatically adjust the memory it uses to get the work done based on the characteristics of the current work load an

(Albert Grankin) Do you ever find yourself wishing you had a better way to manage your diagnostic files on your IBM DB2 for Linux or AIX servers? If so, then help is on the way. Here’s a script that helps you archive and maintain these files. And you can further ease the management process by compre

(Curt Monash) I’ve now had a chance to talk with IBM about its recently-announced Oracle emulation strategy for DB2. (This is for DB2 9.7, which I gather has been quasi-announced in April, will be re-announced in May, and will be re-re-announced as being in general availability in June.)