Tired of presentations and looking at slide after slide after slide...? Want to see the real thing and how the new XML features in DB2 9 actually run? In this session I will project a DB2 command window (in a large font) and go through creating, populating, indexing, querying, and trouble-shooting a DB2 database for managing XML data. This will give you the most close-up look at the array of new XML capabilities in DB2 V9, including XML columns, XML indexes, XQuery, SQL/XML, XML schema support and XML import/export. We will inspect the running system, analyze and improve XML query execution plans, and we'll capture & examine snapshots of our XML activities in DB2. We'll open the hood while the engine's running. You'll see some of the things that can go wrong - and how to avoid or fix them. And there is no such thing as don't try this at home: the entire demo scenario incl. test data and all commands & scripts will be made available to the attendees on the IDUG Insider.
00:58:00