(Susan Visser) Thanks to Susan Dykman for setting me straight on the details of the upgrade exams. I’m passing the information onto you so hopefully you’ll have less confusions as to which exam you are to take to upgrade to the DB2 9 Database Administrator for Linux, UNIX, and Windows Certification.

(Willie Favero) You are now running in DB2 Version 8 new function mode (NFM). Take a deep breath and give yourself a good pat on the back. You did good. However, completing your upgrade to V8 NFM really means that it is time to start planning your next upgrade, your upgrade to DB2 9 for z/OS. You se

(Karen Devlin) IBM offers a set of industry specific Web services that provide operations to expose the native XML capabilities of IBM DB2. These Web services can be accessed in a Websphere Information Developer module that can be used in a work flow to manipulate your FpML data. Follow step-by-step

(Chris Eaton) The next live chat with the lab is schedule for this Thursday, September 27, 2007 at 8 AM PST, 10 AM Central, 11 AM Eastern, 4 PM London, 5 PM Paris. This session is titled Deep Dive into Deep Compression – a look into Compression in Viper and Viper 2 with the compression features lead

(Craig Mullins) Another utility upgrade that has found its way into DB2 9 for z/OS is the ability to gather histogram statistics. This feature is already available in DB2 for Linux, Unix, and Windows… and after you migrate to DB2 V9 it will be available to you on z/OS.

(Sonali Surange and Becky Nin) With IBM pureQuery technology and tools, detect various problems as you code SQL inside your Java program. Boost productivity developing database applications under different scenarios during a product development and deployment cycle, and customize SQL validation to y

(Akira Shibamiya and Roger Miller) The key DB2 9 performance improvements are reduced CPU time in many utilities, deep synergy with System z hardware and z/OS software, improved performance and scalability for inserts and LOBs, improved SQL optimization, zIIP processing for remote native SQL procedu

(Hardeep Singh) Walk through the steps for creating a sample IBM DB2 application that uses the XML model to integrate data from different data sources. Learn how to expose your database stored procedures as Web services so that they can be accessed through SOAP calls. Follow a Web-oriented architect

(Scott Hayes) The database configuration parameter LOGBUFSZ controls the amount of memory that DB2 uses to buffer I/O to its recovery log files. The default size of 8 4K pages is grossly to small for most databases. This blog post introduces a new metric “Buffer Log Read hit Ratio” and offers tuning

(Azadeh Ahadian) The project code named pureQuery gives database application developers an easy, GUI-based means to significantly increase productivity in both the design and implementation phases. This is accomplished through user-initiated automatic transformation of relational data into Java™ obj