Articles & Content

Archives

DB2 pureXML - live ! (C03)

Topic: DB2 for LUW

Subtopic: 2007



DATE: 2007-11-5 (16:15 - 17:15)
SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab)

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.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Provide a good understanding of the new XML features in DB2 9 through real examples which convey the actual look & feel of XML in DB2

Describe how XML support is deeply integrated in all existing DB2 components by seeing the actual nuts and bolts in DB2 (db2 catalog, explain, etc.).

Cover the details which people have to pay attention to when they start their own hands-on work with XML in DB2. These are the little hands-on details which you often don't see on slides.

Explain XML query execution, and how to get the "right" execution plans.

Another objective is to make my sample commands and scripts (to exlore DB2/XML) available to interested IDUG insiders. They're not available elsewhere. Attendees can repeat my session at home, and dig deeper from there.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.