(Masahiro Ohkawa, Soh Kaijima, Gou Nakashima and Asuka Tokunaga) IBM Database Encryption Expert provides features to encrypt and control access to data written to file systems and database backup images. Beginning with Version 1.1 Fix Pack 3, the product supports both DB2 and Informix Dynamic Server

(Michael Sansoterra) Is there a book on how RPG operation codes and built-in functions translate to SQL? I’m trying to leverage my RPG coding skills to write logic in a DB2 stored procedure. That is, I know exactly what to do in RPG, but I don’t know the SQL equivalent.

(Susan Visser) The recommended study guides to prepare for the DB2 certification study guides include: –DB2 9 Fundamentals Certification Study Guide by Roger Sanders –DB2 9 Database Administration Certification Study Guide for Exam 731 by Roger Sanders –DB2 9 Database Administration Certifi

(Bryan Smith) I had two recent visits with customers where I was explaining pureQuery. When I finished what I thought was a nice polished presentation on the subject, both times someone said, “So, I have to use those pureQuery APIs in order to turn my dynamic SQL into static SQL.” Ugh. You know t

(Dave Beulke) As I talked about last week, DB2 Version 9 for z/OS has over 50+ great new performance features. Many of these really stand out and in the coming weeks I will write about some that can really help you reduce your CPU demand on your system and application environments.

(Wei Liu) IBM InfoSphere Data Architect (IDA) is a comprehensive development environment for data modeling and integration. IDA enables users to discover, model, visualize, and relate diverse and distributed data assets. IDA is an integrated data management offering from IBM and is tightly integrate

Christopher MacLaughlin, Thunderhead Chief Marketing Officer talks about how Thunderhead improves personalized in-context communications for their customers by utilizing DB2 pureXML. Thunderhead provides customers in insurance, financial services, investment banking, health-care, public sector and o

(Troy Coleman) One of the DBA’s primary jobs is to ensure that data is safe and recoverable from any unexpected disastrous event. DB2 provides several utilities to help backup the data either at a volume level, using the BACKUP SYSTEM utility, or at a table/index space level, using the COPY utility.

(Josef Klitsch) With IBM Data Web Services you can easily integrate database operations in a Service Oriented Architecture (SOA) by transforming single SQL operations into Web services. Valid SQL operations that you can transform include SQL DML-initiated user-defined function (UDF) invocations.

(Mark Wilding) I finally had a chance to try out IBM’s up and coming Development and Test Cloud this morning (currently a tech preview). Within 10 minutes I had an 8-way Intel(R) Xeon(R) CPU system with DB2 pre-installed and already running. With a quick comparison, I found that the top system I cou