(Craig Mullins) DB2 V9 offers some encryption news, but we need to go back a version to start the story. You see, DB2 supports encryption in Version 8 through encryption functions that need to be explicitly coded in order to encrypt and decrypt data.

(David Stodder) Put the right information in the right hands at the right time: that’s been the mantra of business intelligence (BI) since the beginning. But today, the parameters are changing for how the BI and data warehousing (DW) community delivers on that goal. What’s the right information when

(Jane Fung) This tutorial introduces you to WebSphere Integration Developer. It includes three hands-on exercises in which you’ll assemble existing services to create a BPEL business process. The Hello World tutorial for WebSphere Integration Developer V6.0.1 is still available. (R)

(Paolo Bruni and Jeff Berger) Compression has been available for table spaces on z/OS since DB2 Version 2.3. In data warehouse applications, it is common to have many very large indexes defined on large tables. It is also possible that the index spaces exceed the size of the tables upon which the in

(Trevor Eddolls) Last week I was talking about AIX 6, which IBM is making available as an open beta – which means anyone can test it out so long as they report their findings to IBM. This week I want to talk about Viper 2, the latest version of DB2 9, which is also available as a download for beta […]

(Hardeep Singh) Learn how the new XML storage and query environment of IBM DB2 9 for Linux, UNIX, and Windows plays into the XML data model described in Part 1 of this series. Part 2 focuses on how to exploit the improved database support for XML in your application architecture.

(Willie Favero) Oh my gosh, I can’t believe it!!! Actual DB2 content in a DB2 blog (Skip the excessive rhetoric). Will wonders ever cease? Yes, it has been a dry week or so and I apologize for not having any technical details for a while. Redbooks, white papers, articles, article editing, preparing

(Sam Lennon) More developers are using embedded SQL in their applications, and some treat the SQLCOD return value as a two-valued field, just like the on/off end-of-file indicator in native file access. In this article, I want to show you that treating SQLCOD like an on/off indicator can be dangerou

(Ronald C. Privett) Configure and manage all forms of replication options available with IBM Informix Dynamic Server (IDS) 11. The seventh in a series of eight tutorials, use this tutorial to help prepare for the IDS 11 exam 918. (R)

SQL Server Mode is a database application environment that is unique to the IBM System i platform. When SQL Server Mode is used, database connections establish a one-to-one relationship with a QSQSRVR server job. When SQL statements are executed in the client job, the corresponding QSQSRVR server jo