Articles & Content


10 Things Every DBA Should Know About DB2 pureXML (E06)

Topic: DB2 for LUW

Subtopic: 2010

DATE: 2010-11-9 (14:15 - 15:15)
SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab)

This session explains the top 10 most important features for the administration of DB2 databases that contain XML data. You will learn about DB2's XML storage objects, default system indexes for XML, user-defined XML indexes, and new tables in the DB2 catalog that describe all these objects. This session further provides guidelines for monitoring XML data growth, compression, and handling XML in utilities such as Load, Import, Export, Runstats, and Reorg. A discussion of DB2's XML Schema Repository and several critical XML performance tips complete this presentation, which can serve as an "XML cheat sheet" for DBAs.

EXP. LEVEL: Beginner,Intermediate,Advanced


Understand the XML-related database objects -incl. new storage objects, new system indexes, user-defined XML indexes, XML schemas- and how they relate to each other.

Take home useful catalog queries that provide a quick overview of XML storage, indexes, and schemas in your database.

Learn how to estimate and monitor XML space consumption correctly.

Understand how DB2's utilities handle XML data or a combination of XML and relational data.

Understand how the physical database and table space configuration affects XML performance.

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.