And, IBM PureData Systems have been keynoted at the conference! If you cannot attend IOD, then kick start your learning on PureData Systems with the DB2 Tech Talk this Wednesday Oct 24th. We will also cover other hot news from IBM and…

Register today and take advantage of the complimentary DB2 10 for z/OS New Functions and Migration Planning Workshop co-presented by Julian Stuhler, IBM Gold Consultant and Mike Bracey, IBM DB2 for z/OS Systems Engineer. The workshop will be held at the IDUG Technical Conference in Berlin on Sunday 4th November 2012 at 9.30am.

Attendees can expect to broaden their understanding of the features delivered in DB2 10 for z/OS, as well as the business…

On a previous post I showed how to insert parent-child data from an XML document using stored procedure. Well here I am going to show how to retrieve data from a table as an XML document. Using the table set of tables from the previous post lets retrieve all the order details for a given customer. Here is a stored procedure that will take customer_id as an input and then return an xml document that has all the orders and…

Couple of days back I wrote an article that showed how to quickly insert a child table with a parent table having generated column. On this one I am going to show you how to insert data using XML as a value. As my previous article show its easy to insert to child table , but you have to insert one row at a time. Well what if we have multiple child rows…

You may have seen the recent video here on ChannelDB2 that introduces auditing of DB2 changed data. If you're interested in giving it a quick try, it's easy set up a simple configuration and see what you get. That's what I'm going to show you how to do in this post. It should take about 5-10 minutes. We'll use DB2's SQL Replication. It's provided with all editions of DB2 and InfoSphere Warehouse…

Hear from Penny Scharfman, IBM Rational Segment manager, Power and Compilers and Chris Crone, IBM Distinguished Engineer, DB2 for z/OS Development, why it is important to stay current on COBOL, PL/I, and C/C++ compilers when upgrading to DB2 V9/V10. Learn about compiler features that can help your developers become more productive with DB2 applications. Listen the replay

A couple of months ago, IBM announced enhancements to its data replication in support of DB2 v10 for UNIX and Windows. This month, IBM released an update to its Q Replication Dashboard that supports those enhancements and much more. In fact, most the Dashboard's enhancements can be used with Q Replication for DB2 z/OS, too. This post takes a quick look at…

Announced April 3 and available electronically today, InfoSphere Federation Server V10.1 offers data virtualization through a robust SQL interface and a full relational database engine designed for global optimization of data access. It helps you quickly prototype and implement solutions involving disparate…

As promised this new format is more flexible, enabling us to respond to exciting news like the DB2 10 and InfoSphere Warehouse 10 product announcements. Check out the coverage, where we feature an overview of the release; a…

Where can you get technical articles that provide an in-depth discussion about a DB2 database solution? How about tutorials to guide users through an unfamiliar feature? The answer is IBM developerWorks. And yes, there are plenty of articles there!

Every month I'll be casting your attention to various technical papers for the DB2 database product. The list will include articles, tutorials and information roadmaps - all extremely useful resources whether you're…