Articles & Content


15 Best Practices for XML Performance in DB2 9 (H04)

Topic: 2007 NA

Subtopic: DB2 for LUW

DATE: 2007-5-7 (04:20 PM - 05:20 PM)
SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab)

DB2 9 introduces pureXML support, which means that XML data is stored and queried in its inherent hierarchical format. To query XML data, DB2 offers two languages, SQL/XML and XQuery. Additionally, DB2 9 has sophisticated XML indexing capabilities and support for XML Schema validation. While many existing performance guidelines for DB2 also apply to XML data, additional performance considerations apply to XML. This sessions presents 15 XML-specific performance tips for DB2, illustrated with examples. This includes a discussion of common mistakes and how to avoid them.

EXP. LEVEL: Beginner


Make the audience aware of XML specific performance issues and trade-offs

Enable attendees to detect and fix XML performance issues

Provide concrete examples for queries, create index statements, table space settings, etc.

Explain how to avoid common XML performance mistakes in DB2 9

Explain how XML and relational can coexist and be used together without performance penalty

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

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